Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
Labels:
- Labels:
-
Apache Hive
-
Apache Sqoop
-
Cloudera Manager
Explorer
Created on ‎02-20-2018 09:32 PM - edited ‎09-16-2022 05:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Champion
Created ‎02-20-2018 09:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 )
Explorer
Created ‎02-20-2018 10:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Something I forgot to mention... this thing was working and all of the sudden stopped.
Port is listening and jar file is in place..
Port is listening and jar file is in place..
