Hi everyone ! I’m wondering if there are any plans to support native UUID types in Druid. Currently, we have to store UUIDs as strings, which makes querying them inefficient, and we have to rely on workarounds like lookups or mapping them to Long values. I couldn’t find any existing feature request about this on GitHub. Am I the only one encountering this issue, or is this a common limitation?

No plans as far as I know. But I agree, it will be cool to have a native uuid type. > Currently, we have to store UUIDs as strings, which makes querying them inefficient, and we have to rely on workarounds like lookups or mapping them to Long values. Curious, what query inefficiencies did you notice with uuid values stored as strings?

Sorry for the delay to response.

Curious, what query inefficiencies did you notice with uuid values stored as strings?

Well, just a where condition on a column with UUIDs as strings with thousands of UUIDs.

Where columnAsUUID in (...thousands-of-uuids...)

I have twice the query time compared to integers

Where columnAsInt in (...thousands-of-ints...)

Similar thing on order by.