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