sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1204) Issue with Sqoop column aliases
Date Tue, 01 Jul 2014 18:38:24 GMT

    [ 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)

Mime
View raw message