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.
I am sorry if this reply reached you twice, I accidentally replied with the wrong email and I was not able to find an entry of my reply in the archives. Mark ________________________________ Van: Stamatis Zampetakis <[email protected]> Verzonden: dinsdag 9 april 2019 00:03 Aan: [email protected] Onderwerp: Re: expose existing materialized views from postgres to calcite 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 >
