[DRILL-7161] Aggregation with group by clause

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Not A Bug
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.0
• Component/s: Functions - Drill
• Labels: Drill issue
• Assignee: Hefei Li
• Reporter: Gayathri
• Created: 09/Apr/19 09:53
• Updated: 10/Apr/19 12:28
• Resolved: 10/Apr/19 09:14

Description

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.