hive -e "select * from merkle.cmst_idp_raw_orc where quarter=201603 limit 1" > output.txt
16/07/28 10:56:02 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist
Logging initialized using configuration in file:/etc/hive/18.104.22.168-258/0/hive-log4j.properties
Failed with exception java.io.IOException:java.lang.RuntimeException: serious problem
Answer by mqureshi
Jul 28, 2016 at 03:51 PM
Is there more in the log? Which user runs beeline and which user runs hive -e? Have you set the following in your core-site.xml?
Answer by Sunile Manjee
Jul 28, 2016 at 07:27 PM
@Ram D please try setting this param and rerun
Please post if you are still getting the error message after setting param.
Up to 5 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Answers and Comments
Error: Error while compiling statement: FAILED: SemanticException SELECT DISTINCT not allowed in the presence of windowing functions when CBO is off (state=42000,code=40000)
ORC does not support type conversion from STRING to CHAR
Error Hive Query
HIVE error- Unable to open a session
Query on Hive Commands / Beeline
© 2011-2016 Hortonworks Inc. All Rights Reserved.
Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.
Terms of Service