You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2015/04/02 23:38:53 UTC
[jira] [Commented] (DRILL-2457) aggregation function on complex
type should give appropriate error
[ https://issues.apache.org/jira/browse/DRILL-2457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393489#comment-14393489 ]
Deneche A. Hakim commented on DRILL-2457:
-----------------------------------------
I'm seeing a different output on master ({{git.commit.id.abbrev=30ad950}})
{noformat}
0: jdbc:drill:zk=local> select avg(t.soa[1]) from dfs.data.`complex.json` t;
Query failed: RemoteRpcException: Failure while running fragment., Failure while materializing expression.
Error in expression at index -1. Error: Missing function implementation: [$sum0(MAP-REQUIRED)]. Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1. Error: Missing function implementation: [count(MAP-REQUIRED)]. Full expression: --UNKNOWN EXPRESSION--.
[ f69ab14a-2627-420d-92d2-76c7ec9802f2 on 10.250.0.86:31010 ]
[ f69ab14a-2627-420d-92d2-76c7ec9802f2 on 10.250.0.86:31010 ]
{noformat}
The error message could still improved but it's already better than returning an empty result.
> aggregation function on complex type should give appropriate error
> -------------------------------------------------------------------
>
> Key: DRILL-2457
> URL: https://issues.apache.org/jira/browse/DRILL-2457
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 0.8.0
> Reporter: Chun Chang
> Assignee: Parth Chandra
> Priority: Critical
> Fix For: 0.9.0
>
>
> #Fri Mar 06 16:51:10 EST 2015
> git.commit.id.abbrev=fb293ba
> Apply aggregation function on complex data should error out with appropriate error message instead of returning null.
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select t.soa[1] from `complex.json` t limit 1;
> +------------+
> | EXPR$0 |
> +------------+
> | {"in":1,"fl":1.12345} |
> +------------+
> 1 row selected (0.169 seconds)
> 0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select avg(t.soa[1]) from `complex.json` t;
> +--+
> | |
> +--+
> +--+
> No rows selected (0.164 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)