[DRILL-1265] Drill incorrectly return null value when evaluates an expression of repeated list.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Assignee: DrillCommitter
• Reporter: Jinfeng Ni
• Due: 22/Aug/14
• Created: 06/Aug/14 01:56
• Updated: 30/Sep/14 00:55
• Resolved: 30/Sep/14 00:55

Description

This is a follow-up issue after DRILL-1258. After the compiler error is fixed, the query completes with null value in the repeated list.

JSON data:

{ "a" : [

{ "x": [[1], [2, 20], [3, 30, 300]], "y": "abc"}

] }
{ "a" : [

{ "x": [[1000]], "y": "abc2"}

] }

Q1:
select t.a[0].x from dfs.`/Users/jni/work/data/json/input.json` t;

EXPR$0
[]
[]
Total rows returned : 2

However, if we put the expression into a convert_to function, the query will return correct result:

Q2 :
select convert_to(t.a[0].x,'JSON') from dfs.`/Users/jni/work/data/json/input.json` t;

EXPR$0
[ [ 1 ], [ 2, 20 ], [ 3, 30, 300 ] ]
[ [ 1000 ] ]
Total rows returned : 2

Seems there might be some bug in copy operation in repeated list vector.