xxxid数据类型是bigintbigin
改成数据类型为string,其为主键
数据中有’,'默认是一条数据
//(抽取的数据少了好多11159->2)
sudo sqoop import
–connect “jdbc:sap://1.1.1.211:1”
–driver com.sap.db.jdbc.Driver
–username “name”
–password “password”
–query "select * from db.table where $CONDITIONS "
–hcatalog-database hivedb
–hcatalog-table hivetable
–drop-and-create-hcatalog-table
*–map-column-hive xxxid=string *
–hcatalog-storage-stanza ‘stored as orc’
–null-string ‘\N’
–null-non-string ‘\N’
–m 1