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

[Kylin Soong (JIRA)]

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

Kylin Soong commented on TEIID-4686:
------------------------------------

I agree that we don't do any change, it seems already be fix and included in 0.163, probably QE can test against the 0.163 driver, if the issue still exist, we can leave a notes in document like: the source not support ORDER BY with JOIN well, you can use translator properties to disable Order by.

[1] https://github.com/prestodb/presto/issues/1621

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