sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajkumar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-2892) Sqoop import --table argument fails whereas free-form-query works
Date Wed, 23 Mar 2016 04:37:25 GMT

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

Mime
View raw message