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

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

Gayathri created DRILL-7161:
-------------------------------

             Summary: 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
            Reporter: Gayathri


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)