drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1634) Drill fails when querying a nested array within a repeated map.
Date Wed, 05 Nov 2014 00:53:34 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14197247#comment-14197247

Jinfeng Ni commented on DRILL-1634:

Seems the cause of this query failure is that Drill did not resolve the complex type path
expression (which has two array segments) to a correct type, leading Drill to generate wrong
run-time code to evaluate such path expression. 

> Drill fails when querying a nested array within a repeated map. 
> ----------------------------------------------------------------
>                 Key: DRILL-1634
>                 URL: https://issues.apache.org/jira/browse/DRILL-1634
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Jinfeng Ni
>            Assignee: Jinfeng Ni
> Given the following JSON input data:
> {code}
> { "a":[{"b": [["str1","str2"], ["str3", "str4"]]}] }
> { "a":[{"b": [["str10","str20"], ["str30", "str40"]]}] }
> {code}
> If we want to retrieve the first element in array b, which is the first element in array
a, using the following query, Drill will fail with error:
> {code}
> select t.a[0].b[0] from dfs.`/Users/jni/work/data/json/samplejson.json` t;
> {code}
> {code}
> Query failed: Failure while running fragment., You tried to read a [CopyAsValueVarChar]
type when you are using a field reader of type [SingleLikeRepeatedMapReaderImpl]. [ d655b148-5c0e-4293-8472-8ee93d6df801
on adminisorsmbp53:31010 ]
> {code}

This message was sent by Atlassian JIRA

View raw message