ClickHouse

1–30 of 1416

0 selected

Filip Podstavec, … Denis Zhuravlev8

Oct 21

Does Clickhouse support something like fulltext index?

Skip indexes work great (according to above answers) but now I have another problem - I need to

unread,

Does Clickhouse support something like fulltext index?

Skip indexes work great (according to above answers) but now I have another problem - I need to

Oct 21

Oct 12

ReplacingMergeTree or JOIN

Hey all, I'm starting a POC to build a data warehouse that pulls together event/alert/incident

unread,

ReplacingMergeTree or JOIN

Hey all, I'm starting a POC to build a data warehouse that pulls together event/alert/incident

Oct 12

Csingh Singh, tatiana....@lifestreet.com2

Oct 12

Clickhouse tables frequently goes into read-only mode

Replicated tables go readonly when ClickHouse loses its connection to ZooKeeper. They recover

unread,

Clickhouse tables frequently goes into read-only mode

Replicated tables go readonly when ClickHouse loses its connection to ZooKeeper. They recover

Oct 12

Amit Sharma, tatiana....@lifestreet.com2

Oct 12

Create user with default database

Wrong version? It was implemented in 21.9 On Monday, September 27, 2021 at 10:37:05 AM UTC-3 Amit

unread,

Create user with default database

Wrong version? It was implemented in 21.9 On Monday, September 27, 2021 at 10:37:05 AM UTC-3 Amit

Oct 12

Сергей Иванов, Ramazan Polat2

Oct 12

Does the old clickhouse run? Can you get DDL of tables with "show create table"? On Monday,

unread,

Does the old clickhouse run? Can you get DDL of tables with "show create table"? On Monday,

Oct 12

Oct 6

Zookeeper Auth Problem

Hello, I am trying to configure clickhouse with zookeeper replication in kubernetes using

unread,

Zookeeper Auth Problem

Hello, I am trying to configure clickhouse with zookeeper replication in kubernetes using

Oct 6

Дмитрий Кузнецов, Denis Zhuravlev3

Sep 21

count(expr) or COUNT(DISTINCT expr) stopped working

>And now it does not work select version(); This issue is already fixed in recent versions On

unread,

count(expr) or COUNT(DISTINCT expr) stopped working

>And now it does not work select version(); This issue is already fixed in recent versions On

Sep 21

divyan...@gmail.com

Sep 14

Query masking rules

Hi Community, I am going through following documentation for query masking rules and i have a very

unread,

Query masking rules

Hi Community, I am going through following documentation for query masking rules and i have a very

Sep 14

Sahar Imani, Denis Zhuravlev2

Sep 1

Value with Array type in ClickHouse dictionary

Array type was recently implemented in Dictionaries https://github.com/ClickHouse/ClickHouse/blob/

unread,

Value with Array type in ClickHouse dictionary

Array type was recently implemented in Dictionaries https://github.com/ClickHouse/ClickHouse/blob/

Sep 1

Aug 31

Hide Passwords from Server Configs

Hello, We want to hide the passwords mentioned in our server configs. EG: <shard> <replica

unread,

Hide Passwords from Server Configs

Hello, We want to hide the passwords mentioned in our server configs. EG: <shard> <replica

Aug 31

TIANYI HE, christophe...@gmail.com2

Aug 26

Cloud-native ClickHouse from TikTok

Hi, do you know if the source code will be available in the future? Le jeudi 26 août 2021 à 14:03:51

unread,

Cloud-native ClickHouse from TikTok

Hi, do you know if the source code will be available in the future? Le jeudi 26 août 2021 à 14:03:51

Aug 26

Aug 17

Benefits of using Parquet in Clickhouse?

Hi, Just I have came across that clickhouse is also supporting parquet format. Before going into it ,

unread,

Benefits of using Parquet in Clickhouse?

Hi, Just I have came across that clickhouse is also supporting parquet format. Before going into it ,

Aug 17

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

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

Search

Clear search

Close search

Google apps

Main menu