Heidisql: Clickhouse support

[maruschin]

https://clickhouse.yandex/
https://github.com/yandex/clickhouse-odbc

[rentalhost]

Oh, I think that current priorities are "most common dbs" like MySQL, MariaDB, then Postgree and MSSQL, but will be great support a lot of kinds. But I still belive that it could be implemented in a long future, unfortunatelly.

[MichaelMonashev]

Currently cant connect with error:
Unknown function CONNECTION_ID: While processing CONNECTION_ID()

[ansgarbecker]

@MichaelMonashev if you say you get an SQL error, that means the connection itself was successfully, right? Further on, that means ClickHouse uses a protocol that's somehow compatible to MySQL/MariaDB, as that SELECT CONNECTION_ID() is only fired on a just started MySQL/MariaDB connection. Is that true or did that error occur in a different context?

[MichaelMonashev]

Thank you for your answer!

if you say you get an SQL error, that means the connection itself was successfully, right?

Yes.

Further on, that means ClickHouse uses a protocol that's somehow compatible to MySQL/MariaDB, as that SELECT CONNECTION_ID() is only fired on a just started MySQL/MariaDB connection. Is that true or did that error occur in a different context?

ClickHouse supports MySQL protocol: https://clickhouse.tech/docs/en/interfaces/mysql/ .
Installation instructions for ClickHouse: https://clickhouse.tech/docs/en/getting-started/install/ .

Unknown function CONNECTION_ID error occur at the connection time. So I cant connect to ClickHouse server.

[ansgarbecker]

In that case I can probably add support for Clickhouse easily. I recently added support for ProxySQLAdmin for #350 as well, which also uses the MySQL protocol, but with a similar/limited query support. You can even try to connect to Clickhouse with network type "ProxySQL Admin":

Is there some compatibility list comparing MySQL/MariaDB to Clickhouse? Or do you know of more than that incompatible CONNECTION_ID() query?

[MichaelMonashev]

I use an SSH tunnel option to connect to ClickHouse running in a private cloud.

Is there some compatibility list comparing MySQL/MariaDB to Clickhouse? Or do you know of more than that incompatible CONNECTION_ID() query?

I dont know. List of ClickHouse functions: https://clickhouse.tech/docs/en/sql-reference/functions/ .

[MichaelMonashev]

I tried to make ssh tunnel manually and after connect to ClickHouse. I got error:

Table default.stats_mysql_global doesn't exists