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.)
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)
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.