Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7771

Order by and limit transactions in RDBMS cannot be pushdown

    XMLWordPrintableJSON

    Details

      Description

      hi, 

      When using ORDER BY, LIMIT and OFFSET in large tables in RDBMS, it draws the entire table on DRILL and it occurs very slow or heap memory. When we look at the query plan, instead of having ORDER BY, LIMIT and OFFSET features done by RDBMS, DRILL does it by pulling all the data on it. It is very critical to transmit these transactions to the database.

      ISSUE # 7490
      https://issues.apache.org/jira/browse/drıll-7490

      The LIMIT pushdown problem was communicated as resolved but there was a missing solution. I wrote the necessary comment in the comment section.

      Regardless of the number of columns selected, regardless of the number of joins and tables, pushdown should be done in RDBMS

        Attachments

        1. Physical Plan.PNG
          19 kB
          Yusuf
        2. query.PNG
          8 kB
          Yusuf

          Issue Links

            Activity

              People

              • Assignee:
                volodymyr Vova Vysotskyi
                Reporter:
                Dursun Yusuf
                Reviewer:
                Vitalii Diravka
              • Votes:
                3 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: