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] sapient.com
