[teiid-issues] [JBoss JIRA] (TEIID-4686) PrestoDB translator - ordering of joined tables fails

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-4686:
-------------------------------------

I do not think it worth the effort right now given PrestoDB needs to fix the support order by multiple order by. My comment is leave disable configuration to the user directly as it is fine in single order by case.

> PrestoDB translator - ordering of joined tables fails
> -----------------------------------------------------
>
>                 Key: TEIID-4686
>                 URL: https://issues.jboss.org/browse/TEIID-4686
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.8.6_3
>            Reporter: Juraj Duráni
>            Assignee: Kylin Soong
>             Fix For: 9.2.1
>
>
> Issuing query like \[1\] causes an exception in PrestoDB. This seems to be PrestoDB issue. I found similar issue \[2\], but that one should be fixed. I have created a new issue \[3\]. Removing one column from ORDER BY, query returns correct result.
> Not sure if we can do something about it without avoiding pushing JOIN.
> I suggest either to fix this (if simple enough) or add a note to the documentation.
> \[1\]
> {code:sql}
> SELECT a.intkey, b.intkey FROM BQT1.SmallA AS a INNER JOIN BQT1.SmallB AS b on a.intkey = b.intkey ORDER BY 1, 2
> {code}
> \[2\] https://github.com/prestodb/presto/issues/1621
> \[3\] https://github.com/prestodb/presto/issues/7010



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)