This message was deleted.
# generals
Slackbot
04/19/2023, 12:58 PMThis message was deleted.
j
John Kowtko
04/19/2023, 1:52 PMImply Druid has the View Manager extension: https://docs.imply.io/latest/druid/operations/views/view-manager/
OSS Druid has a form of Materialized Views: https://druid.apache.org/docs/latest/development/extensions-contrib/materialized-view.html#materialized-view-maintenance
p
Prakhar Pande
04/20/2023, 5:22 AMthanks @John Kowtko. I checked this, but my use case requires the view on union of two tables. is there any workaround for that?
g
Gian Merlino
04/20/2023, 6:13 AMNot that I know of, although you would be able to do it with an extension that adds a new
NamedDruidSchemaGian Merlino
04/20/2023, 6:14 AMAt some point we'll introduce ability to define SQL views, then you'd be able to use those without writing an extension
p
Prakhar Pande
04/20/2023, 6:22 AMThanks @Gian Merlino, I will check this. My actual use case is to overcome some of the limitations in druid sql when using 'union all'. By creating a view on native query and providing the view as datasource to users would solve that.
3 Views