Jesus Camacho Rodriguez created HIVE-17715:
----------------------------------------------
Summary: 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)
