SQLTables: "TABLE" vs "BASE TABLE"

elastic / elasticsearch-sql-odbc

ODBC driver for Elasticsearch SQL

Other

0 stars 30 forks source link

SQLTables: "TABLE" vs "BASE TABLE" #235

Closed bpintea closed 4 years ago

bpintea commented 4 years ago

Some applications expect the non-alias & co tables to be of type TABLE, while others BASE TABLE and ignore the present entires if they don't conform to the expectation. This doesn't seem to be related to the release of the ODBC API the application is conforming to. We need a way to enable both types of applications to work.

Note that this concerns most often the listing of available tables and does't impede the execution of queries against those "missing" tables.

bpintea commented 4 years ago

The issue tracks the problem, the fix might be more suitable on the server.

bpintea commented 4 years ago

This issue needs to be solved in ES: https://github.com/elastic/elasticsearch/issues/54671.