[SQOOP-2779] Sqoop metastore doesn't seem to recognize --schema option

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.7
• Assignee: Sowmya Ramesh
• Reporter: Sowmya Ramesh
• Created: 06/Jan/16 21:21
• Updated: 23/Apr/16 16:38
• Resolved: 01/Feb/16 04:21

Description

PROBLEM:
When running sqoop job using sqoop metastore:
sqoop job --create 'globaldata.r.emaildomain' --meta-connect 'jdbc:hsqldb:hsql://host:16000/sqoop' --import --connect 'jdbc:sqlserver://;database=DB;user=x;password=xxx' --table Tt --target-dir /hive/globaldatastaging/emaildomain --split-by 'DomainID' --num-mappers 8 --columns 'a,b,c' --hive-drop-import-delims --fields-terminated-by '\001' --lines-terminated-by '\n' --null-string '
N' --null-non-string '
N' – --schema lookup
It is throwing the error that it cannot find the table when executing the job:
15/08/24 15:21:18 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM Tt AS t WHERE 1=0
15/08/24 15:21:18 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'EmailDomain'.

Issue Links

• links to: RB link