ClickHouse

1–30 of 1384

0 selected

Apr 10

Schema for user metrics

Hello, I have the following tables in PostgreSQL and I wonder what is the best schema in ClickHouse.

unread,

Schema for user metrics

Hello, I have the following tables in PostgreSQL and I wonder what is the best schema in ClickHouse.

Apr 10

Kedar Shah, … Dmitriy Pavlov3

Apr 9

Consulting Services for ClickHouse: Urgent Project

Hi Kedar, Yandex (ClickHouse vendor) is also providing support & consulting services for

unread,

Consulting Services for ClickHouse: Urgent Project

Hi Kedar, Yandex (ClickHouse vendor) is also providing support & consulting services for

Apr 9

Apr 7

kafka_commit_every_batch

Hi, I would like to ask for help with understanding what effect can have the setting of

unread,

kafka_commit_every_batch

Hi, I would like to ask for help with understanding what effect can have the setting of

Apr 7

Sateesh Kommineni, Amit Sharma3

Mar 31

Creating MView on Kafka Topic

Hi Amit, Thanks for your response. That resolved the issue. Thanks Sateesh On Tuesday, March 30, 2021

unread,

Creating MView on Kafka Topic

Hi Amit, Thanks for your response. That resolved the issue. Thanks Sateesh On Tuesday, March 30, 2021

Mar 31

Dmitrij Kultasev, Denis Zhuravlev2

Mar 30

Dealing with time type data in Clickhouse

You can store number of seconds - Int32. Or as a number 093201, 235959 On Tuesday, March 30, 2021 at

unread,

Dealing with time type data in Clickhouse

You can store number of seconds - Int32. Or as a number 093201, 235959 On Tuesday, March 30, 2021 at

Mar 30

ervin...@gmail.com, … Gene Zhang3

Mar 30

Clickhouse Copier error: table xxxxxxx_piece_0 doesn't exist

Some error messages are misleading and copying may be successful anyways. Check the result to see.

unread,

Clickhouse Copier error: table xxxxxxx_piece_0 doesn't exist

Some error messages are misleading and copying may be successful anyways. Check the result to see.

Mar 30

Sateesh Kommineni, Denis Zhuravlev2

Mar 29

Kafka Engine vs JDBC Driver

The biggest problem that Kafka Engine does not provide logs and does not have tools to debug to

unread,

Kafka Engine vs JDBC Driver

The biggest problem that Kafka Engine does not provide logs and does not have tools to debug to

Mar 29

Sateesh Kommineni, Kenji2

Mar 25

Using Kafka Headers as Columns in ClickHouse Table Engine

Kafka headers should be accessible as virtual columns along with other virtual columns. SELECT _topic

unread,

Using Kafka Headers as Columns in ClickHouse Table Engine

Kafka headers should be accessible as virtual columns along with other virtual columns. SELECT _topic

Mar 25

Amarjeet Yelwande

Mar 21

Compare two clickhouse databases and generate upgrade script

Is there any tool which I can use to compare two Clickhouse databases and generate an upgrade script.

unread,

Compare two clickhouse databases and generate upgrade script

Is there any tool which I can use to compare two Clickhouse databases and generate an upgrade script.

Mar 21

Mar 16

ngrambf_v1 and Low-cardinality strings

Hey all, I am trying to use ngrambf_v1 on LowCardinality(String) columns, and it seems that this is

unread,

ngrambf_v1 and Low-cardinality strings

Hey all, I am trying to use ngrambf_v1 on LowCardinality(String) columns, and it seems that this is

Mar 16

Mar 15

SAMPLE N, statistical "uniform" sampling, later non-PK components

Hey everybody, I have multiple questions about the effective use of SAMPLE N. Background: We collect

unread,

SAMPLE N, statistical "uniform" sampling, later non-PK components

Hey everybody, I have multiple questions about the effective use of SAMPLE N. Background: We collect

Mar 15

Baurzhan Tokhtarov, … Denis Zhuravlev4

Mar 12

Clickhouse and INTERSECT

>is INTERSECT expected to appear in clickhouse? No. On Friday, March 12, 2021 at 1:04:04 am UTC-4

unread,

Clickhouse and INTERSECT

>is INTERSECT expected to appear in clickhouse? No. On Friday, March 12, 2021 at 1:04:04 am UTC-4

Mar 12

Kenji, Denis Zhuravlev3

Mar 11

Flushing buffer tables before restarting clickhouse

Great! I should've read the doc more carefully. Thanks! On Thu, Mar 11, 2021 at 3:07 PM Denis

unread,

Flushing buffer tables before restarting clickhouse

Great! I should've read the doc more carefully. Thanks! On Thu, Mar 11, 2021 at 3:07 PM Denis

Mar 11

Amit Sharma, Denis Zhuravlev5

Mar 11

Exception before query start

No these are not nullable. Here is the table definition CREATE TABLE lmd.local_otd_sdr_deviation_new

unread,

Exception before query start

No these are not nullable. Here is the table definition CREATE TABLE lmd.local_otd_sdr_deviation_new

Mar 11

Baurzhan Tokhtarov, Denis Zhuravlev2

Mar 2

Clickhouse and full text search

>We are considering switching from sphinx to clickhouse for full text search >Does this make

unread,

Clickhouse and full text search

>We are considering switching from sphinx to clickhouse for full text search >Does this make

Mar 2

Feb 18

ClickHouse- Merges

one more thing is even after stopping the merges when I started loading the data with 12 parallel

unread,

ClickHouse- Merges

one more thing is even after stopping the merges when I started loading the data with 12 parallel

Feb 18

Feb 17

Batch inserts: resume on failure?

Hi all, Is there a way to insert a batch of records and get a report on which records resulted in an

unread,

Batch inserts: resume on failure?

Hi all, Is there a way to insert a batch of records and get a report on which records resulted in an

Feb 17

crazylearner, Denis Zhuravlev3

Feb 11

ClickHouse server congfiguration suggession required

disk performance and data size have a direct correlation? On Tuesday, February 9, 2021 at 10:23:53 PM

unread,

ClickHouse server congfiguration suggession required

disk performance and data size have a direct correlation? On Tuesday, February 9, 2021 at 10:23:53 PM

Feb 11

crazylearner, Denis Zhuravlev3

Feb 11

How to speed up the data laoding process

Yes with 7parallel inserts I often get merge error (inserts are faster than merges) On Thu, 11 Feb,

unread,

How to speed up the data laoding process

Yes with 7parallel inserts I often get merge error (inserts are faster than merges) On Thu, 11 Feb,

Feb 11

Diz, Denis Zhuravlev2

Feb 9

How to do self-join funnel

https://youtu.be/YpurT78U2qA You can do it using groupArrays and high-order functions Also check

unread,

How to do self-join funnel

https://youtu.be/YpurT78U2qA You can do it using groupArrays and high-order functions Also check

Feb 9

crazylearner, Denis Zhuravlev2

Feb 9

Load the data directly from s3 to ClickHouse

select * from s3('http://s3.amazonaws.com/bucketname/test/file.csv', 'accesskey',

unread,

Load the data directly from s3 to ClickHouse

select * from s3('http://s3.amazonaws.com/bucketname/test/file.csv', 'accesskey',

Feb 9

Semyon Galichenko

Feb 5

Replication with sharding.CH keeps movind data from one shard to another

Hi everyone, I've got 2 shards with 2 replicas each and I'm following this article (https://

unread,

Replication with sharding.CH keeps movind data from one shard to another

Hi everyone, I've got 2 shards with 2 replicas each and I'm following this article (https://

Feb 5

mai.abd...@gmail.com, Denis Zhuravlev4

Feb 4

How to have IPv4 and IPv6 in The Same Column?

>Can you please explain me why the IP is stored at my table in a different value? Because you

unread,

How to have IPv4 and IPv6 in The Same Column?

>Can you please explain me why the IP is stored at my table in a different value? Because you

Feb 4

Feb 1

Data loading into clickhouse from MariaDB is very slow

Hello Team, We are trying to load the data from MariaDB to clickhouse using below query which is

unread,

Data loading into clickhouse from MariaDB is very slow

Hello Team, We are trying to load the data from MariaDB to clickhouse using below query which is

Feb 1

this.wi...@gmail.com

Jan 26

How to debug memory issue?

Im seeing issues that clickhouse suddenly consumes all my memory. 8GB where usually it is around 1GB

unread,

How to debug memory issue?

Im seeing issues that clickhouse suddenly consumes all my memory. 8GB where usually it is around 1GB

Jan 26

Maxim Fridental

Jan 26

How would you calculate percentage in this case?

Hi there. I have a heavy subquery that runs hours and delivers results in the form of Field1, Field2,

unread,

How would you calculate percentage in this case?

Hi there. I have a heavy subquery that runs hours and delivers results in the form of Field1, Field2,

Jan 26

Sireesha, … Denis Zhuravlev7

Jan 25

Best driver to ingest huge data

Thank you Denis for the info. I will explore this options . Regards, Sireesha On Sunday, January 24,

unread,

Best driver to ingest huge data

Thank you Denis for the info. I will explore this options . Regards, Sireesha On Sunday, January 24,

Jan 25

this.wi...@gmail.com, Amit Sharma2

Jan 15

First and last row of consecutive rows

When you say first and last row where device and key are same, I am assuming you are looking for

unread,

First and last row of consecutive rows

When you say first and last row where device and key are same, I am assuming you are looking for

Jan 15

Jan 14

Replication not working

Hello, Clickhouse version: 20.5.3 We've replicated tables created in Clickhouse using the

unread,

Replication not working

Hello, Clickhouse version: 20.5.3 We've replicated tables created in Clickhouse using the

Jan 14

Jan 14

[CH v 19.9.5.36] Is there any way to free up RAM for the clickhouse?

Please ? On Friday, December 4, 2020 at 11:39:40 AM UTC+7 Quy Nguyen wrote: Dear clickhouse, I have

unread,

[CH v 19.9.5.36] Is there any way to free up RAM for the clickhouse?

Please ? On Friday, December 4, 2020 at 11:39:40 AM UTC+7 Quy Nguyen wrote: Dear clickhouse, I have

Jan 14

Search

Clear search

Close search

Google apps

Main menu