calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <>
Subject Re: Calcite SQL Testing
Date Fri, 19 Jan 2018 00:03:12 GMT
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.


> On Jan 18, 2018, at 3:09 PM, Bruce Sandell <> 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

View raw message