[jira] [Assigned] (DRILL-7161) Aggregation with group by clause

["Hefei Li (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-7161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hefei Li reassigned DRILL-7161:
-------------------------------

    Assignee: Hefei Li

> Aggregation with group by clause
> --------------------------------
>
>                 Key: DRILL-7161
>                 URL: https://issues.apache.org/jira/browse/DRILL-7161
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>    Affects Versions: 1.14.0
>            Reporter: Gayathri
>            Assignee: Hefei Li
>            Priority: Blocker
>              Labels: Drill, issue
>
> Facing some issues with the following case:
> Json file (*sample.json*) is having the following content:
> {"a":2,"b":null}
> {"a":2,"b":null}
> {"a":3,"b":null}
> {"a":4,"b":null}
> *Query:*
> SELECT a, sum(b) FROM dfs.`C:\\Users\\user\\Desktop\\sample.json` group by a;
> *Error:*
> UNSUPPORTED_OPERATION ERROR: Only COUNT, MIN and MAX aggregate functions supported for VarChar type
> *Observation:*
> If we query without using group by, then it is working fine without any error. If group by is used, then sum of null values is throwing the above error.
>  
> Can anyone please let us know the solution for this or if there are any alternative.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)