[ https://issues.apache.org/jira/browse/HIVE-17715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez reassigned HIVE-17715: ---------------------------------------------- > Exception when pushing postaggregates into Druid > ------------------------------------------------ > > Key: HIVE-17715 > URL: https://issues.apache.org/jira/browse/HIVE-17715 > Project: Hive > Issue Type: Bug > Components: Druid integration > Affects Versions: 3.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > > After Calcite is upgraded to 1.14 and the rule to push post-aggregations to > Druid is enabled, the following query will fail: > {code} > 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; > {code} > The error we get is the following: > {code} > 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 > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)