You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Prashanth Babu (JIRA)" <ji...@apache.org> on 2013/09/18 18:05:51 UTC

[jira] [Created] (SQOOP-1204) Issue with Sqoop column aliases

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