[teiid-issues] [JBoss JIRA] (TEIID-3854) Impala translator - ORDER BY clause using incorrect columns when not in SELECT list

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13138968#comment-13138968 ] 

Steven Hawkins commented on TEIID-3854:
---------------------------------------

The issue stems from the override in the HiveSQLConversionVisitor to strip the table from the column reference in the order by clause.  This should normally reference the view, but instead references the select clause, so this is incompatible with the alias generation logic that simply sequentially aliases select columns.

> Impala translator - ORDER BY clause using incorrect columns when not in SELECT list
> -----------------------------------------------------------------------------------
>
>                 Key: TEIID-3854
>                 URL: https://issues.jboss.org/browse/TEIID-3854
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.1, 8.12.2
>         Environment: Ubuntu Trusty on AWS
>            Reporter: Don Krapohl
>            Assignee: Steven Hawkins
>            Priority: Critical
>             Fix For: 8.13, 8.12.3
>
>
> We have a scenario in which users want to see month and day names but the data should be sorted by month and day NUMBER.  The translated query comes back sorted the wrong column.  Oddly in the ORDER clause the translator uses the month name column alias when we specify the month number, day name when we specify day number.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)