[jira] [Commented] (SQOOP-1204) Issue with Sqoop column aliases

[Abraham Elmahrek (JIRA)]

    [ 
https://issues.apache.org/jira/browse/SQOOP-1204?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14049174#comment-14049174
 ] 

Abraham Elmahrek commented on SQOOP-1204:
-----------------------------------------

Ah that I am seeing:
{code}
private final int PROTOCOL_VERSION = 3;
  public int getClassFormatVersion() { return PROTOCOL_VERSION; }
  protected ResultSet __cur_result_set;
  private Integer id; 
  public Integer get_id() {
    return id; 
  }
  public void set_id(Integer id) {
    this.id = id; 
  }
  public QueryResult with_id(Integer id) {
    this.id = id; 
    return this;
  }
{code}

Thanks for the clarification.

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