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
