Not able to insert data into hive table

Question

I am trying to insert data in hive table using this command:

insert into test_table values(1,'xyz');

But I am getting this error:

Answer 1

Seems like a hive version problem.​ insert operation is supported from hive 0.14 version onwards. Maybe you are using a lower version of hive. You can try below command to insert the data in your table,

hive>load data local inpath 'input_file' into table test_table;

Comments

So will this command also update my version?? plz respond...

---

Hey @chaitanya_narala. The command mentioned in the answer does not update the hive version. 

The command

load data local inpath 'input_file' into table test_table;

is just a command used to insert data into Hive table for Hive version lower than 0.14.

For Hive version from 0.14 onwards, the command used to insert data into the table was changed:

insert into test_table values(1,'xyz');