Hey Team, can we create "view" or "temporary table...
# generalj
Jun
06/14/2024, 6:54 PMHey Team, can we create "view" or "temporary table" in Pinot?
m
Mayank
06/15/2024, 3:40 PM
You can create StarTree index that is like a materialized view
r
robert zych
06/15/2024, 11:52 PMNeither views nor temp tables are supported yet. However you may now use CTEs in your queries.
robert zych
06/15/2024, 11:53 PMCan you share your use case or the problem you're having?
s
Shubham
06/17/2024, 11:49 AM@robert zych from what version pinot support CTEs?
r
robert zych
06/17/2024, 4:53 PMCTEs are only supported by the multi-stage query engine which was released in version 1.0.
2 Views