[DRILL-7984] Support Clickhouse using JDBC Storage Plugin

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Component/s: Storage - JDBC
• Assignee: wtf
• Reporter: wtf
• Created: 08/Aug/21 07:31
• Updated: 29/May/22 07:16
• Resolved: 29/May/22 07:16

Description

Trino(Formerly PrestoSQL, branched from Presto) has already supportted [Clickhouse|https://trino.io/docs/current/connector/clickhouse.html|https://trino.io/docs/current/connector/clickhouse.html],] using [clickhouse-jdbc|https://github.com/ClickHouse/clickhouse-jdbc|https://github.com/ClickHouse/clickhouse-jdbc]

When connecting to clickhouse using drill jdbc plugin, found one uncompatible place:

clickhouse-jdbc return constant string "default" when call getCatalogs, and return all databases when call getSchemas(input catalog is not used). All schemas will be appended after the "default" catalog, which will cause the query to fail.