You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Gunnar Morling (Jira)" <ji...@apache.org> on 2021/12/29 09:20:00 UTC
[jira] [Updated] (CALCITE-4969) Can't retrieve metadata for tables in sub-schemas
[ https://issues.apache.org/jira/browse/CALCITE-4969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gunnar Morling updated CALCITE-4969:
------------------------------------
Description:
I have created a custom Calcite schema factory which produces a parent schema, which in turn contains multiple sub-schemas. I can query those tables as intended, e.g. SELECT * FROM schemaname.tablename.
Metadata retrieval for these tables via JDBC fails though; the following doesn't return any subschema tables (note how the schema filter is null):
{code}
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables(null, null, "%", null));
{code}
[Reported|https://mail-archives.apache.org/mod_mbox/calcite-dev/202112.mbox/%3CCADGJaX9jN8BN_C%2BZswcDspfFYdWZ5p%3DxNey4ho1QZwpjFtAehw%40mail.gmail.com%3E] on the mailing list initially.
was:
I have created a custom Calcite schema factory which produces a parent schema, which in turn contains multiple sub-schemas. I can query those tables as intended, e.g. SELECT * FROM schemaname.tablename.
Metadata retrieval for these tables via JDBC fails though; the following doesn't return any subschema tables (note how the schema filter is null):
{code}
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables(null, null, "%", null));
{code}
> Can't retrieve metadata for tables in sub-schemas
> -------------------------------------------------
>
> Key: CALCITE-4969
> URL: https://issues.apache.org/jira/browse/CALCITE-4969
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.28.0
> Reporter: Gunnar Morling
> Priority: Major
>
> I have created a custom Calcite schema factory which produces a parent schema, which in turn contains multiple sub-schemas. I can query those tables as intended, e.g. SELECT * FROM schemaname.tablename.
> Metadata retrieval for these tables via JDBC fails though; the following doesn't return any subschema tables (note how the schema filter is null):
> {code}
> DatabaseMetaData md = connection.getMetaData();
> ResultSet rs = md.getTables(null, null, "%", null));
> {code}
> [Reported|https://mail-archives.apache.org/mod_mbox/calcite-dev/202112.mbox/%3CCADGJaX9jN8BN_C%2BZswcDspfFYdWZ5p%3DxNey4ho1QZwpjFtAehw%40mail.gmail.com%3E] on the mailing list initially.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)