Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4686

PrestoDB translator - ordering of joined tables fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2
    • 8.12.8.6_3
    • Misc. Connectors
    • None

    Description

      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]

      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
      

      [2] https://github.com/prestodb/presto/issues/1621
      [3] https://github.com/prestodb/presto/issues/7010

      Attachments

        Issue Links

          Activity

            People

              kylinsoong.1214@gmail.com Kylin Soong (Inactive)
              jdurani Juraj DurĂ¡ni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: