This message was deleted.

Window functions aren't currently supported in Druid SQL, so that's why you're seeing an error

yep that's why. the error message is misleading however. ideally, it should say something like "window functions are not supported". i wonder why it mentions MIN instead?

because

MIN

as a scalar operator indeed isn't supported. in this particular query, that's how MIN is getting read as.

Many tks all. I solve this problem by creating temp table and using join 😆