[HIVE-17715] Exception when pushing postaggregates into Druid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Druid integration
• Target Version/s: 3.0.0
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 05/Oct/17 22:00
• Updated: 27/Feb/24 22:23
• Resolved: 15/Nov/17 21:16

Description

After Calcite is upgraded to 1.14 and the rule to push post-aggregations to Druid is enabled, the following query will fail:

EXPLAIN
SELECT language, robot, sum(added) - sum(delta) AS a
FROM druid_table_1
WHERE extract (week from `__time`) IN (10,11)
  AND robot='Bird Call'
GROUP BY language, robot;

The error we get is the following:

Cannot add expression of different type to set:
set type is RecordType(VARCHAR(2147483647) CHARACTER SET "UTF-16LE" COLLATE "ISO-8859-1$en_US$primary" language, VARCHAR(2147483647) CHARACTER SET "UTF-16LE" COLLATE "ISO-8859-1$en_US$primary" robot, DOUBLE a) NOT NULL
expression type is RecordType(VARCHAR(2147483647) CHARACTER SET "UTF-16LE" COLLATE "ISO-8859-1$en_US$primary" language, DOUBLE postagg#0) NOT NULL
set is rel#1507:HiveProject.HIVE.[](input=HepRelVertex#1514,language=$0,robot=CAST(_UTF-16LE'Bird Call'):VARCHAR(2147483647) CHARACTER SET "UTF-16LE" COLLATE "ISO-8859-1$en_US$primary",a=-($1, $2))
expression is DruidQuery#1516

Issue Links

• is broken by: HIVE-17717 Enable rule to push post-aggregations into Druid
• is cloned by: CALCITE-2050 Exception when pushing postaggregates into Druid