I'm trying to use the --query option in sqoop to import data from MSSQL. My concern is, how can we declare which schema to use ung --query in MSSQL.   My script: sqoop \ --options-file sqoop/aw_mssql.cfg \ --query "select BusinessEntityId, LoginID, cast(OrganizationNode as string) from Employee where \$CONDITIONS" \ --hive-table employees \ --hive-database mssql \ -- --schema=HumanResources   Still produces an error "Invalid object name 'Employee'".   Also tried --connect "jdbc:sqlserver://192.168.1.17;database=AdventureWorks;schema=HumanResources" but also failed. ... View more