You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/04/27 18:46:38 UTC
[jira] [Commented] (DRILL-2882) Query with nested flatten function
fails with SYSTEM ERROR: initialCapacity
[ https://issues.apache.org/jira/browse/DRILL-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14514420#comment-14514420 ]
Abhishek Girish commented on DRILL-2882:
----------------------------------------
Git.Commit.ID: a0a1930 (Apr 21)
> 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
> 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)