[jira] [Commented] (HIVE-21142) Druidhandler may miss results when time constrainted by and/ors

2019-01-28 Thread Zoltan Haindrich (JIRA) 


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

Zoltan Haindrich commented on HIVE-21142:
-

tested with a local calcite snapshot that the issue is fixed by CALCITE-2802

> 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
>  Components: Druid integration
>Reporter: Zoltan Haindrich
>Assignee: Zoltan Haindrich
>Priority: Major
> Attachments: add_test.patch
>
>
> 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)

[jira] [Commented] (HIVE-21142) Druidhandler may miss results when time constrainted by and/ors

2019-01-22 Thread Zoltan Haindrich (JIRA) 


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

Zoltan Haindrich commented on HIVE-21142:
-

cc: [~bslim]

> 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
>Priority: Major
> Attachments: add_test.patch
>
>
> 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)