Calcite SQL Testing

[Bruce Sandell <bs...@gmail.com>]

What database most fully supports the full Calcite SQL dialect?  I am
working on a project that generates Calcite-compatible SQL, and would like
to be able to validate the generated SQL.  I'm pretty familiar with Dremio
and MapD, but was just curious which of the SQL-compatible Powered By
Calicte projects (ideally with an associated JDBC driver) supports the
broadest range of Calcite SQL, so I can use that as the basis for my
testing.

Thanks,
Bruce

Re: Calcite SQL Testing

[Julian Hyde <jh...@apache.org>]

I’d suggest hsqldb. It may not quite be the fullest SQL, but it is the most convenient because it is embedded, and therefore it can be used in non-integration tests.

IIRC, hsqldb supports LIMIT, OFFSET and VALUES but does not support windowed aggregation (OVER).

In JdbcAdapterTest you’ll notice that many tests use .enable(…) to target themselves at particular databases, and CalciteAssert.DatabaseInstance.HSQLDB appears most often.

Julian


> On Jan 18, 2018, at 3:09 PM, Bruce Sandell <bs...@gmail.com> wrote:
> 
> What database most fully supports the full Calcite SQL dialect?  I am
> working on a project that generates Calcite-compatible SQL, and would like
> to be able to validate the generated SQL.  I'm pretty familiar with Dremio
> and MapD, but was just curious which of the SQL-compatible Powered By
> Calicte projects (ideally with an associated JDBC driver) supports the
> broadest range of Calcite SQL, so I can use that as the basis for my
> testing.
> 
> Thanks,
> Bruce