[HOP-3966] JDBC Clickhouse Retrieving Database Metadata goes wrong

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: Database
• Labels: pull-request-available
• Assignee: Sergio Ramazzina
• Reporter: Marco Blum
• Created: 31/May/22 08:27
• Updated: 22/Jun/22 07:15
• Resolved: 22/Jun/22 07:15

Description

The handling of the db metadata within "Explore" is buggy.

With the "native" clickhouse connection every preview stucks because the database/schema have are not been retrieved and every table name is prefixed with "default" (no database name set)
With my generic jdbc connection the database meta is better retrieved

but when it comes to preview every query stucks because of the schema-names are again prefixed with "default" in the form of  default.<database[schema]name>.<tablename>

 

Maybe it has something to do with this. The retrieval of table-metadata inside hop components is sometimes incredible slow in the designer

Issue Links

• is related to: HOP-3250 Schema name incorrectly set from Database Explorer
• links to: GitHub Pull Request #1541