You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (JIRA)" <ji...@apache.org> on 2018/08/08 17:02:00 UTC
[jira] [Resolved] (ASTERIXDB-2438) Consider assigns when pushing
limit with condition into data scan
[ https://issues.apache.org/jira/browse/ASTERIXDB-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lychagin resolved ASTERIXDB-2438.
----------------------------------------
Resolution: Fixed
> Consider assigns when pushing limit with condition into data scan
> -----------------------------------------------------------------
>
> Key: ASTERIXDB-2438
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2438
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: COMP - Compiler
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Minor
>
> Currently PushLimitIntoPrimarySearchRule stops at assign operators and therefore doesn't not push select condition into data-scan if there's an assign in between. We should fix this to allow such conditions be pushed into data scan.
> Here are example queries:
> Q1:
> select substring(dblpid, 0, 21)
> from DBLP1
> where dblpid > "series"
> limit 1;
> Q2:
> select value t.user.lang
> from TweetMessages t
> where t.user.friends_count between 0 and 150
> limit 2
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)