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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Assignee: DrillCommitter
• Reporter: Jinfeng Ni
• Created: 04/Nov/14 18:47
• Updated: 09/Dec/14 17:47
• Resolved: 09/Nov/14 00:01

Description

Given the following JSON input data:

{ "a":[{"b": [["str1","str2"], ["str3", "str4"]]}] }
{ "a":[{"b": [["str10","str20"], ["str30", "str40"]]}] }

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:

select t.a[0].b[0] from dfs.`/Users/jni/work/data/json/samplejson.json` t;

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 ]