[
https://issues.apache.org/jira/browse/DRILL-1265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1265:
----------------------------------
Assignee: Jason Altekruse (was: Jinfeng Ni)
> 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: Jason Altekruse
> Fix For: 0.5.0
>
>
> 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)
