[ https://issues.apache.org/jira/browse/CALCITE-2050?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez moved HIVE-18065 to CALCITE-2050: --------------------------------------------------------- Affects Version/s: (was: 3.0.0) Target Version/s: (was: 3.0.0) Component/s: (was: Druid integration) druid Workflow: jira (was: no-reopen-closed, patch-avail) Key: CALCITE-2050 (was: HIVE-18065) Project: Calcite (was: Hive) > Exception when pushing postaggregates into Druid > ------------------------------------------------ > > Key: CALCITE-2050 > URL: https://issues.apache.org/jira/browse/CALCITE-2050 > Project: Calcite > Issue Type: Bug > Components: druid > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Fix For: 1.15.0 > > > 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)