You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2018/06/08 17:49:00 UTC
[jira] [Work started] (HIVE-19796) Push Down TRUNC Fn to Druid
Storage Handler
[ https://issues.apache.org/jira/browse/HIVE-19796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-19796 started by slim bouguerra.
---------------------------------------------
> Push Down TRUNC Fn to Druid Storage Handler
> -------------------------------------------
>
> Key: HIVE-19796
> URL: https://issues.apache.org/jira/browse/HIVE-19796
> Project: Hive
> Issue Type: Bug
> Components: Druid integration
> Reporter: slim bouguerra
> Assignee: slim bouguerra
> Priority: Major
> Attachments: HIVE-19796.patch
>
>
> Push down Queries with TRUNC date function such as
> {code}
> SELECT SUM((`ssb_druid_100`.`discounted_price` * `ssb_druid_100`.`net_revenue`)) AS `sum_calculation_4998925219892510720_ok`,
> CAST(TRUNC(CAST(`ssb_druid_100`.`__time` AS TIMESTAMP),'MM') AS DATE) AS `tmn___time_ok`
> FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100`
> GROUP BY CAST(TRUNC(CAST(`ssb_druid_100`.`__time` AS TIMESTAMP),'MM') AS DATE)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)