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)
