You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "wtf (Jira)" <ji...@apache.org> on 2021/08/08 07:43:00 UTC
[jira] [Updated] (DRILL-7984) Support Clickhouse using RDBMS
Storage Plugin
[ https://issues.apache.org/jira/browse/DRILL-7984?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wtf updated DRILL-7984:
-----------------------
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 map return constant string "default" when call getCatalogs, and return 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.
was:
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 map return constant string "default" when call getCatalogs, and return 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.
This Jira will try to address the uncompatibility when connecting to clickhouse using jdbc plugin.
> Support Clickhouse using RDBMS Storage Plugin
> ---------------------------------------------
>
> Key: DRILL-7984
> URL: https://issues.apache.org/jira/browse/DRILL-7984
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - JDBC
> Reporter: wtf
> Assignee: wtf
> Priority: Major
>
> 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 map return constant string "default" when call getCatalogs, and return 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)