command used: sqoop import --connect "jdbc:sqlserver://192.168.xx.x:14xx;username=xxx;password=xxx" --query "SELECT* FROM AdventureWorks2012.Production.Product WHERE $CONDITIONS" --split-by ProductID --hive-table ProductionProduct  --target-dir /usr/local/hive/AdventureWorks2012

sqoop list-databases --connect jdbc:sqlserver://192.168.xx.1:14xx --username xxx --password xxx