hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "slim bouguerra (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15850) Proper handling of timezone in Druid storage handler
Date Thu, 09 Feb 2017 17:08:42 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15859821#comment-15859821
] 

slim bouguerra commented on HIVE-15850:
---------------------------------------

[~jcamachorodriguez] thanks LGTM.
More questions, can you ensure that if the user uses UDFs like to_utc_timestamp(timestamp,
string timezone) this still work ?  

> Proper handling of timezone in Druid storage handler
> ----------------------------------------------------
>
>                 Key: HIVE-15850
>                 URL: https://issues.apache.org/jira/browse/HIVE-15850
>             Project: Hive
>          Issue Type: Bug
>          Components: Druid integration
>    Affects Versions: 2.2.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Critical
>         Attachments: HIVE-15850.patch
>
>
> We need to make sure that filters on timestamp are passed to Druid with correct timezone.
> After CALCITE-1617, Calcite will generate a Druid query with intervals without timezone
specification. In Druid, these intervals will be assumed to be in UTC (if Druid is running
in UTC, which is currently the recommendation). However, in Hive, those intervals should be
assumed to be in the user timezone. Thus, we should respect Hive semantics and include the
user timezone in the intervals passed to Druid.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message