drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2882) Query with nested flatten function fails with SYSTEM ERROR: initialCapacity
Date Tue, 28 Apr 2015 18:36:06 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Steven Phillips updated DRILL-2882:
-----------------------------------
    Fix Version/s: 1.0.0

> 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
>             Fix For: 1.0.0
>
>         Attachments: drillbit.log
>
>
> 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)

Mime
View raw message