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.

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

Expert Contributor
This HCC thread suggests this has been resolved in newer Kite versions:

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

- Dennis Jaheruddin

If this answer helped, please mark it as 'solved' and/or if it is valuable for future readers please apply 'kudos'. Also check out my techincal portfolio at https://portfolio.jaheruddin.nl
Don't have an account?
Coming from Hortonworks? Activate your account here