[
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)
