Hi Stamatis, I have looked at the example but I am still a bit confused what I need to do when I want to create a new materialized view. Am I then supposed to create a jdbc connection to postgres, create a materialized view and then change the model again for calcite? Because I am unable to create a materialized view directly via calcite.
Mark On Tue, 9 Apr 2019 at 00:05, Stamatis Zampetakis <[email protected]> wrote: > Hi Mark, > > It is not easy to understand what is missing from the pieces of code you > shared. > > In the example that I've shared with you, I don't remember seeing anywhere > CREATE VIEW statements. I suppose you are trying to execute a > java.sql.Statement but I am afraid this will not work. You don't need to > create the view in Postgres (assuming that is already there) but you just > need to make Calcite aware of it. This will not be done by executing a > Statement but by using various APIs like the one in the test case mentioned > earlier. > > I think the easiest way to go would be to modify the test case itself and > see if how it can be adapted based on your schema. > > Best, > Stamatis > > > > On Mon, Apr 8, 2019 at 3:29 PM Yuzhao Chen <[email protected]> wrote: > > > Or you can config your framework config with a schema implemented by your > > self [1], the getTable should be implemented correctly [2]. Then config > the > > CalciteCatalogReader with the schema and schemaPath [3]. > > The validator used your CalciteCatalogReader will recognize your tables > in > > Postgres. > > > > [1] > > > https://github.com/apache/calcite/blob/a8e71f9f295e36e472d9f650d1c76d2501e1fdbf/core/src/main/java/org/apache/calcite/tools/FrameworkConfig.java#L55 > > [2] > > > https://github.com/apache/calcite/blob/a8e71f9f295e36e472d9f650d1c76d2501e1fdbf/core/src/main/java/org/apache/calcite/schema/Schema.java#L63 > > [3] > > > https://github.com/apache/calcite/blob/a8e71f9f295e36e472d9f650d1c76d2501e1fdbf/core/src/main/java/org/apache/calcite/prepare/CalciteCatalogReader.java#L100 > > > > Best, > > Danny Chan > > 在 2019年4月5日 +0800 PM10:00，Mark Pasterkamp <[email protected] > > >，写道： > > > Dear all, > > > > > > I have connected my postgresql database as a datasource to calcite. I > am > > > however not able to find out how I can expose the existing materialized > > > views in postgres to calcite. I am unable to find much help on the > > internet > > > so if anyone is knowledgeable about this I would really appreciate a > > small > > > code example as to how this is supposed to work in Java. > > > > > > > > > Mark > > >
