I am trying to export data from mssql server to hive.I am using following command to export data from Users table to hive.

sqoop import --connect "jdbc:sqlserver://{ip}\LOCAL_INSTANCE;database=TEST_DB;user=sa;passw ord=****" --table "Users_Table" --create-hive-table --hive-table users_export --target-dir /cdc/export/users --append --query "select * from Users_Table"I am getting following error message.
At minimum, you must specify --connect and --tableArguments to mysqldump and other subprograms may be suppliedafter a '--' on the command line.
If I remove --query param it uses default query to export data and it works fine.
I have also tried out -e parameter still getting the same error.
What could be the problem here?


Check Solution