[ https://issues.apache.org/jira/browse/DRILL-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039588#comment-15039588 ]
Steven Phillips commented on DRILL-4160: ---------------------------------------- never mind, i misread the query, you are not ordering by compliments. > 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)