Sqoop import import failed error

Question

When I run this command:

sqoop import --connect jdbc:mysql://mysqldb.edu.cloudlab.com/retail_db --username labuser --password edureka --table customers --hbase-table hbaseimpo
rt111 --hbase-row-key customer_id --columns "customer_fname,customer_lname" --column-family cf1 --hbase-create-table -m 1;

I am getting import failed error.

Answer 1

The problem which you are facing is because of the schema of your MySql table. In your import command, you can select a subset of columns and control their ordering by using the --columns argument. This should include a comma-delimited list of columns to export. For example: --columns "col1,col2,col3". 

Note that columns that are not included in the --columns parameter need to have either defined default value or allow NULL values. Otherwise, your database will reject the imported data which in turn will make Sqoop job fail.

Please either use all the column names in the --columns tab of your Sqoop command as given in the below image or In MySql create a table with the proper schema where columns of your MySql table should allow null values.