[DRILL-1223] Querying a field in a repeated map should return an array

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: Future
• Assignee: Unassigned
• Reporter: Mehant Baid
• Created: 29/Jul/14 22:51
• Updated: 17/Nov/14 01:34

Description

Consider the following json file:

{"rownum":1, "arrayval": [

{"val1":"a1"}

,

{"val1":"a2"}

]}
{"rownum":2, "arrayval": [

{"val1":"b1"}

,

{"val1": "b2"}

]}

If we have the following query, we will fail with a class cast exception.
select rownum, table.arrayval.val1 from dfs.`input.json` as table;

We should return an array of type 'val1' like the following

[a1, a2]
[b1, b2]