ClickHouse

1–30 of 1473

0 selected

Pavan Badi, Panos Op3

Jan 13

getting Authentication Failed for Distributed table

Apparently you need to specify user and password for connecting to the other hosts https://clickhouse

unread,

getting Authentication Failed for Distributed table

Apparently you need to specify user and password for connecting to the other hosts https://clickhouse

Jan 13

Đức Giang Nguyễn2

12/22/22

How to do Flow Analysis in Clickhouse

ddit me may thang ngu :) Vào lúc 14:37:41 UTC+7 ngày Thứ Tư, 21 tháng 12, 2022, Đức Giang Nguyễn đã

unread,

How to do Flow Analysis in Clickhouse

ddit me may thang ngu :) Vào lúc 14:37:41 UTC+7 ngày Thứ Tư, 21 tháng 12, 2022, Đức Giang Nguyễn đã

12/22/22

Oleksiy Illyashov, Derek Chia3

12/12/22

Materialized view error

thanks a lot, now it works! On Sunday, December 11, 2022 at 6:41:15 PM UTC-8 derek...@clickhouse.com

unread,

Materialized view error

thanks a lot, now it works! On Sunday, December 11, 2022 at 6:41:15 PM UTC-8 derek...@clickhouse.com

12/12/22

kilic.a...@gmail.com, Alexey Milovidov6

12/8/22

Load backup to a table with a S3 storage

Added Vitaly - he can consult about the available options for cluster backups. On Tue, Dec 6, 2022 at

unread,

Load backup to a table with a S3 storage

Added Vitaly - he can consult about the available options for cluster backups. On Tue, Dec 6, 2022 at

12/8/22

kilic.a...@gmail.com, Derek Chia2

11/17/22

Resharding a CH cluster with a S3 storage

ClickHouse has a documentation page explaining that - https://clickhouse.com/docs/en/guides/sre/

unread,

Resharding a CH cluster with a S3 storage

ClickHouse has a documentation page explaining that - https://clickhouse.com/docs/en/guides/sre/

11/17/22

Csingh Singh, … Derek Chia4

11/2/22

Clickhouse tables frequently goes into read-only mode

Very likely this is due to connectivity issues with ZooKeeper. Also, 20.12.4 is long deprecated,

unread,

Clickhouse tables frequently goes into read-only mode

Very likely this is due to connectivity issues with ZooKeeper. Also, 20.12.4 is long deprecated,

11/2/22

Nathan Martinez2

10/23/22

Advice on MacOS development environment? (ld: library not found for -Lsystem)

Also, anyone have advice on configuring CLion on MacOS so code navigation works well? Thank you again

unread,

Advice on MacOS development environment? (ld: library not found for -Lsystem)

Also, anyone have advice on configuring CLion on MacOS so code navigation works well? Thank you again

10/23/22

Siddharth Jain, … Vanya Blinkov3

10/15/22

Extend single node to a cluster

Hi Siddharth, This node spec is barely on par with a modern laptop, thus by no means powerful.

unread,

Extend single node to a cluster

Hi Siddharth, This node spec is barely on par with a modern laptop, thus by no means powerful.

10/15/22

10/12/22

should we use Docker image in production?

Hello, we are using clickhouse for the first time. is there any recommendation whether to run it as a

unread,

should we use Docker image in production?

Hello, we are using clickhouse for the first time. is there any recommendation whether to run it as a

10/12/22

10/10/22

SSIS load to Clickhouse ODBC destination

An error with Nullable(String) is not an error, it's was connected with a code page. NVARCHAR not

unread,

SSIS load to Clickhouse ODBC destination

An error with Nullable(String) is not an error, it's was connected with a code page. NVARCHAR not

10/10/22

10/2/22

Run `CREATE TABLE` query with `s3Cluster` table function

Hi, I'm trying to create a table using s3Cluster function like following: CREATE TABLE my_table

unread,

Run `CREATE TABLE` query with `s3Cluster` table function

Hi, I'm trying to create a table using s3Cluster function like following: CREATE TABLE my_table

10/2/22

Eugene Gordon, Alexey Milovidov2

9/30/22

Normalized vs flat DB schema in ClickHouse world.

A flat table is preferred, even if many columns will be sparse. On Fri, Sep 30, 2022 at 8:32 PM

unread,

Normalized vs flat DB schema in ClickHouse world.

A flat table is preferred, even if many columns will be sparse. On Fri, Sep 30, 2022 at 8:32 PM

9/30/22

Karla Rehn, CatsYLing3

9/26/22

Accessing nested maps

Try this select * from table where columnname['outer_key1'] = map('inner_key1', '

unread,

Accessing nested maps

Try this select * from table where columnname['outer_key1'] = map('inner_key1', '

9/26/22

Siddharth Jain, Antonio Rodriguez3

9/13/22

Understanding performance implications of INSERT INTO

CH is built to works with good performance using 1 insert per second in a bulk operation with

unread,

Understanding performance implications of INSERT INTO

CH is built to works with good performance using 1 insert per second in a bulk operation with

9/13/22

9/8/22

ClickHouse strategy for updates

Hi all, we're going to use ClickHouse to speed up our waste management reports for large scale

unread,

ClickHouse strategy for updates

Hi all, we're going to use ClickHouse to speed up our waste management reports for large scale

9/8/22

Leonardo Palomares, Antonio Rodriguez5

8/29/22

NOT_ENOUGH_SPACE error

Antonio, it worked like a charm! Thank you so much for your help. KR, Leo El viernes, 26 de agosto de

unread,

NOT_ENOUGH_SPACE error

Antonio, it worked like a charm! Thank you so much for your help. KR, Leo El viernes, 26 de agosto de

8/29/22

Antonio Rodriguez2

8/26/22

Error when compile CH version 21.11.4.14 in Ubuntu 22.04 using clang-15

I tested with: -DCMAKE_BUILD_TYPE=Release & RelWithDebInfo Same error Also adding those packages:

unread,

Error when compile CH version 21.11.4.14 in Ubuntu 22.04 using clang-15

I tested with: -DCMAKE_BUILD_TYPE=Release & RelWithDebInfo Same error Also adding those packages:

8/26/22

Kathiresh Nadar

8/22/22

Clickhouse Error : Table is in readonly mode (version 19.14.6.12)

Recently we noticed one of our clickhouse cluster went into readonly mode and we were not able to

unread,

Clickhouse Error : Table is in readonly mode (version 19.14.6.12)

Recently we noticed one of our clickhouse cluster went into readonly mode and we were not able to

8/22/22

francesco pinta

8/5/22

Cluster Problem After node crash

Hi, I'm working with many cluster made of 2 nodes with 2 shards and 2 replicas. When, for some

unread,

Cluster Problem After node crash

Hi, I'm working with many cluster made of 2 nodes with 2 shards and 2 replicas. When, for some

8/5/22

7/26/22

Clickhouse is taking column name as Data type

Hello, I was using clickhouse v19.16.14.65, from that I updated the version to 22.3.4.20. In v22.3.4.

unread,

Clickhouse is taking column name as Data type

Hello, I was using clickhouse v19.16.14.65, from that I updated the version to 22.3.4.20. In v22.3.4.

7/26/22

7/17/22

Too many MergeTreeIndex constructed by getIndicesToRecalculate

Hello, recently I have some questions. My version is Clickhouse 21.3. Here's the github link

unread,

Too many MergeTreeIndex constructed by getIndicesToRecalculate

Hello, recently I have some questions. My version is Clickhouse 21.3. Here's the github link

7/17/22

Blessing E-Philips

7/4/22

User authentication for confluent schema registry on kafka engine

Hello, I want to consume messages with AvroConfluent format fusing the Kafka engine but the schema

unread,

User authentication for confluent schema registry on kafka engine

Hello, I want to consume messages with AvroConfluent format fusing the Kafka engine but the schema

7/4/22

7/4/22

S3 reads are getting slow when I set request_timeout field

Hi, I am exploring S3 object storage backed Merge Tree tables and storage tiering using TTL move,

unread,

S3 reads are getting slow when I set request_timeout field

Hi, I am exploring S3 object storage backed Merge Tree tables and storage tiering using TTL move,

7/4/22

Rajat Goel, Alexey Milovidov3

6/20/22

Production readiness of object storge support in Merge Tree

Thanks Alexey. On Mon, Jun 20, 2022 at 10:33 PM Alexey Milovidov <milo...@clickhouse.com>

unread,

Production readiness of object storge support in Merge Tree

Thanks Alexey. On Mon, Jun 20, 2022 at 10:33 PM Alexey Milovidov <milo...@clickhouse.com>

6/20/22

4/23/22

Decimal division issue

Hi, While processing query getting below exception <p>Message: HttpCode: 500 ; ;Code: 153. DB:

unread,

Decimal division issue

Hi, While processing query getting below exception <p>Message: HttpCode: 500 ; ;Code: 153. DB:

4/23/22

4/22/22

Decimal places fill with 0

Hi, I have a column in Decimal(10, 6) data type, when inserting 0.300000 it stores 0.3 like while

unread,

Decimal places fill with 0

Hi, I have a column in Decimal(10, 6) data type, when inserting 0.300000 it stores 0.3 like while

4/22/22

Sébastien Rebecchi

4/20/22

Select default value for missing columns

Hi everyone! I am using a table schema with a varying number of columns and where columns are created

unread,

Select default value for missing columns

Hi everyone! I am using a table schema with a varying number of columns and where columns are created

4/20/22

4/19/22

Clickhouse upgrade facing multiple issues

Hello, We are using two shard and two replica. Clickhouse docker image is yandex/clickhouse-server:

unread,

Clickhouse upgrade facing multiple issues

Hello, We are using two shard and two replica. Clickhouse docker image is yandex/clickhouse-server:

4/19/22

4/16/22

Minus function issue on Decimal numbers

Hi, Am facing below issue while while doing minus in query Code: 43. DB::Exception: Received from

unread,

Minus function issue on Decimal numbers

Hi, Am facing below issue while while doing minus in query Code: 43. DB::Exception: Received from

4/16/22

Maxim Fridental, Alexey Milovidov2

4/14/22

Maximum number of shards

600 shards configuration is proven to work. There is evidence that 1000 shards work. It starts to

unread,

Maximum number of shards

600 shards configuration is proven to work. There is evidence that 1000 shards work. It starts to

4/14/22

Search

Clear search

Close search

Google apps

Main menu