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

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

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

Prashanth Babu reassigned SQOOP-1204:
-------------------------------------

    Assignee: Prashanth Babu
    
> 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
>            Assignee: 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