[
https://issues.apache.org/jira/browse/DRILL-2182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317100#comment-14317100
]
Rahul Challapalli commented on DRILL-2182:
------------------------------------------
Another use case which should also be handled by the fix. Even here the input
to flatten is a scalar
{code}
select flatten(MAX(lst_lst[0][0])) from `data1.json` group by uid;
{code}
> Error message not clear when we try to apply flatten on a non-repeated column
> -----------------------------------------------------------------------------
>
> Key: DRILL-2182
> URL: https://issues.apache.org/jira/browse/DRILL-2182
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Rahul Challapalli
> Assignee: Daniel Barclay (Drill/MapR)
>
> git.commit.id.abbrev=c54bd6a
> When we apply flatten on an integer column, the error message is obscure
> {code}
> 0: jdbc:drill:schema=dfs_eea> select flatten(uid) from `data1.json`;
> Query failed: RemoteRpcException: Failure while running fragment.,
> org.apache.drill.exec.vector.NullableBigIntVector cannot be cast to
> org.apache.drill.exec.vector.RepeatedVector [
> 1a8a5802-d67b-4a86-82ff-098d997f696a on qa-node191.qa.lab:31010 ]
> [ 1a8a5802-d67b-4a86-82ff-098d997f696a on qa-node191.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
> Below is the case for a map. This is an improvement from the above case.
> However I am not sure whether user's understand what a repeated type is
> {code}
> 0: jdbc:drill:schema=dfs_eea> select flatten(map) from `data1.json`;
> Query failed: RemoteRpcException: Failure while running fragment., Trying to
> flatten a non-repeated filed. [ 9c80ff81-59eb-4a14-9359-a639f03763ed on
> qa-node191.qa.lab:31010 ]
> [ 9c80ff81-59eb-4a14-9359-a639f03763ed on qa-node191.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
