Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
ClickHouse
Conversations
Labels
About
ClickHouse
1–30 of 1451
Mark all as read
Report abusive group
0 selected
karthi djax
Apr 23
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:
Apr 23
karthi djax
Apr 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
Apr 22
Sébastien Rebecchi
Apr 20
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
Apr 20
Rajesh Roy
Apr 19
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:
Apr 19
karthi djax
Apr 16
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
Apr 16
Maxim Fridental
,
Alexey Milovidov
2
Apr 14
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
Apr 14
karthi djax
Apr 11
Create view for huge records table
Hi, I have a table which get new records inserted every hour. From this tables am taking aggregation
unread,
Create view for huge records table
Hi, I have a table which get new records inserted every hour. From this tables am taking aggregation
Apr 11
karthi djax
,
Ivan Blinkov
4
Apr 2
ClickHouse date format
Aldo this works select DISTINCT date_time, date_sub(SECOND, 1, addHours(date_time, 1)) AS end_time
unread,
ClickHouse date format
Aldo this works select DISTINCT date_time, date_sub(SECOND, 1, addHours(date_time, 1)) AS end_time
Apr 2
CBS Archi
3
Mar 29
ZooKeeper Out of memory due to ClickHouse
Hello everyone, Do anyone have a clue regarding these? Thanks On Thursday, 10 March 2022 at 20:12:59
unread,
ZooKeeper Out of memory due to ClickHouse
Hello everyone, Do anyone have a clue regarding these? Thanks On Thursday, 10 March 2022 at 20:12:59
Mar 29
Xeno Amess
2
Mar 19
search from several tables in one query
the reason why we want this is we are migrating from ES to ClickHouse, and the original ES codes have
unread,
search from several tables in one query
the reason why we want this is we are migrating from ES to ClickHouse, and the original ES codes have
Mar 19
joan.ba...@gmail.com
3
Mar 15
IN clause with thousands of values
Sorry ... again ... The issue is sometimes an error code 62 is returned, but sometimes CH just
unread,
IN clause with thousands of values
Sorry ... again ... The issue is sometimes an error code 62 is returned, but sometimes CH just
Mar 15
Rishabh Shah
Mar 15
Clickhouse MergeFromLogEntryTask: Code: 74. DB::ErrnoException: Cannot read from file
Hello Everyone We have upgraded Clickhouse version form 20.8.12.2 ⇾ 21.12.4.1 After upgrading, we are
unread,
Clickhouse MergeFromLogEntryTask: Code: 74. DB::ErrnoException: Cannot read from file
Hello Everyone We have upgraded Clickhouse version form 20.8.12.2 ⇾ 21.12.4.1 After upgrading, we are
Mar 15
Denis Zhuravlev
,
Divya Sai Teja Pamarthi
2
Feb 24
Group spamfilter
Hi Denis, I refreshed the page and then I was able to see your replies on my question. Your
unread,
Group spamfilter
Hi Denis, I refreshed the page and then I was able to see your replies on my question. Your
Feb 24
Divya Sai Teja Pamarthi
,
Denis Zhuravlev
5
Feb 24
Need help to setup Zookeeper on Google Kubernetes
Hi Denis, I am really really thankful for your help. 1. I am using three nodes (2 Cpu , 4 GB RAM for
unread,
Need help to setup Zookeeper on Google Kubernetes
Hi Denis, I am really really thankful for your help. 1. I am using three nodes (2 Cpu , 4 GB RAM for
Feb 24
Kenji
,
Denis Zhuravlev
3
Feb 24
How to reload format schemas dynamically?
Thanks, Den. I will upvote. On Thursday, February 24, 2022 at 1:04:19 PM UTC-8 denis.z...@gmail.com
unread,
How to reload format schemas dynamically?
Thanks, Den. I will upvote. On Thursday, February 24, 2022 at 1:04:19 PM UTC-8 denis.z...@gmail.com
Feb 24
dyang
Feb 23
CANNOT_READ_MAP_FROM_TEXT error when try to load data with map field
Hi , I got a insert error like below when doing data ingest with clickhouse-client Code: 563. DB::
unread,
CANNOT_READ_MAP_FROM_TEXT error when try to load data with map field
Hi , I got a insert error like below when doing data ingest with clickhouse-client Code: 563. DB::
Feb 23
Maxim Fridental
,
Denis Zhuravlev
3
Feb 14
Sparse columns
Amazing! Thank you. denis.z...@gmail.com schrieb am Montag, 14. Februar 2022 um 15:50:01 UTC+1: see
unread,
Sparse columns
Amazing! Thank you. denis.z...@gmail.com schrieb am Montag, 14. Februar 2022 um 15:50:01 UTC+1: see
Feb 14
Divya Sai Teja Pamarthi
, …
Divya Sai Teja Pamarthi
3
Feb 11
ClickHouse Setup On Google Kubernetes Engine
Thanks Denis, I used the above material and setup clickhouse on GKE. It was really helpful. On Monday
unread,
ClickHouse Setup On Google Kubernetes Engine
Thanks Denis, I used the above material and setup clickhouse on GKE. It was really helpful. On Monday
Feb 11
Divya Sai Teja Pamarthi
,
Michael Smitasin
2
Feb 11
Purpose of ZooKeeper?
Hello Sai Teja, Indeed, you can run a cluster without ZooKeeper: "ZooKeeper is not a strict
unread,
Purpose of ZooKeeper?
Hello Sai Teja, Indeed, you can run a cluster without ZooKeeper: "ZooKeeper is not a strict
Feb 11
Amanali Bekbolat
, …
Iman Rahmat XL
3
Feb 11
Periodically uploading to Clickhouse Pandas Dataframe
Dear Amanali, The best way is like i found below import pandahouse as ph pdf = pandas.DataFrame.
unread,
Periodically uploading to Clickhouse Pandas Dataframe
Dear Amanali, The best way is like i found below import pandahouse as ph pdf = pandas.DataFrame.
Feb 11
凌涛
Jan 11
Clickhouse will build failed when -DUSE_HDFS for cmake is 1
Hi all: I want to test HDFS Engine on my local environment. But I found Clickhouse doesn't
unread,
Clickhouse will build failed when -DUSE_HDFS for cmake is 1
Hi all: I want to test HDFS Engine on my local environment. But I found Clickhouse doesn't
Jan 11
Amit Sharma
2
Jan 5
Materialized view to table with EmbeddedRocksDB engine
Thank you Denis for the sample. I realized later that I had the wrong column aliases in the
unread,
Materialized view to table with EmbeddedRocksDB engine
Thank you Denis for the sample. I realized later that I had the wrong column aliases in the
Jan 5
ervin...@gmail.com
,
Denis Zhuravlev
4
12/24/21
Upgrading docker image from 20.4.8.99 to latest (21.11.8.4)
Thank you Denis, that fixed the issue. On Friday, December 24, 2021 at 5:07:59 PM UTC+1 denis.z...@
unread,
Upgrading docker image from 20.4.8.99 to latest (21.11.8.4)
Thank you Denis, that fixed the issue. On Friday, December 24, 2021 at 5:07:59 PM UTC+1 denis.z...@
12/24/21
Fatlum Bajrami
,
Alexey Milovidov
3
12/24/21
IO utilization stuck at 99%
Thank you Milovidov for the replay, This was a gcp instance ubuntu 16.04 after some reading i had the
unread,
IO utilization stuck at 99%
Thank you Milovidov for the replay, This was a gcp instance ubuntu 16.04 after some reading i had the
12/24/21
Amanali Bekbolat
,
Alexey Milovidov
2
12/21/21
Cosine Similarity
Hi! Since ClickHouse version 21.11 we have dedicated functions for cosine similarity: https://
unread,
Cosine Similarity
Hi! Since ClickHouse version 21.11 we have dedicated functions for cosine similarity: https://
12/21/21
Naveen Bandi
12/20/21
Issue running ALTER TABLE on distributed tables
Hi Everyone, I have created distributed table on clickhouse cluster and trying to do ALTER DELETE on
unread,
Issue running ALTER TABLE on distributed tables
Hi Everyone, I have created distributed table on clickhouse cluster and trying to do ALTER DELETE on
12/20/21
dyang
,
Denis Zhuravlev
3
12/14/21
sumMap function discrepancy between local mode and server mode
So this kind of usage should be okay soon . thanks! 在2021年12月14日星期二 UTC+8 21:08:36<denis.z...@
unread,
sumMap function discrepancy between local mode and server mode
So this kind of usage should be okay soon . thanks! 在2021年12月14日星期二 UTC+8 21:08:36<denis.z...@
12/14/21
Ofer Fort
,
Denis Zhuravlev
2
12/14/21
populate a Nested column with data from another table
https://stackoverflow.com/questions/55764093/updating-rows-with-values-from-another-table-in-
unread,
populate a Nested column with data from another table
https://stackoverflow.com/questions/55764093/updating-rows-with-values-from-another-table-in-
12/14/21
Pavan Badi
12/8/21
getting Authentication Failed for Distributed table
Hi Team, I am trying to evaluate Clickhouse databases now I am in a stage of distribution table, I
unread,
getting Authentication Failed for Distributed table
Hi Team, I am trying to evaluate Clickhouse databases now I am in a stage of distribution table, I
12/8/21
Sahar Imani
,
Vladimir
2
12/6/21
A problem in using ip_trie layout
Hi! Dictionaries ip_trie doesn't support nullable attributes now (line of code if you interested
unread,
A problem in using ip_trie layout
Hi! Dictionaries ip_trie doesn't support nullable attributes now (line of code if you interested
12/6/21