Not able to run Hive queries

Question

I am trying to execute some Hive commands. I try to run this command in Hive terminal:

bin/hive -e 'LOAD DATA INPATH 'kv1.txt' OVERWRITE INTO TABLE pokes;'

I get the following output:

Hive history file=/tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201111301549_1377455380.txt
FAILED: Parse Error: line 1:17 mismatched input 'kv1' expecting StringLiteral near 'INPATH' in load statement

Can someone tell me how to execute the query?

Answer 1

Try

bin/hive -e 'LOAD DATA INPATH kv1.txt OVERWRITE INTO TABLE pokes;'

Answer 2

If you are loading your data from hdfs you should create a directory in hdfs and then load your data with its full path in hdfs. This would solve your problem.