Stack Overflow
Stack Overflow

Questions tagged [clickhouse]

ClickHouse is an open-source column-oriented DBMS for real time analytical reporting which has Capability to store and process petabytes of data.

ClickHouse is an open-source column-oriented database management system that allows generating analytical data reports in real time.

1835 questions
0
votes
1 answer

clickhouse : left join using IN

I wish to perform a left join based on two conditions : SELECT ... FROM sometable AS a LEFT JOIN someothertable AS b ON a.some_id = b.some_id AND b.other_id IN (1, 2, 3, 4) I got the error: Supported syntax: JOIN ON Expr([table.]column,…
RogerFromSpace
  • 406
  • 4
  • 17
0
votes
0 answers

Postgresql push uuid field to Clickhouse data type error

I am trying to push data from PG-12 to Clickhouse via FDW extension ("clickhouse_fdw") and it gives me error: SQL Error [HV004]: ERROR: cannot convert constant value to clickhouse value Hint: Constant value data type: 2950 Sherlocking gave me…
Ivan Kolyhalov
  • 902
  • 11
  • 16
0
votes
1 answer

How to migrate Clickhouse's Zookeeper to new instances?

I'm hosting ClickHouse (v20.4.3.16) in 2 replicas on Kubernetes and it makes use of Zookeeper (v3.5.5) in 3 replicas (also hosted on the same Kubernetes cluster). I would need to migrate the Zookeeper used by ClickHouse with another installation,…
AndD
  • 2,281
  • 1
  • 8
  • 22
0
votes
1 answer

Clickhouse External Dictionary not loading

I've created an external cache dictionary which I load on start by setting dictionaries_lazy_load as False. The external dictionary is present in system.dictionaries as follows: database…
Maximilian Powers
  • 25
  • 5
0
votes
1 answer

ClickHouse SQL driven access control replication

I'd like to enable SQL-driven Access Control and Account Management as mentioned in ClickHouse docs https://clickhouse.tech/docs/en/operations/access-rights/ However, it does not state whether sql-managed users are then replicated across cluster or…
simPod
  • 11,498
  • 17
  • 86
  • 139
0
votes
0 answers

ClickHouse doesn't synchronize new table from MySQL

I am using ClickHouse with MySQL Replication by the below command. CREATE DATABASE ExampleDb ENGINE = MaterializeMySQL('mysql:3306', 'db', 'admin', 'password'); It works wells for inserting and updating data on the existing tables. However, if I…
Ken Yip
  • 599
  • 1
  • 8
  • 17
0
votes
1 answer

ClickHouse log shows hash of uncompressed files doesn't match

ClickHouse logs printed the error messages as below frequently: 2021.01.07 00:55:24.112567 [ 6418 ] {} vms.analysis_data (7056dab3-3677-455b-a07a-4d16904479b4): Code: 40, e.displayText() = DB::Exception: Checksums of parts don't match:…
bluelullaby
  • 17
  • 6
0
votes
1 answer

Overwriting clickhouse-backup default config

I want to create a backup of my clickhouse database. I'm following the guide here. As recommended in the guide I'm using the official tiny docker image for clickhouse-backup. When running for instance: $ clickhouse-backup tables I'll receive this…
user14628143
0
votes
2 answers

ploting filtered results from clickhouse in grafana not working

I'm really new in grafana and clickhouse, I'm trying to do a filtered dashboard in grafana with information from some CSV logs loaded on clickhouse , this is how it looks the query on clickhouse: I want to plot that in grafana, my table name is…
Jesus Briceño
  • 103
  • 1
  • 5
0
votes
1 answer

Should I wait for async delete in ClickHouse before starting inserts?

I need to reload data for the last day in ClickHouse. My idea is to delete rows for the last day using ALTER TABLE DELETE statement and then insert the updated rows. I've already found in the documentation: "Mutations are also partially ordered with…
Stanislav
  • 4,389
  • 2
  • 33
  • 35
0
votes
1 answer

clickhouse remote connection issue

I have a clickhouse server running in my local network. I could access it through 192.168.0.96:9000 on the other machines in the same network. However, after I forwarded the port 9000, and try to access outside the local network using (my IP)…
JOHN
  • 871
  • 1
  • 12
  • 24
0
votes
1 answer

Group by on clickhouse with condition less than grouped column

I have part of sql code : select ,inst_date ,country ,count (distinct (case when (event_day - inst_date) <= 0 then id end)) as event_0 ,count (distinct (case when (event_day - inst_date) <= 1 then id end)) as event_1 ,count…
mitrik_bnr
  • 27
  • 6
0
votes
1 answer

When using clickhouse-jdbc, I occasionally encounter this error when querying data, and I wonder what the reason is?

ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: xxx.xxx.xxx.xxx, port: 8123; xxx.xxx.xxx.xxx:8123 failed to respond at…
liujie
  • 11
  • 1
0
votes
1 answer

How can I create a table with ReplicatedReplacingMergeTree engine on clickhouse?

I've been used clickhouse for a while, but it really confused me a lot. So the problem is, when I'm trying to create a table with ReplicatedReplacingMergeTree engine, I set the engine as ENGINE =…
Vincent
  • 57
  • 1
  • 8
0
votes
1 answer

How to synchronize data from clickhouse to mysql?

I have created a materialized view, I can execute sql to get some result through clickhouse-client, but how can I save the result data to another mysql database?
king
  • 300
  • 1
  • 13
1 2 3
…
99
100