You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Chen Luo (JIRA)" <ji...@apache.org> on 2018/03/28 00:30:00 UTC
[jira] [Created] (ASTERIXDB-2344) Predicate/LIMIT pushdown for
primary scans
Chen Luo created ASTERIXDB-2344:
-----------------------------------
Summary: 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
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;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)