Hi , Can we query a specific committed segment in pinot REALTIME table ? More precisely I want to look into all the data present inside a particular segment . I am aware of filtering by timestamp , just want to know is there any other way of doing this .

there is a concept of virtual column which you may leverage

using the $segmentName variable https://docs.pinot.apache.org/basics/components/schema#built-in-virtual-columns

correct, use this in your predicate

Thanks !

You aren’t the first one to ask this, so here’s a little guide showing how to do it: https://dev.startree.ai/docs/pinot/recipes/query-by-segment