91 questions
0
votes
1
answer
93
views
Connection check failed: Error: Client network socket disconnected before secure TLS connection was established from Clichouse cloud service
Connection check failed: Error: Client network socket disconnected before secure TLS connection was established
Environment:
ClickHouse Cloud Service
Issue:
When trying to connect my application to ...
- 21
1
vote
0
answers
151
views
sample code to add map type columns using clickhouse-cpp
I have created a testing clickhouse table -
CREATE TABLE test.map_table (
tags Map(Int32, Int32)
) ENGINE = MergeTree()
ORDER BY tuple();
My goal is to insert rows here using the clickhouse-cpp ...
- 23
0
votes
2
answers
227
views
Python clickhouse-client Async Insert
Use Case:
I'm using python clickhouse-client to establish a connection to my clickhouse cluster and insert data. I'm copying the data from azure blob storage and my query looks something like:
INSERT ...
0
votes
1
answer
64
views
Clickhouse VALUE_IS_OUT_OF_RANGE_OF_DATA_TYPE for Nullable(Date) having null values for date columns
A column having the null dates in the ORC file, while trying to fetch using S3 engine,
encountering with an exception regarding the retrieving the null value from the s3 ORC file.
When the same ORC ...
1
vote
0
answers
129
views
Clickhouse, Python and disappearing temporary tables
I have created a CH client using a session_id but it seems my temporary tables disappear after a few minutes (whilst I interactively explore in an iPython session).
session_id = str(uuid.uuid4())
...
- 729
0
votes
0
answers
100
views
Clickhouse server unreachable when using the INET IP to connect
I am able to install clickhouse-server (version 24.11.1.2557) on my Ubuntu machine (version 22.04.5). I confirm that the service started successfully by:
a. Checking the log
2024.12.03 21:26:40.561958 ...
- 1,684
1
vote
0
answers
78
views
Convert Timescaledb query to Clickhouse query
Following are the queries in timescaledb which i need to convert into clickhouse as clickhouse supports timeseries data as well
Following are the timescaledb queries:
CREATE MATERIALIZED VIEW
...
0
votes
0
answers
599
views
ClickHouse cluster connection timeout and address errors using spring JDBC
We are trying to connect to a ClickHouse cluster (containing 4 nodes and 3 ClickHouse-keepers) using the JDBC connector. When I test the performance with 100, 200, or 300 threads (users), after some ...
- 1
1
vote
1
answer
1k
views
Backup ClickHouse cluster database without using clickhouse-backup utility
I have a three node clickhouse cluster database that I need backup using Clickhouse backup command.
replica = 1
shard = 3
I tried local storage available as shared on all nodes and s3 storage.
When I ...
0
votes
0
answers
187
views
Insertion in distributed data tables for multiregion click house deployment
Say I have two regions - DC1 and DC2 . Let's consider that I have 9 nodes in DC1 and DC2 with 3 replicas in each DC for 5 shards. In this case , if I trigger an insert statement to a distributed table ...
- 991
0
votes
0
answers
362
views
Keeper Clickhouse Replication DDL on cluster, but no replication data, error "Table was in readonly mode"
In the test, the Keeper process replicates the DDL in the cluster, but a table of type ReplicatedMergeTree, it creates it in all the nodes, but when I insert information into the table, the data only ...
0
votes
1
answer
163
views
runningDifference() not working in clickhouse for this serinario
In clickhouse lag/lead functions are not supporting, i used runningDifference(), for this scenario it's not working.
select endtime, runningDifference(endtime) as time_diff
from
(select ...
0
votes
2
answers
893
views
ClickHouse view - AggregateFunction column vs usual column
I have declared my aggregation table as:
CREATE TABLE test.system_aggr
(
system_id String,
aggr_val AggregateFunction(sum, Int64)
)
ENGINE = AggregatingMergeTree
ORDER BY (system_id)...
- 3,574
0
votes
0
answers
304
views
Clickhouse JDBC version > 0.4.x fails in Cloud
I have to connect a java cloud application to clickhouse cloud database. The restriction is that the certificate cannot be uploaded to the cloud application.
clickhouse-jdbc version 0.3.2 works ...
- 469
4
votes
1
answer
10k
views
Clickhouse CLI: Multi-statements are not allowed exception
I am trying to execute this query using the Clickhouse CLI:
INSERT INTO t VALUES (1, 'Hello, world'), (2, 'abc'), (3, 'def')
which I found here: https://clickhouse.com/docs/en/sql-reference/syntax
but ...
- 89
1
vote
1
answer
189
views
Execution timeout when loading csv file to ClickHouseContainer
When attempting to upload a CSV file (~100 lines and < 100KB) to ClickHouseContainer running in junit, the client is timing out with the following error:
An exception or error caused a run to abort:...
- 480
0
votes
1
answer
2k
views
how insert data into clickhouse table with permission denied?
Got error while inserting date into Clickhouse table:
clickhouse_connect.driver.exceptions.DatabaseError: :HTTPDriver for http://localhost:8123 returned response code 500)
std::exception. Code: 1001, ...
- 1
0
votes
2
answers
3k
views
How to get current queries to max_concurrent_queries
I encountered this error：
clickhouse_driver.errors.ServerException: Code: 202. DB::Exception: Too many simultaneous queries. Maximum: 200. Stack trace:
but I have adjusted the max_concurrent_queries ...
- 1
0
votes
0
answers
292
views
Clickhouse backup failure - Table has its shared ID to be different from one from the create query
In a clickhouse 3 shard, 3 replica setup, I am trying to take a schema backup.
But it fails with following error :
BACKUP DATABASE default
TO S3( 'https://bucket-id.s3.amazonaws.com/backup_folder/...
- 12k
1
vote
2
answers
2k
views
Steps to migrate my clickhouse data from single node to replicated cluster
I am trying to find a way to move my data from single node standalone clickhouse to new replicated cluster. But there are no solid documents available to perform that.
I tried to take backup from ...
1
vote
0
answers
2k
views
How to perform batch inserts to clickhouse using JDBC client?
I am trying to write into clickhouse DB using Clickhouse JDBC client (0.4.0)
<!-- https://mvnrepository.com/artifact/com.clickhouse/clickhouse-jdbc -->
<dependency>
<groupId>com....
- 11
0
votes
1
answer
629
views
Divide ClickHouse table into distinct logical chunks for parallel reading
I want to read a ClickHouse table in parallel from multiple clients. The table is unpartitioned and uses the MergeTree engine. My application is in C++ and is communicating with ClickHouse over its C++...
- 53
0
votes
1
answer
164
views
In ClickHouse, catboostEvaluate method for catboost classification model returning values like regression models
I'm using catboostEvaluate method to predict a classification problem.
In Catboost, the evaluation result is like this:
model.predict(X_validation)
array([0, 0, 0, ..., 1, 0, 0])
However, in ...
0
votes
2
answers
3k
views
How to update columns in clickhouse multiple times in a session?
I want to update values of diffrent columns multiple time in a session but just first query is working and other queries that they are in the loop is not update.
I use a loop for my multiple query and ...
- 312
-1
votes
2
answers
4k
views
clickhouse table creation error in ubuntu
I installed the clickhouse program in the ubuntu operating system and connected the SQLyog program. I can create a database, but I cannot create a table in it. It gives the following CODE:119 error.
...
