HI Team, Can we query data from particular segment? @saurabh dubey

Yes using

$segmentName

like

select count(1), $segmentName from absencesreport
where $segmentName='absencesreport__1__0__20230210T1034Z'
GROUP BY 2

Thank you so much @francoisa

Yes. We have 2 more virtual columns that can be used likewise https://docs.pinot.apache.org/basics/components/schema#built-in-virtual-columns

great, Thanks @saurabh dubey