drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4160) Order By on a flattened column throws SchemaChangeException - Missing function implementation
Date Fri, 04 Dec 2015 02:05:11 GMT

    [ 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)

Mime
View raw message