2014년 12월 31일 수요일

[hue-user] Query

I am a novice using the CDH, I am trying to Run Hive queries from Hue,

While loading a file in Hive table, hue is not detecting the hdfs path (abosulte).
Can you please help
Also at potential misconfiguration, its saying "configuration files located at /var/run/scm---"




Do you mean adding a file as a resource?
Could you share a screenshot + the logs file from the log tab of the query?



Please find attached the screen print. I guess its very basic error, you might not have to look into logs.

mozilla.pdf



I believe this is an old HiveServer2 bug in CDH4. Any chance you could upgrade to a more recent version? (5.3 was released last week)



ok, all i have to do is to download the newer version i.e 5.3 right ?



Yes, at least 5, and 5.3 is the recommended one!




I installed CDH 5.3, ran the similar query , but still not working. Seems I am doing some silly mistake. Please find attached the screen print. I have created one table "employees" and trying to load a file from HDFS, which is at /user/cloudera/SampleData/Emp/Empdata. Its popping the error as in attached PDF.

As a workaround, I was able to move the file using hadoop fs commands in the /user/hive/warehouse/employees directory from /user/cloudera/SampleData/Emp/Empdata

mozilla.pdf



Load data inpath 'hdfs://quickstart.cloudera:8020/user/cloudera/SampleData/Emp'
overwrite into table mydb.employees;

Tried giving the full path of HDFS as well.. but same result.


댓글 없음:

댓글 쓰기