[
https://issues.apache.org/jira/browse/HIVE-21001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16748527#comment-16748527
]
Zoltan Haindrich commented on HIVE-21001:
-----------------------------------------
by doing just the rewrite I've found something interesting:
{code}
SELECT robot, floor_hour(`__time`), max(added) as m, sum(variation)
FROM druid_table_1_n1
WHERE floor_hour(`__time`)
BETWEEN CAST('2010-01-01 00:00:00' AS TIMESTAMP WITH LOCAL TIME ZONE)
AND CAST('2014-01-01 00:00:00' AS TIMESTAMP WITH LOCAL TIME ZONE)
GROUP BY robot, floor_hour(`__time`)
ORDER BY m
LIMIT 100
{code}
in druid.query.json the following "changes" inside druid.query.json:
{code}
-"intervals":["2010-01-01T08:00:00.000Z/2014-01-01T08:00:00.001Z"]
+"intervals":["2010-01-01T08:00:00.000Z/2014-01-01T09:00:00.000Z"]
{code}
so it seems like either an issue appearing or disappearing...for the above
query I think the new one is correct.
> Upgrade to calcite-1.18
> -----------------------
>
> Key: HIVE-21001
> URL: https://issues.apache.org/jira/browse/HIVE-21001
> Project: Hive
> Issue Type: Improvement
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Major
> Attachments: HIVE-21001.01.patch, HIVE-21001.01.patch,
> HIVE-21001.02.patch, HIVE-21001.03.patch, HIVE-21001.04.patch,
> HIVE-21001.05.patch, HIVE-21001.06.patch, HIVE-21001.06.patch,
> HIVE-21001.07.patch, HIVE-21001.08.patch, HIVE-21001.08.patch,
> HIVE-21001.08.patch, HIVE-21001.09.patch, HIVE-21001.09.patch,
> HIVE-21001.09.patch, HIVE-21001.10.patch, HIVE-21001.11.patch,
> HIVE-21001.12.patch
>
>
> CLEAR LIBRARY CACHE
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
