https://community.cloudera.com/t5/Support-Questions/sqoop-import-fails-and-shows/m-p/282600#M210083 <P>sqoop import --connect 'database' --username 'sa' -P --query 'select * from database.table where $CONDITIONS AND `date`= '11-11-2019' --split-by `date`--target-dir=user/hive/warehouse/stagging_tables/tablenew -m 1</P> <P>&nbsp;</P> <P>Must specify destination with --target-dir.<BR />Try --help for usage instructions.</P> Mon, 11 Nov 2019 13:41:04 GMT Rak 2019-11-11T13:41:04Z