[jira] [Updated] (ASTERIXDB-2344) Predicate/LIMIT pushdown for primary scans

["Chen Luo (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chen Luo updated ASTERIXDB-2344:
--------------------------------
    Description: 
Currently we don't have limit/predicate pushdown for simple select queries, e.g.,
{code}
select *
from ds_tweet
where friends_count < 10
limit 5;
{code}

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;


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

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;



> Predicate/LIMIT pushdown for primary scans
> ------------------------------------------
>
>                 Key: ASTERIXDB-2344
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2344
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>          Components: COMP - Compiler, STO - Storage
>            Reporter: Chen Luo
>            Assignee: Chen Luo
>            Priority: Major
>
> Currently we don't have limit/predicate pushdown for simple select queries, e.g.,
> {code}
> select *
> from ds_tweet
> where friends_count < 10
> limit 5;
> {code}
> 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
(v7.6.3#76005)