sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prashanth Babu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-1204) Issue with Sqoop column aliases
Date Wed, 18 Sep 2013 16:05:51 GMT
Prashanth Babu created SQOOP-1204:
-------------------------------------

             Summary: Issue with Sqoop column aliases
                 Key: SQOOP-1204
                 URL: https://issues.apache.org/jira/browse/SQOOP-1204
             Project: Sqoop
          Issue Type: Bug
    Affects Versions: 1.4.4
         Environment: Linux
            Reporter: Prashanth Babu


I came across an issue in Sqoop v1.4.4 import for column aliases. I remember it was present
even in earlier versions [I first saw this issue in v1.2.0 dating back to mid-2011].

Consider a Sqoop import:
{{sqoop import --connect jdbc:mysql://my_ip/my_db --username root --password **** --query
"SELECT c.id AS cid, concat(c.firstname, c.lastname) AS name FROM customer c LIMIT 10"}}

The above query gets me the data as required and but one of the column aliases is incorrect
[instead of cid, it shows the column alias as id].
id            name

I have found a workaround [though it is not elegant per-se]
{{sqoop import --connect jdbc:mysql://my_ip/my_db --username root --password **** --query
"SELECT concat(c.id, ‘’) AS cid, concat(c.firstname, c.lastname) AS name FROM customer
c LIMIT 10"}}

The above query gets me the data as required and with the exact column aliases I have mentioned.
cid          name

If I am getting just the column, Sqoop does not consider the column alias. And if I give a
function like {{concat}} as above, it considers the column alias as well.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message