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