is there a way to represent an array literal in pinot sql I

Question

is there a way to represent an array literal in pinot sql I tried `ARRAY 1 2 3 ` in a filter and a select and it didn t work

Xiang Fu · Answer

Hmm do you want exact match of 1 2 3

Elon · Answer

sure

Elon · Answer

is there a way to also get array contains

Elon · Answer

but exact match also

Xiang Fu · Answer

for array contains you can do col IN 1 2 3 This will match the row contains either 1 or 2 or 3

Xiang Fu · Answer

You van do col=1 and col=2 and col =3 to ensure the row has all 1 2 3 matches

Xiang Fu · Answer

But it will also match 1 2 3 4 5

Elon · Answer

is there a way to represent an array literal

Elon · Answer

in filter or select

Xiang Fu · Answer

I don t think we have that right now

Elon · Answer

ok thanks good to know I ll stop playing around with that then