ClickHouse

ClickHouse official JDBC driver is built-into Querona and is ready to use.

Note

ClickHouse is an open-source column-oriented database management system capable of real-time generation of analytical data reports using SQL queries.

For more information about ClickHouse please visit https://clickhouse.yandex/.

Connection settings

The available and recommeded JDBC connection settings are:

Setting name

Default value

Description

apache_buffer_size

65536

buffer_size

65536

The number of bytes in the result to buffer in the server memory.

compress

0

connection_timeout

10000

Connection timeout in milliseconds.

enable_http_compression

socket_timeout

30000

Enables or disables data compression in the response to an HTTP request. Possible values: 0 — Disabled, 1 — Enabled, default 0.

ssl

false

Enable SSL/TLS for the connection.

sslrootcert

SSL/TLS root certificate.

sslmode

strict

Verify or not certificate: none (don’t verify), strict (verify).

use_server_time_zone

true

Whether to use timezone from server.

use_time_zone

Which time zone to use.

use_server_time_zone_for_dates

false

Whether to use timezone from server on Date parsing in getDate(). If false, Date returned is a wrapper of a timestamp at start of the day in client timezone. If true - at start of the day in server or use_timezone timezone.

Unsupported data types

  • Array(T)

  • Enum

  • Tuple(T1, T2, …)

  • AggregateFunction(name, types_of_arguments…)

  • Nested(Name1 Type1, Name2 Type2, …)

  • Expression

  • Set