You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/12/04 02:30:11 UTC
[jira] [Created] (DRILL-4160) Order By on a flattened column throws
SchemaChangeException - Missing function implementation
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)