I can t seem to select a virtual column from the pinot query Apache Pinot #troubleshooting

I can't seem to select a virtual column from the p...

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

Kishore G

01/26/2021, 2:41 AM

@Jackie ^^

👍 1

Jackie

01/26/2021, 2:42 AM

Are you running the latest version? What is the query response?

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.

Elon

01/26/2021, 2:42 AM

empty response

Elon

01/26/2021, 2:42 AM

same for

$docId

Elon

01/26/2021, 2:42 AM

but I'm using query console

Elon

01/26/2021, 2:43 AM

tried both pql and sql

Jackie

01/26/2021, 2:43 AM

There was a fix for the virtual column, let me check

Jackie

01/26/2021, 2:44 AM

Jackie

01/26/2021, 2:44 AM

Available in 0.6.0😂

Elon

01/26/2021, 2:45 AM

Ok, upgrading 🤣 thanks:)