deepthi912 commented on PR #17047: URL: https://github.com/apache/pinot/pull/17047#issuecomment-3423806518
> Does this mean that for `NATURAL JOIN` queries, users won't be able to access (even explicitly) any columns prefixed with `$`? If yes, I think we'll need to look for an alternative solution because that's gonna be a pretty strange limitation. Note that Pinot has 4 "built-in" virtual columns (`$docId`, `$hostName`, `$segmentName`, `$partitionId`) but users can create their own as well. I think it makes sense to exclude these virtual columns from the join condition but not if it also excludes them from being usable in projections, filters, transformations etc. I just verified for a regular join we could not project the virtual columns actually : <img width="1634" height="791" alt="image" src="https://github.com/user-attachments/assets/38fb64a2-3e0e-41f7-823c-b2b04e953ab4"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
