Abhishek Girish created DRILL-4160: -------------------------------------- Summary: 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
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)