asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chen Luo (JIRA)" <>
Subject [jira] [Created] (ASTERIXDB-2344) Predicate/LIMIT pushdown for primary scans
Date Wed, 28 Mar 2018 00:30:00 GMT
Chen Luo created ASTERIXDB-2344:

             Summary: Predicate/LIMIT pushdown for primary scans
                 Key: ASTERIXDB-2344
             Project: Apache AsterixDB
          Issue Type: Improvement
          Components: COMP - Compiler, STO - Storage
            Reporter: Chen Luo
            Assignee: Chen Luo

Currently we don't have limit/predicate pushdown for simple SPJ queries, e.g.,
select *
from ds_tweet
where friends_count < 10
limit 5;

It'll be nice to have:
1. pushdown predicates to dataset scan operator (IndexSearchOperatorNodePushable) such that
only quantified records are returned to the outside;
2. pushdown LIMIT to dataset scan operator when possible so that the query can be terminated
once enough records are fetched;

This message was sent by Atlassian JIRA

View raw message