[
https://issues.apache.org/jira/browse/SQOOP-1204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14049168#comment-14049168
]
Lars Francke commented on SQOOP-1204:
-------------------------------------
The problem is that in the Class generated by Sqoop the attribute is called
"id" and not "cid" as it should be. This workaround has to be used in older
Sqoop versions where not all Java keywords are properly handled (e.g. when
there is a column with the name "default").
> 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 was sent by Atlassian JIRA
(v6.2#6252)
