drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1265) Drill incorrectly return null value when evaluates an expression of repeated list.
Date Wed, 06 Aug 2014 01:58:15 GMT
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)

Mime
View raw message