drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2457) aggregation function on complex type should give appropriate error
Date Thu, 02 Apr 2015 21:38:53 GMT

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

Mime
View raw message