Sqoop export will transfer data to Database using Insert statement as soon the user fires the export command ,Sqoop will connect to database to fetch the metada about the table. The only prequist that pertains to sqoop export command is that (--table parameter) table  must exist prior to runining sqoop. You can have the table with primary key or not is up to your design . The user have to make sure that there not be any constraint violations while performing the Sqoop export(i,e INSERT)     ... View more

1 . Type show tables in Hive and note down the tables .   2 . check under user/hive/warehuse/ using Hue -> File Browser or command line that Customer folder or categories folders are already being populated . if so  Remove it using HUE->File browser-Delete or    Drop table command from Hive.   Then re run the script and please let me know  .    Or    Simply change the last line of the script    sqoop import-all-tables \ -m 1 \ --connect jdbc:mysql://quickstart:3306/retail_db \ --username=retail_dba \ --password=cloudera \ --compression-codec=snappy \ --as-sequencefile \ --warehouse-dir=/user/hive/warehouse \ --hive-overwrite ... View more

You have to bucket the hive table but not sorted . Streaming to a unpartionated  table is currently not supported. In your case please check your table schema  table - m_tel_record       ... View more