sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manish Gupta 8 <mgupt...@sapient.com>
Subject RE: Error while Sqoop Export Hive (AvroSerDe) to MSSQL using Hcat
Date Thu, 10 Dec 2015 09:17:58 GMT
Can someone please provide any pointers I should look into? Basically I want to sqoop export
avro data via Hive tables.


From: Manish Gupta 8 [mailto:mgupta50@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


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

*         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.


Manish Gupta
Specialist, Platform| Sapient Global Markets
Noida, India

Tel: +91 (120) 479 5000 x73766
Mobile: +91 981 059 1361
Email: mgupta50@sapient.com<mailto:mgupta50@sapient.com>

View raw message