slim bouguerra created HIVE-19796:
-------------------------------------
Summary: 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
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)
