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:[email protected]] Sent: Wednesday, December 09, 2015 5:32 PM To: [email protected] 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: [email protected]<mailto:[email protected]> sapient.com
