Hi, what data types does

Pinot

support out-of-the-box? I’m guessing

String

, numerics (integers and floating points),

date

and

boolean

- are there any others supported? For example -

ip-address

?

no ipaddress is not supported.

So if I need to keep IP Addresses and support a filter like:

IP inCidr(212.36.0.0/24)

What are my options? Do I keep the data in raw

byte[]

format and implement a

UDF

that will perform this filter? Can such a query be sub-second ?

thats right, but we just use 1 bit to represent it on disk

@Kishore G, 🙂 Sure - though I haven’t decided yet if we can invest time in checking

Pinot

at this time.

@Ron Kitay I haven’t worked with IP addresses in SQL, but worst case I assume you could store as 32 bit int and do range queries?

@Ron Kitay thats totally fine. someone else might ask for it later or a contributor might want to pick it up.

@Ken Krugler, for IPv4 - yes. But for IPv6 I need 16 bytes. So either I use a composite field with two `long`s or a

byte []