Rajkumar created SQOOP-2892:
-------------------------------
Summary: Sqoop import direct table argument fails whereas
free-form-query works
Key: SQOOP-2892
URL: https://issues.apache.org/jira/browse/SQOOP-2892
Project: Sqoop
Issue Type: Bug
Components: connectors/sqlserver
Affects Versions: 1.4.6
Environment: Hadoop 2.6.0, CDH5.5.2
Reporter: Rajkumar
When importing using free-form-query --query argument, all the columns in the
specified table is fetched and written to a target directory successfully.
{quote}
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
{quote}
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.
{quote}
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%
{quote}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
