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
01/26/2021, 2:36 AM
I can't seem to select a virtual column from the pinot query console, is it supported? i.e.
Copy code
select $segmentName from <table> limit 10
k
Kishore G
01/26/2021, 2:41 AM
@Jackie
^^
👍 1
j
Jackie
01/26/2021, 2:42 AM
Are you running the latest version? What is the query response?
e
Elon
01/26/2021, 2:42 AM
It's just no rows, I'm running 0.5.0. iirc I remember doing this and it worked.
empty response
same for
$docId
but I'm using query console
tried both pql and sql
j
Jackie
01/26/2021, 2:43 AM
There was a fix for the virtual column, let me check
https://github.com/apache/incubator-pinot/pull/6042
Available in 0.6.0😂
e
Elon
01/26/2021, 2:45 AM
Ok, upgrading 🤣 thanks:)
Post