You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2014/08/06 03:58:15 UTC
[jira] [Created] (DRILL-1265) Drill incorrectly return null value
when evaluates an expression of repeated list.
Jinfeng Ni created DRILL-1265:
---------------------------------
Summary: Drill incorrectly return null value when evaluates an expression of repeated list.
Key: DRILL-1265
URL: https://issues.apache.org/jira/browse/DRILL-1265
Project: Apache Drill
Issue Type: Bug
Reporter: Jinfeng Ni
Assignee: Jinfeng Ni
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)