[jira] [Created] (DRILL-2882) Query with nested flatten function fails with SYSTEM ERROR: initialCapacity

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2882:
--------------------------------------

             Summary: Query with nested flatten function fails with SYSTEM ERROR: initialCapacity
                 Key: DRILL-2882
                 URL: https://issues.apache.org/jira/browse/DRILL-2882
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
    Affects Versions: 0.9.0
            Reporter: Abhishek Girish
            Assignee: Steven Phillips
            Priority: Critical


Querying the Mondrian Foodmart Queries JSON file using nested flatten function fails:

{code:sql}
> select flatten(q.`queries`[10].`rows`) from `queries.json` q;
+------------+
|   EXPR$0   |
+------------+
| ["1997","5095","59.0000"] |
| ["1997","8901","146.0000"] |
| ["1997","3801","42.0000"] |
| ["1997","3","50.0000"] |
| ["1997","3169","31.0000"] |
| ["1997","193","21.0000"] |
| ["1997","4739","110.0000"] |
| ["1997","6395","42.0000"] |
| ["1997","9129","78.0000"] |
| ["1997","7141","157.0000"] |
+------------+
10 rows selected (12.203 seconds)

> select flatten(flatten(q.`queries`[10].`rows`)) from `queries.json` q;
Query failed: SYSTEM ERROR: initialCapacity: -2147483648 (expectd: 0+)
Fragment 0:0
[d9a29de4-17a5-4dc8-8263-adc5184bccd7 on abhi8.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}

Log attached. 



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