[
https://issues.apache.org/jira/browse/SQOOP-1204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Prashanth Babu updated SQOOP-1204:
----------------------------------
Comment: was deleted
(was: Marking this issue as a duplicate of SQOOP-585, which was recently fixed.)
> 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
> Fix For: 1.4.5
>
>
> 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 was sent by Atlassian JIRA
(v6.2#6252)
