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:
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;
Hey @chaitanya_narala. The command mentioned in the answer does not update the hive version.
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:
You can use the get_json_object function to parse the ...READ MORE
You dont have to specify the file name ...READ MORE
create table books(isbn string, book_title string, ...READ MORE
You can load data from flat files ...READ MORE
Firstly you need to understand the concept ...READ MORE
org.apache.hadoop.mapred is the Old API
org.apache.hadoop.mapreduce is the ...READ MORE
put <localSrc> <dest>
copyFr ...READ MORE
In your case there is no difference ...READ MORE
You have to add the partition before ...READ MORE
First, copy data into HDFS. Then create ...READ MORE
Already have an account? Sign in.