[SQOOP-2892] Sqoop import --table argument fails whereas free-form-query works

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: connectors/sqlserver

Environment

Hadoop 2.6.0, CDH5.5.2

• Assignee: Unassigned
• Reporter: Rajkumar
• Created: 23/Mar/16 04:35
• Updated: 27/Jan/17 08:39

Description

When importing using free-form-query --query argument, all the columns in the specified table is fetched and written to a target directory successfully.

sqoop import \
--connect "jdbc:sqlserver://x.x.x.x;database=yyyyy" \
--username xxxxxx --password yyyyyy \
--query 'SELECT * FROM tbltest WHERE $CONDITIONS' \
--target-dir /user/hue/tbltest1 \
--fields-terminated-by '|'
--m 10

However, when I specify --table argument instead of free-form-query, the mapreduce job just hangs. I do not any exceptions or errors in map task logs either.

sqoop import \
--connect "jdbc:sqlserver://x.x.x.x;database=yyyyy" \
--username xxxxxx --password yyyyyy \
--table tbltest \
--target-dir /user/hue/tbltest2 \
--fields-terminated-by '|'
--m 10

16/03/22 21:21:13 INFO mapreduce.Job: Running job: job_1458667709298_0030
16/03/22 21:21:18 INFO mapreduce.Job: Job job_1458667709298_0030 running in uber mode : false
16/03/22 21:21:18 INFO mapreduce.Job: map 0% reduce 0%