Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

avatar
Explorer

 

 Hi Everyone,

 

I just trying to execute the sqoop command below to create a new hive table :

 

sqoop import \
--direct \
--connect jdbc:postgresql://localhost/testdb \
--username hive -P \
--hive-import \
--create-hive-table \
--table claim \
-- --schema hivetest \
--num-mappers 4 \
--target-dir '/user/user/datawarehouse' \
--warehouse-dir '/user/user/datawarehouse' \
--split-by id \
--hive-overwrite \
--hive-database edb

 

 But then I get the error below... 

Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-1.1.0-cdh5.13.1.jar!/hive-log4j.properties
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClie

 

 Can someone advise me how to fix this?

 

 Thanks in advance.... 

2 REPLIES 2

avatar
Champion

1 . just run plain sqoop list-tables

 2. see if the port is listiening - 5432

 

3. is your jdbc jar in place 

postgresql-9.2-1002.jdbc4.jar (Example ) 

avatar
Explorer
Something I forgot to mention... this thing was working and all of the sudden stopped.
Port is listening and jar file is in place..