James Taylor created PHOENIX-951:
------------------------------------

             Summary: Don't push LIMIT as PageFilter for joins
                 Key: PHOENIX-951
                 URL: https://issues.apache.org/jira/browse/PHOENIX-951
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 3.0.0, 4.0.0
            Reporter: James Taylor
            Assignee: Maryann Xue
            Priority: Minor


When a join has a limit, you can't push the limit through a PageFilter since 
you might not get a match when you join the LHS to the RHS. I think ideally 
you'd want to push the LIMIT to the ScanRegionObserver (or 
GroupedAggregateRegionObserver) and then stop the inner scan when the limit is 
reached. There's a similar optimize for a GROUP BY that has a LIMIT with no 
ORDER BY.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to