[jira] [Updated] (HIVE-19796) Push Down TRUNC Fn to Druid Storage Handler

2018-06-09 Thread Ashutosh Chauhan (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-19796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ashutosh Chauhan updated HIVE-19796:

   Resolution: Fixed
Fix Version/s: 3.1.0
   Status: Resolved  (was: Patch Available)

Pushed to master and branch-3. Thanks, Slim!

> 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
> Fix For: 3.1.0
>
> 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)

[jira] [Updated] (HIVE-19796) Push Down TRUNC Fn to Druid Storage Handler

2018-06-08 Thread slim bouguerra (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-19796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

slim bouguerra updated HIVE-19796:
--
Status: Patch Available  (was: In Progress)

> 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)

[jira] [Updated] (HIVE-19796) Push Down TRUNC Fn to Druid Storage Handler

2018-06-08 Thread slim bouguerra (JIRA) 


 [ 
https://issues.apache.org/jira/browse/HIVE-19796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

slim bouguerra updated HIVE-19796:
--
Attachment: HIVE-19796.patch

> 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)