drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Westin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5462) Drill needs a per-query option to force a sort for non-covering indexed queries
Date Tue, 02 May 2017 21:56:04 GMT
Chris Westin created DRILL-5462:
-----------------------------------

             Summary: Drill needs a per-query option to force a sort for non-covering indexed
queries
                 Key: DRILL-5462
                 URL: https://issues.apache.org/jira/browse/DRILL-5462
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators
    Affects Versions: 1.10.0
            Reporter: Chris Westin


For storage systems like MapR-DB, which don't have a consistent read/snapshot model, it's
possible for records to change between the time they are found in an index, and the time they
are looked up in a primary table. If the index is being relied upon to satisfy a sort, then
it's possible that by the time the rows are fetched from the primary table that they are no
longer in sorted order.

Sometimes developers depend on an "order by" returning rows in the correct order. In order
to make sure that happens, there needs to be a per-query option to force a sort on the result
set in this case.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message