calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrei Sereda <>
Subject Elasticsearch Adapter. Removal of Mapping Types (by vendor). Index == Table
Date Thu, 28 Jun 2018 16:57:22 GMT

Elastic announced
that they will be deprecating mapping types in ES6 and indexes will be
single-typed only.

Historical analogy <> between
RDBMS and elastic was that index is equivalent to a database and type
corresponds to table in that database. In a couple of releases (ES6-8) this
shall not longer be true.

Recent SQL addition
<> to elastic confirms
this trend
Index is equivalent to a table and there are no more ES types.

I would like to propose to include this logic in Calcite ES adapter. IE,
expose each ES single-typed index as a separate table inside calcite
schema. This is in contrast to  current integration where schema can only
have a single index. Current approach forces you to create multiple schemas
to query single-typed indexes (on the same ES cluster).

Legacy compatibility can always be controlled with configuration parameters.

Do you agree with such changes ? If yes, would you consider a PR ?


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message