[
https://issues.apache.org/jira/browse/CALCITE-5071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17516195#comment-17516195
]
itxiangkui commented on CALCITE-5071:
-------------------------------------
It's really not a good behavior to show all the tables under the root path in
sqlline.
Extending the use catalog/database and show catalogs/databases/tables semantics
should be a best practice.
I have turned off this feature.
> Schema.getTableMap cannot handle tables with the same name in
> "Schema->SubSchema->Table" mode
> ---------------------------------------------------------------------------------------------
>
> Key: CALCITE-5071
> URL: https://issues.apache.org/jira/browse/CALCITE-5071
> Project: Calcite
> Issue Type: Improvement
> Reporter: itxiangkui
> Priority: Major
>
> When I define catalog(schema) -> database(subschema) -> table three-level
> warehouse management mode, RootSchema is defined as Catalog, the example is
> as follows:
> - es
> -- db1
> --- table1
> - mysql
> -- db2
> --- table1
> When I use the !tables command under Sqlline, that will trigger the call
> getTableMap()
> RootSchema.getTableNames()
> RootSchema.getTable(String name)
> three methods,
> I extended RootSchema.getTableMap() and found that table1 with the same name
> will appear, then the !tables result set can only display one of the table
> items
> Can we consider getTableMap() to return Guava Multimap and similar data
> structures....
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
