[jira] [Updated] (SQOOP-2892) Sqoop import --table argument fails whereas free-form-query works

["Rajkumar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajkumar updated SQOOP-2892:
----------------------------
    Summary: Sqoop import --table argument fails whereas free-form-query works  (was: Sqoop import direct table argument fails whereas free-form-query works)

> 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)