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