Channels
test-channel-bot
pw-pinot
debug_upsert
feat-presto-connector
pinot-helix
troubleshooting
pinot-sketches
resources
roadmap
discuss-validation
minion-improvements
community
config-tuner
test-channel
fix-numerical-predicate
kinesis_help
pinot-perf-tuning
feat-partial-upsert
pinot_website_improvement_suggestions
segment-write-api
releases
devrel
pinot-trino
pinot-k8s-operator
release-certifier
udf-type-matching
transform-functions
release060
latency-during-segment-commit
feat-text-search
pinot-realtime-table-rebalance
inconsistent-segment
feat-rt-seg-complete
pinot-power-bi
flink-pinot-connector
pinotadls
twitter
minion-star-tree
pinot-rack-awareness
jobs
fix_llc_segment_upload
metrics-plugin-impl
linen_dev
complex-type-support
pinot-s3
feat-geo-spatial-index
feat-compound-types
v2_engine_beta_feedback
inconsistent-perf
metadata-push-api
feat-pravega-connector
enable-generic-offsets
announcements
feat-upsert
multiple_streams
feat-better-schema-evolution
fraud
onboarding
docs
aggregators
query-latency
s3-multiple-buckets
presto-pinot-connector
multi-region-setup
apa-16824
events
segment-cold-storage
odsc-europe-2022-workshop
bangalore-meetups
new-office-space
lp-pinot-poc
time-based-segment-pruner
group-by-refactor
pql-sql-regression
random
custom-aggregators
order-by
pinot-website
qps-metric
product-launch
dhill-date-seg
thirdeye-pinot
introductions
pinot-dev
getting-started
pinot-docsrus
daily-digest
general
Powered by
#troubleshooting
Title
e
Elon
05/21/2021, 3:05 AM
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.
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 AM
sure
is there a way to also get array contains?
but 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
You van do col=1 and col=2 and col =3 to ensure the row has all 1,2,3 matches
But it will also match 1,2,3,4,5
π 1
e
Elon
05/21/2021, 3:47 AM
is there a way to represent an array literal ?
in 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 AM
ok, thanks! good to know, I'll stop playing around with that then:)
π 1
Post