ClickHouse

1–30 of 1405

0 selected

Jul 12

Paid ClickHouse users interview

Hi everybody! We at Yandex are searching for ClickHouse users, who are ready to share their

unread,

Paid ClickHouse users interview

Hi everybody! We at Yandex are searching for ClickHouse users, who are ready to share their

Jul 12

Filip Podstavec, … Denis Zhuravlev7

Jun 24

Does Clickhouse support something like fulltext index?

Denis: I have a table filled with 100 mil. random strings from 2 to 10 characters. Christopher were

unread,

Does Clickhouse support something like fulltext index?

Denis: I have a table filled with 100 mil. random strings from 2 to 10 characters. Christopher were

Jun 24

Jun 21

merge data with the same primary key

In the case of a large amount of data, about tens of thousands of qps, how to efficiently and quickly

unread,

merge data with the same primary key

In the case of a large amount of data, about tens of thousands of qps, how to efficiently and quickly

Jun 21

Jun 16

MS Access access problem :-D

Hi, We're using official ODBC driver (tried ANSI and Unicode with same results). Database is

unread,

MS Access access problem :-D

Hi, We're using official ODBC driver (tried ANSI and Unicode with same results). Database is

Jun 16

kriticar, … Denis Zhuravlev9

May 31

What is performance impact of the Nullable columns?

it's up to you. There are pros and cons for both solutions. I started to use Clickhouse when

unread,

What is performance impact of the Nullable columns?

it's up to you. There are pros and cons for both solutions. I started to use Clickhouse when

May 31

May 27

compute using previous rows

I would like to compute weighted sum between 1 previous row and current row. value = "value from

unread,

compute using previous rows

I would like to compute weighted sum between 1 previous row and current row. value = "value from

May 27

Amit Sharma, Denis Zhuravlev2

May 20

timeSlots function starting time slot before start date.

https://github.com/ClickHouse/ClickHouse/issues/13271#issuecomment-668150887 SELECT arrayMap(i ->

unread,

timeSlots function starting time slot before start date.

https://github.com/ClickHouse/ClickHouse/issues/13271#issuecomment-668150887 SELECT arrayMap(i ->

May 20

Daniel Trembath

May 19

How to structure a top N freq materalized view or similar

Forgive me if this is the wrong place to ask database design questions. I have a Clickhouse database

unread,

How to structure a top N freq materalized view or similar

Forgive me if this is the wrong place to ask database design questions. I have a Clickhouse database

May 19

Евгений Билык

May 18

Clickhouse return not all rows in result

Hi everyone! I have 2 tables: create table db.buffer_statistics_table ( productId Int32, created

unread,

Clickhouse return not all rows in result

Hi everyone! I have 2 tables: create table db.buffer_statistics_table ( productId Int32, created

May 18

divyan...@gmail.com, Denis Zhuravlev2

May 11

Same column names gives incorrect results

I think it's a webui bug. On Tuesday, May 11, 2021 at 11:51:00 pm UTC-3 divyan...@gmail.com wrote

unread,

Same column names gives incorrect results

I think it's a webui bug. On Tuesday, May 11, 2021 at 11:51:00 pm UTC-3 divyan...@gmail.com wrote

May 11

Csingh Singh, Denis Zhuravlev6

May 8

[clickhouse]- RSS memory keep on growing till 80GB out of 128GB RAM and dropped suddenly once in 24 hours

Just a little background present here. The issue is not reproducible at other system, Getting at one

unread,

[clickhouse]- RSS memory keep on growing till 80GB out of 128GB RAM and dropped suddenly once in 24 hours

Just a little background present here. The issue is not reproducible at other system, Getting at one

May 8

joan.ba...@gmail.com, Denis Zhuravlev2

May 7

Question about "mutations_sync"

for query : ALTER TABLE A DELETE where 1 settings mutations_sync=2; for session : set mutations_sync=

unread,

Question about "mutations_sync"

for query : ALTER TABLE A DELETE where 1 settings mutations_sync=2; for session : set mutations_sync=

May 7

Filip Podstavec, … Amos Bird6

May 7

Access specific partitions in SELECT or the way how CH process data from partitions

I've added another possibility recently: _partition_value. This can be useful in real queries as

unread,

Access specific partitions in SELECT or the way how CH process data from partitions

I've added another possibility recently: _partition_value. This can be useful in real queries as

May 7

Des, … Denis Zhuravlev3

May 5

How to generate datetime (every minute) using generate_integer()

select toDateTime('2020-01-01 00:00:00') x, arrayMap(i -> x + interval i second, range(10)

unread,

How to generate datetime (every minute) using generate_integer()

select toDateTime('2020-01-01 00:00:00') x, arrayMap(i -> x + interval i second, range(10)

May 5

leeo...@gmail.com, … Vladimir Klimontovich3

May 5

insert big data into ClickHouse

Hi David! I'm not sure if a direct insert through JDBC driver will do the job at your scale. If

unread,

insert big data into ClickHouse

Hi David! I'm not sure if a direct insert through JDBC driver will do the job at your scale. If

May 5

Pierre, Denis Zhuravlev2

May 4

ReplicatedMergeTree and S3

ClickHouse release 21.4.1 2021-04-12 https://github.com/ClickHouse/ClickHouse/blob/master/CHANGELOG.

unread,

ReplicatedMergeTree and S3

ClickHouse release 21.4.1 2021-04-12 https://github.com/ClickHouse/ClickHouse/blob/master/CHANGELOG.

May 4

Dana Livni, Denis Zhuravlev2

Apr 30

Working with cluster - adding new node and more

https://youtu.be/4DlQ6sVKQaA On Thursday, April 29, 2021 at 7:54:12 am UTC-3 dana....@mail.huji.ac.il

unread,

Working with cluster - adding new node and more

https://youtu.be/4DlQ6sVKQaA On Thursday, April 29, 2021 at 7:54:12 am UTC-3 dana....@mail.huji.ac.il

Apr 30

Tiago Krebs, Denis Zhuravlev2

Apr 30

About views query performance

Order by pushdown is not implemented. CREATE TABLE access_logs ( `ts` DateTime, `source` String, `

unread,

About views query performance

Order by pushdown is not implemented. CREATE TABLE access_logs ( `ts` DateTime, `source` String, `

Apr 30

Apr 26

DB::Exception: Prediction is not supported

Hello I curious how can i use this query statement. Just wanted to follow this document - > https:

unread,

DB::Exception: Prediction is not supported

Hello I curious how can i use this query statement. Just wanted to follow this document - > https:

Apr 26

Tiago Krebs, Amos Bird3

Apr 22

About min_bytes_to_rebalance_partition_over_jbod

Thanks, I'll check it out. Em qui., 22 de abr. de 2021 às 07:39, Amos Bird <amosbird@gmail.com

unread,

About min_bytes_to_rebalance_partition_over_jbod

Thanks, I'll check it out. Em qui., 22 de abr. de 2021 às 07:39, Amos Bird <amosbird@gmail.com

Apr 22

sparsh sidana, Denis Zhuravlev2

Apr 20

Inserts to MV failing

>should be failing which shouldn't result in the discrepancy. It should not. It's not

unread,

Inserts to MV failing

>should be failing which shouldn't result in the discrepancy. It should not. It's not

Apr 20

Evgeny Lavrinenko

Apr 19

http handler problem

Hello everyone. I want to implement http handler but when I change settings in config.xml from the

unread,

http handler problem

Hello everyone. I want to implement http handler but when I change settings in config.xml from the

Apr 19

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

Search

Clear search

Close search

Google apps

Main menu