https://community.cloudera.com/t5/Support-Questions/sqoop-import-fails-and-shows/m-p/282601#M210084 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/70322">@Rak</a>&nbsp;</P><P>Looks like there no Space just before "--target-dir"&nbsp; in your command<STRONG> "--split-by `date`--target-dir"</STRONG></P><P>&nbsp;</P><P><SPAN>Can you give a single space before the target-dir as following and then try again. Also please check the target-dir PATH is valid. Means in your case looks like it has a missing forward slash like "user/hive" should be "/user/hive" ...etc</SPAN></P><P>&nbsp;</P><LI-CODE lang="markup"># 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</LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Mon, 11 Nov 2019 05:56:29 GMT jsensharma 2019-11-11T05:56:29Z