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)
