[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=13348727#comment-13348727 ] 

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

[~jdurani] I do not think there is a way to disable ORDER BY only in JOIN situations through capabilities. Also there is seems to be specific when there are multiple columns in the ORDER BY. I would suggest making this as translator override and adding a note in the document about it, that way we can leave it for the user configuration.

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