Zoltan Haindrich created HIVE-21142:
---------------------------------------
Summary: Druidhandler may miss results when time constrainted by
and/ors
Key: HIVE-21142
URL: https://issues.apache.org/jira/browse/HIVE-21142
Project: Hive
Issue Type: Bug
Reporter: Zoltan Haindrich
For the following query:
{code}
FROM druid_table_alltypesorc
WHERE ('1968-01-01 00:00:00' <= `__time` AND `__time` <= '1970-01-01 00:00:00')
OR ('1968-02-01 00:00:00' <= `__time` AND `__time` <= '1970-04-01
00:00:00') ORDER BY `__time` ASC LIMIT 10;
{code}
the druid query is:
{code}
druid.query.json
{"queryType":"scan","dataSource":"default.druid_table_alltypesorc","intervals":["1900-01-01T00:00:00.000Z/1968-02-01T08:00:00.001Z"],"virtualColumns":[{"type":"expression","name":"vc","expression":"\"__time\"","outputType":"LONG"}],"columns":["vc"],"resultFormat":"compactedList"}
{code}
which has an invalid interval:
{{"intervals":["1900-01-01T00:00:00.000Z/1968-02-01T08:00:00.001Z"}} which
prevents valid results from 1969 to appear.
note: using between the interval is handled correctly
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
