Is Pinot supports `with` clause in query?
# generalp
parthiv shah
10/12/2022, 4:03 PMIs Pinot supports
withs
Sidd
10/12/2022, 4:04 PMNot yet.
p
parthiv shah
10/12/2022, 4:06 PMThanks @Sidd, for the quick reply, do we have any roadmap to support it?
s
Sidd
10/12/2022, 4:06 PMI think either @Rong R or I had created an issue sometime back.
Sidd
10/12/2022, 4:06 PMLet me find one
r
Rong R
10/12/2022, 4:08 PMwell. i just tried in multi-stage engine and it looks like it can run 😛
🙌 2
Rong R
10/12/2022, 4:08 PM Copy code
WITH tbl AS (select * from baseballStats limit 10)
select * from tbl limit 5p
parthiv shah
10/12/2022, 4:26 PMOhh great! according to https://docs.pinot.apache.org/developers/advanced/v2-multi-stage-query-engine it seems it is in beta phase.
r
Rong R
10/12/2022, 4:27 PMyeah it is still in beta phase. please share your thoughts in the #C03Q4A11GC9 channel