[HIVE-19796] Push Down TRUNC Fn to Druid Storage Handler

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.1.0
• Component/s: Druid integration
• Assignee: Slim Bouguerra
• Reporter: Slim Bouguerra
• Created: 05/Jun/18 13:04
• Updated: 31/Jul/18 01:32
• Resolved: 09/Jun/18 19:58

Description

Push down Queries with TRUNC date function such as

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)