AnsweredAssumed Answered

HCatalog with Sqoop export

Question asked by rchilamkuri0410 on Dec 1, 2016
Latest reply on Dec 16, 2016 by aalvarez

Facing issues with ORC data format sqoop export  to SQL Server using HCatalog .My query includes -hcatalog-database , -hcatalog-table and -hcatalog-home parameters .

 

Query :

sqoop export  --options-file password.txt --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --table DB.DBtable --input-fields-terminated-by '\001' --lines-terminated-by '\n' -hcatalog-database hiveDB -hcatalog-table HiveORCTable_Name --num-mappers 15 --input-null-string NULL --input-null-non-string NULL

 

 

Error

 

ERROR tool.ExportTool: Encountered IOException running export job: org.apache.hive.hcatalog.common.HCatException : 2001 : Error setting output information. Cause : java.lang.NullPointerException

 

.profile file properties include

export HCAT_HOME=/opt/mapr/hive/hive-1.2/hcatalog

export HIVE_CONF_DIR=/mapr/aaaa/xxx/yy/zz_zzzzz/hive/conf

 

 

Any inputs would be greatly appreciated .

Outcomes