I’m not an hcatalog expert, but I would took a look into mapreduce task logs (especially into those that are failing).
Jarcec > On Dec 10, 2015, at 10:17 AM, Manish Gupta 8 <mgupt...@sapient.com> wrote: > > Can someone please provide any pointers I should look into? Basically I want > to sqoop export avro data via Hive tables. > > Thanks > > > From: Manish Gupta 8 [mailto:mgupt...@sapient.com] > Sent: Wednesday, December 09, 2015 5:32 PM > To: user@sqoop.apache.org > Subject: Error while Sqoop Export Hive (AvroSerDe) to MSSQL using Hcat > > Hi, > > I have an external table in hive created using Avro SerDe. On this, I have > created couple of normalized views. Now, when I try to export any of the > normalized views/tables from hive to sql server using sqoop, I get error: > “ERROR tool.ExportTool: Encountered IOException running export job: > java.io.IOException: java.lang.NullPointerException” > > My sqoop export looks like following: > sqoop export --connect > "jdbc:sqlserver://*****\****:1433;databaseName=****;user=*****;password=*****;" > --table tblOthrBus --hcatalog-database brokdb --hcatalog-table tblOthrBus > --verbose > > Please note: > · Table has data and I tested with hive as well as spark jdbc server. > · Database connection works fine. Tested with eval and export works > fine with export-dir option. > · Hcat details are correct. hcat.SqoopHCatUtilities is able to read > table metadata > · Hive metastore also gets connected. > > Can someone please guide me into what should I look into, any logs etc. > > Thanks > > Regards, > Manish Gupta > Specialist, Platform| Sapient Global Markets > Noida, India > > Tel: +91 (120) 479 5000 x73766 > Mobile: +91 981 059 1361 > Email: mgupt...@sapient.com > sapient.com
