[jira] [Commented] (DRILL-1634) Drill fails when querying a nested array within a repeated map.

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

    [ 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
(v6.3.4#6332)