is there a way to represent an array literal in pi...
# troubleshootinge
Elon
05/21/2021, 3:05 AMis there a way to represent an array literal in pinot sql? I tried
ARRAY[1,2,3]x
Xiang Fu
05/21/2021, 3:40 AM
Hmm, do you want exact match of 1,2,3?
e
Elon
05/21/2021, 3:41 AMsure
Elon
05/21/2021, 3:41 AMis there a way to also get array contains?
Elon
05/21/2021, 3:41 AMbut exact match also
x
Xiang Fu
05/21/2021, 3:45 AM
for array contains, you can do col IN (1,2,3). This will match the row contains either 1 or 2 or 3.
💡 1
Xiang Fu
05/21/2021, 3:45 AM
You van do col=1 and col=2 and col =3 to ensure the row has all 1,2,3 matches
Xiang Fu
05/21/2021, 3:45 AM
But it will also match 1,2,3,4,5
👍 1
e
Elon
05/21/2021, 3:47 AMis there a way to represent an array literal ?
Elon
05/21/2021, 3:47 AMin filter or select?
x
Xiang Fu
05/21/2021, 3:48 AM
I don’t think we have that right now
👍 1
e
Elon
05/21/2021, 3:48 AMok, thanks! good to know, I'll stop playing around with that then:)
👍 1