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)