AnsweredAssumed Answered

Sqoop import job is skipping some columns

Question asked by zaheer.shaik on Jan 22, 2015
Latest reply on Jan 23, 2015 by uffe
I tried importing data from sql server to hbase using the following command. It turns out that 11 out of 46 not-null columns were skipped. Any ideas why this could happen?

sqoop import --hbase-create-table --hbase-table test_table --column-family data --connection-manager com.cloudera.sqoop.manager.SQLServerManager --username username --password password --connect "jdbc:jtds:sqlserver://HOST:PORT;DatabaseName=DBNAME;Instance=INSTANCE" --table "TABLE" -m 8 --verbose

Outcomes