question Re: sqoop import fails and shows in Support Questions

question Re: sqoop import fails and shows in Support Questions https://community.cloudera.com/t5/Support-Questions/sqoop-import-fails-and-shows/m-p/282670#M210119 <a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/70322">@Rak</a> You have a couple of errors in your sqoop syntax but you are almost there, please have a look at the below hints and retry after understanding and correcting them.1. Sqoop import--connect This is wrong you need a space between the import and -- ie sqoop import --connect 2. 'jdbc:sqlserver'--username is also not correct you need a port number and databases name ie "jdbc:sqlserver://<Server_Host>:<Server_Port>;databaseName"3. The quotes around the '2019-11-08'" is wrong too 3. All you -- should have a space before sqoop import--connect 'jdbc:sqlserver'--username 'sa' -P--query "select * from dlyprice where $CONDITIONS AND `date`= '2019-11-08'"--split-by `date--target-dir /home/hduser2 -m 2 Try something like this !sqoop import --connect --connect "jdbc:sqlserver://<Server_Host>:<Server_Port>;DB_Name>" \ --driver com.microsoft.sqlserver.jdbc.SQLServerDriver \ --username XXXX -P --query "select * from dlyprice  where $CONDITIONS AND `date`= '2019-11-08' \ --split-by `date`  --target-dir /home/hduser2 -m 2 The above isn't tested by I wanted to highlight some of your mistakes by making it work makes you a better hadooper !  Here is a link to <A href="https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html#_connecting_to_a_database_server" target="_blank" rel="noopener">Sqoop User Guide</A> Can you try out this syntax remember to replace the values with that  of your environment sqoop import --connect "jdbc:sqlserver://hostname;username='sa';password='sa_password';database=yourDB" --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query "select * from dlyprice where \$CONDITIONS" --split-by date -m 2 --target-dir /home/hduser2  Please revert    Mon, 11 Nov 2019 20:22:00 GMT Shelton 2019-11-11T20:22:00Z