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

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

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)