[
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)
