[jira] [Closed] (DRILL-4545) Incorrect query plan for LIMIT 0 query

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

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

Khurram Faraaz closed DRILL-4545.
---------------------------------

> Incorrect query plan for LIMIT 0 query
> --------------------------------------
>
>                 Key: DRILL-4545
>                 URL: https://issues.apache.org/jira/browse/DRILL-4545
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.6.0
>         Environment: 4 node cluster CentOS
>            Reporter: Khurram Faraaz
>              Labels: limit0
>
> Inner query has a LIMIT 1 and outer query has LIMIT 0. Looking at the query plan it looks like the outer LIMIT 0 is applied before the LIMIT 1 is applied to inner query. This does not seem right.
> Drill 1.6.0 commit ID : fb09973e
> {noformat}
> 0: jdbc:drill:schema=dfs.tmp> explain plan for select * from (select * from `employee.json` limit 1) limit 0;
> +------+------+
> | text | json |
> +------+------+
> | 00-00    Screen
> 00-01      Project(*=[$0])
> 00-02        SelectionVectorRemover
> 00-03          Limit(fetch=[0])
> 00-04            Limit(fetch=[1])
> 00-05              Limit(offset=[0], fetch=[0])
> 00-06                Scan(groupscan=[EasyGroupScan [selectionRoot=maprfs:/tmp/employee.json, numFiles=1, columns=[`*`], files=[maprfs:///tmp/employee.json]]])
> {noformat}
> Here is the data from JSON file
> {noformat}
> [root@centos-01 ~]# cat employee.json
> {
>   "firstName": "John",
>   "lastName": "Smith",
>   "isAlive": true,
>   "age": 45,
>   "height_cm": 177.6,
>   "address": {
>     "streetAddress": "29 4th Street",
>     "city": "New York",
>     "state": "NY",
>     "postalCode": "10021-3100"
>   },
>   "phoneNumbers": [
>     {
>       "type": "home",
>       "number": "212 555-1234"
>     },
>     {
>       "type": "office",
>       "number": "646 555-4567"
>     }
>   ],
>   "children": [],
>   "hobbies": ["scuba diving","hiking","biking","rock climbing","surfing"]
> }
> {noformat}



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