Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the

Sqoop export from Hive to Oracle fails with org.kitesdk.data.DatasetNotFoundException

Sqoop export from Hive to Oracle fails with org.kitesdk.data.DatasetNotFoundException

Explorer

All,

 

I have a partitioned hive table which i want to export to an ORacle table.

 

Sqoop statement

----------------

sqoop export -D mapred.child.java.opts="-Djava.security.egd=file:/dev/../dev/urandom" --connect jdbc:oracle:thin:@//<host:Port>/<DBNAME>  --username <user> --password <password> --table <oracletable> --export-dir /user/hive/warehouse/<db>/<hivetable>/<partition1>/<partition2>  --enclosed-by '\"'

 

 

Env:

-----

CDH 5.3.0

Sqoop 1.4.5

Hive 0.13

 

 

Error:

----

org.kitesdk.data.DatasetNotFoundException: Descriptor location does not exist: hdfs://<namenode>:8020/user/hive/warehouse/<db>/<hivetable>/<partition1>/<partition2>/.metadata

 

Please help resolve this or suggest a better option to export a partitioned hive table data to Oracle table.

 

Regards

Suresh

 

 

 

 

1 REPLY 1
Highlighted

Re: Sqoop export from Hive to Oracle fails with org.kitesdk.data.DatasetNotFoundException

Rising Star
This HCC thread suggests this has been resolved in newer Kite versions:

https://community.hortonworks.com/questions/38479/issue-when-using-parquet-orgkitesdkdatadatasetnotf...