Re: Sequence support

2017-09-11 Thread Chris Baynes
We had a problem with LogicalProject not being converted to its more efficient version when using the RelBuilder. Perhaps something similar is happening to you because of the way the sequence tables are defined. Our fix was to override the createScan method on the TableScanFactory: https://issues.a

Sequence support

2017-09-07 Thread Christian Beikov
Hey, I'm having some problems implementing CALCITE-1940 and wanted to ask you for advice about how to tackle it. A query like "select next value for seq1" where "seq1" is a sequence in e.g. PostgreSQL is will generate a query plan like "LogicalProject(NEXT VALUE FOR seq1) -> LogicalValues( (

Re: Sequence support

2017-08-10 Thread Julian Hyde
I don’t know what you mean by “operations”. Most relational operators can be pushed down. And a few contributors are improving the JDBC adapter all the time. Sequences are only partially done. Most of the work has been done by and for the Phoenix project, which implements sequences as tables. Th

Sequence support

2017-08-10 Thread Christian Beikov
Hello, I am new to Calcite but I already got quite far with integrating it into a test project. Now I am a bit stuck and I am not sure what is happening. I would like to use Calcite for data federation, but first I am trying to simply put it between the application and the actual JDBC connect