[jira] [Created] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

[Philip Deegan (JIRA)]

Philip Deegan created DRILL-3562:
------------------------------------

             Summary: Query fails when using flatten on JSON data where some 
documents have an empty array
                 Key: DRILL-3562
                 URL: https://issues.apache.org/jira/browse/DRILL-3562
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
    Affects Versions: 1.1.0
            Reporter: Philip Deegan
            Assignee: Steven Phillips


Drill query fails when using flatten when some records contain an empty array 
SELECT COUNT(*) FROM (SELECT FLATTEN(t.a.b.c) AS c FROM dfs.`flat.json` t) flat 
WHERE flat.c.d.e = 'f' limit 1;

Succeeds on 
{ "a": { "b": { "c": [  { "d": {  "e": "f" } } ] } } }

Fails on
{ "a": { "b": { "c": [] } } }

Error
{noformat}
Error: SYSTEM ERROR: ClassCastException: Cannot cast 
org.apache.drill.exec.vector.NullableIntVector to 
org.apache.drill.exec.vector.complex.RepeatedValueVector
{noformat}

Is it possible to ignore the empty arrays, or do they need to be populated with 
dummy data?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)