[
https://issues.apache.org/jira/browse/SQOOP-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
VISHNU S NAIR updated SQOOP-2892:
---------------------------------
Assignee: (was: VISHNU S NAIR)
> Sqoop import --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)
