calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1617) Druid adapter: Send timestamp literals to Druid as local time, not UTC
Date Thu, 02 Feb 2017 23:01:52 GMT
Julian Hyde created CALCITE-1617:
------------------------------------

             Summary: Druid adapter: Send timestamp literals to Druid as local time, not UTC
                 Key: CALCITE-1617
                 URL: https://issues.apache.org/jira/browse/CALCITE-1617
             Project: Calcite
          Issue Type: Bug
          Components: druid
            Reporter: Julian Hyde
            Assignee: Julian Hyde


In the Druid adapter, send timestamp literals to Druid as local time, not UTC.

In the following, "1999-11-10T00:00:00.000Z" should be "1999-11-10T00:00:00.000".

{noformat}
hive> explain SELECT DISTINCT `__time`
    > FROM store_sales_sold_time_subset
    > WHERE `__time` < '1999-11-10 00:00:00';
OK
Plan optimized by CBO.

Stage-0
  Fetch Operator
    limit:-1
    Select Operator [SEL_1]
      Output:["_col0"]
      TableScan [TS_0]
        Output:["__time"],properties:{"druid.query.json":"{\"queryType\":\"timeseries\",\"dataSource\":\"druid_tpcds_ss_sold_time_subset\",\"descending\":false,\"granularity\":\"NONE\",\"aggregations\":[],\"intervals\":[\"1900-01-01T00:00:00.000Z/1999-11-10T00:00:00.000Z\"]}","druid.query.type":"timeseries"}
{noformat}



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

Mime
View raw message