[
https://issues.apache.org/jira/browse/DRILL-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14741790#comment-14741790
]
Sudheesh Katkam commented on DRILL-2882:
----------------------------------------
Error message (as of
[b525692|https://github.com/apache/drill/tree/b525692e05c2a562a664093abd46bf68137b4a3b])
shows:
{code}
Error: UNSUPPORTED_OPERATION ERROR: In a list of type BIGINT, encountered a
value of type VARCHAR. Drill does not support lists of different types.
{code}
> 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: Jason Altekruse
> Fix For: 1.2.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)
