[jira] [Updated] (DRILL-1266) Filter does not get pushed beyond sort when querying views created with order by

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

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

Jacques Nadeau updated DRILL-1266:
----------------------------------
    Priority: Minor  (was: Major)

> Filter does not get pushed beyond sort when querying views created with order by
> --------------------------------------------------------------------------------
>
>                 Key: DRILL-1266
>                 URL: https://issues.apache.org/jira/browse/DRILL-1266
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: Mehant Baid
>            Priority: Minor
>             Fix For: 0.8.0
>
>
> Can reproduce the issue using the following steps.
> create view emp as select cast(e.employee_id as int)emp_id, cast(e.full_name as varchar(100))full_name from cp.`employee.json` e order by cast(employe_id as int); 
> explain plan for select * from emp where emp_id > 100;
> Here is the plan for the query on the view with a simple filter.
> 00-00    Screen
> 00-01      Project(emp_id=[CAST($0):INTEGER NOT NULL], full_name=[CAST($1):VARCHAR(100) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL])
> 00-02        SelectionVectorRemover
> 00-03          Filter(condition=[>(CAST($0):INTEGER NOT NULL, 100)])
> 00-04            Sort(sort0=[$2], dir0=[ASC])
> 00-05              Project(emp_id=[CAST($1):INTEGER], full_name=[CAST($2):VARCHAR(100) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], EXPR$2=[CAST($3):INTEGER])
> 00-06                Scan(groupscan=[EasyGroupScan [selectionRoot=/employee.json, columns = null]])



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)