Apache Druid

image.png

dataset.csv

druid native query.txt

Hi Pavithra,

I haven't taken a look at your data or native query text, but just looking at the SQL ...

... one thing odd that I noticed is that your final "where l.itemName = r.itemName" I would phrase as the second part of the join condition using an AND.    Unfortunately I don't know native query syntax well enough to know if this would make a difference.

Also, your __time value, I assume it is truncated to a high enough level that you are looking for data with the latest incomingEvenhubTimeStamp within each time "slice"?

<@U0521H53QMB> I'd suggest running `EXPLAIN PLAN FOR` on the SQL query, seeing how it got translated to native, and comparing that against your native query

maybe there is some difference that explains it

also you could try running the sub-`query` separately from your native query, and see if each one returns results that look like you expect