SQL filtering with "__Time =" does not work in Pivot

[TwojaWina]

SQL filtering with "__Time =" returns error, while "__Time <" or "__Time >" work correctly. Please find attached screen shots.

Case where __Time filter works :

Case where __Time filter does not work

[jihoonson]

@millbraeming thank you for reporting, but it looks not a bug to me. The reason that the last query returns an empty result is that there is no row having 2016-06-27T00:00:36.000Z value for __time column. I guess it should be 2016-06-27T00:00:36.027Z if you want to get the second row. Would you try again?

[jihoonson]

Ok. This is a feature request rather than a bug. It looks good to me to support it.

[gianm]

Check this out:

__time = TIMESTAMP '2017-11-20 19:07:26.561' plans to intervals "2017-11-20T19:07:26.000Z/2017-11-20T19:07:26.001Z"

but __time >= TIMESTAMP '2017-11-20 19:07:26.561' plans to "2017-11-20T19:07:26.561Z/146140482-04-24T15:36:27.903Z"

So, there is at least a bug here somewhere -- milliseconds are respected in one but not the other.

The exception applying DruidQueryRule:WHERE_FILTER also is a bug, rules shouldn't fail outright like that.

[jihoonson]

@gianm thanks for clarifying this issue. I didn't know that the Calcite timestamp type supports millisecond fraction. Good to know.