[jira] [Comment Edited] (DRILL-7984) Support Clickhouse using JDBC Storage Plugin

["Vitalii Diravka (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-7984?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17395545#comment-17395545 ] 

Vitalii Diravka edited comment on DRILL-7984 at 8/8/21, 4:22 PM:
-----------------------------------------------------------------

Could you add query examples to the ticket description, please?
 Do you want to add test case in _org.apache.drill.exec.store.jdbc_ ?


was (Author: vitalii):
Could you add query examples, please to the description?
Do you want to add test case in _org.apache.drill.exec.store.jdbc_ ?

> Support Clickhouse using JDBC 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 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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)