AnsweredAssumed Answered

Hive can't find CLDB

Question asked by Terry on Jul 11, 2016
Latest reply on Jul 12, 2016 by Terry

I'm running version 5.1 and trying to get Hive working. Installed hive-1.2 under Ubuntu, and installed hive-0.13 hivemetastore on RedHat (the mismatch is disturbing) within the cluster. As I interpreted the instructions, I need to install  hivemetastore and hiveserver2  on different nodes. All seems to be OK creating tables and basic select, etc. But when I moved on to my actual use case, I discovered I hit trouble when I add the "LOCATION" statement. (I shortened the actual input here to try and find the offending statement.)

 

<code>

hive> CREATE EXTERNAL TABLE junk (ts bigint, ts_usec double)

    > LOCATION 'hdfs://user/thealy/pcaps/';

 

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: java.io.IOException Could not resolve any CLDB hostnames for cluster: user:7222)

</code>

 

I would suspect syntax, but the same statement works fine without the "LOCATION" statement; I believe I have set up user impersonation correctly, but get the same error.

Outcomes