drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2073) Filter on a field in a nested repeated type throws an exception
Date Sat, 18 Apr 2015 21:10:58 GMT

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

Mehant Baid resolved DRILL-2073.
--------------------------------
    Resolution: Fixed

Works as expected on latest master.

> Filter on a field in a nested repeated type throws an exception
> ---------------------------------------------------------------
>
>                 Key: DRILL-2073
>                 URL: https://issues.apache.org/jira/browse/DRILL-2073
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types
>            Reporter: Rahul Challapalli
>            Assignee: Mehant Baid
>             Fix For: 1.0.0
>
>         Attachments: error.log
>
>
> git.commit.id.abbrev=3c6d0ef
> Data Set :
> {code}
> {
>   "rm": [
>     {"rptd": [{ "a": "foo"},{"b":"boo"}]}
>   ],
>   "rm1":[{"a":"foo"},{"b":"boo"}]
> }
> {code}
> The below query tries to apply a filter on field which does not exist. However the field
is still present in a different element of the same array.
> {code}
> select rm[0].rptd[0] from `temp.json` where rm[0].rptd[0].b = 'boo';
> Query failed: Query failed: Failure while running fragment., index: -4, length: 4 (expected:
range(0, 16384)) [ 01887113-c758-41bf-96d1-5eede9b1e411 on qa-node191.qa.lab:31010 ]
> [ 01887113-c758-41bf-96d1-5eede9b1e411 on qa-node191.qa.lab:31010 ]
> {code}
> The above query should result in an empty result.The above error only happens when we
apply a filter on a nested array element. The below query works fine
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDir> select rm1[0].a from `nested.json` where rm1[0].b
= 'boo';
> +------------+
> |   EXPR$0   |
> +------------+
> +------------+
> {code}
> Attached the log file.



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

Mime
View raw message