Re: Error while exporting table data from hive to Oracle through Sqoop

2013-03-06 Thread Jarek Jarcec Cecho
Hi Ajit, would you mind upgrading to Sqoop 1.4.3 RC 0 [1]? It has been already voted to be released as the final 1.4.3, so it should be safe to use. One of the improvements in 1.4.3 is SQOOP-720 [2] that significantly improves the error message in this scenario. Jarcec Links: 1: http://people.

Re: Error while exporting table data from hive to Oracle through Sqoop

2013-03-05 Thread Dean Wampler
>From the exceptions near the bottom, it looks like you're inserting data that doesn't have unique keys, so it could be a data problem. On Tue, Mar 5, 2013 at 7:54 AM, Ajit Kumar Shreevastava < ajit.shreevast...@hcl.com> wrote: > Hi All, > > ** ** > > I am facing following issue while export

Error while exporting table data from hive to Oracle through Sqoop

2013-03-05 Thread Ajit Kumar Shreevastava
Hi All, I am facing following issue while exporting table from hive to Oracle. Importing table from Oracle to Hive and HDFS is working fine. Please let me know where I lag. I am pasting my screen output here. [hadoop@NHCLT-PC44-2 sqoop-oper]$ sqoop export --connect jdbc:oracle:thin:@10.99.42.