[
https://issues.apache.org/jira/browse/DRILL-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039586#comment-15039586
]
Steven Phillips commented on DRILL-4160:
----------------------------------------
This doesn't have anything to do with flatten.
You can't order by or group by a map type.
The message could be better, but it's tricky because the failure doesn't occur
in the sort operator, it happens in the exchange before the data even gets to
the sort.
> Order By on a flattened column throws SchemaChangeException - Missing
> function implementation
> ---------------------------------------------------------------------------------------------
>
> Key: DRILL-4160
> URL: https://issues.apache.org/jira/browse/DRILL-4160
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser, Storage - JSON
> Reporter: Abhishek Girish
> Attachments: drillbit.log.txt
>
>
> Query with an ORDER BY clause on a flattened column fails:
> {code}
> > select `name`, `type`, flatten(kvgen(`compliments`)) as `compliments` from
> > `user` order by `name`, `type`, `compliments` limit 2;
> Error: SYSTEM ERROR: SchemaChangeException: Failure while trying to
> materialize incoming schema. Errors:
> Error in expression at index 2. Error: Missing function implementation:
> [hash64asdouble(MAP-REQUIRED, BIGINT-REQUIRED)]. Full expression: null..
> Fragment 3:0
> [Error Id: 3b3d3224-953a-46a2-8caa-fa6949e58ffd on abhi1:31010]
> (state=,code=0)
> {code}
> Query without order by on the flatten column executes fine.
> {code}
> > select `name`, `type`, flatten(kvgen(`compliments`)) as `compliments` from
> > `user` order by `name`, `type` limit 2;
> +--------------------+-------+--------------------------------+
> | name | type | compliments |
> +--------------------+-------+--------------------------------+
> | Kurt | user | {"key":"cute","value":1.0} |
> | Kurt | user | {"key":"writer","value":1.0} |
> +--------------------+-------+--------------------------------+
> 2 rows selected (4.239 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
