Stack Overflow
Stack Overflow

Questions tagged [clickhouse-client]

58 questions
0
votes
2 answers

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 single node clickhouse and then tired to restore it…
Arpit Srivastava
  • 9
0
votes
1 answer

How to read click house tables from Python Azure function?

I need to read the tables from click house via Python Azure function, I am able to read the tables from my local system but not able to read from Python Azure Function. What I tried: import clickhouse_connect client =…
Nason Thomas
  • 35
  • 4
0
votes
0 answers

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) com.clickhouse clickhouse-jdbc …
kvb
  • 1
  • 1
0
votes
2 answers

Clickhouse row policy and default user behavior

Problem: Created User with role and row policies do not see data from all shards unless default user is granted the same row policies. Setup is the following: I have clickhouse cluster, 3 shards(2 replicas each shard). …
Maik Jevdokimov
  • 1
  • 3
0
votes
0 answers

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++ client through SQL queries. The overall idea is…
harry_g
  • 43
  • 1
  • 6
0
votes
1 answer

Clickhouse Memory Limit Exceeded on Joins

I am trying to execute the following query with Clickhouse which joins 4 tables: select s.branch_id AS branch_id, pa.sharer_id as sharer_id, si.commission_type_id as commission_type_id, bp.product_id as…
Gerrit van Zyl
  • 1
  • 2
0
votes
1 answer

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 clickhouse, the result is this like: # clickhouse client…
Zhang Hanwen
  • 1
0
votes
1 answer

A setting's value string has to be an exactly one character long

I recently installed Clickhouse on my pc to work with a huge .csv (9Gb) I know the columns names in this .csv file, so I easily created the table in the Clickhouse console CREATE DATABASE IF NOT EXISTS MY_DB CREATE TABLE MY_DB.MY_TB ( "RC" …
mrR
  • 11
  • 1
0
votes
2 answers

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 the code is this: for domain_data in…
Ali Esmaeili
  • 153
  • 8
0
votes
0 answers

Got a TypeError("unhashable type: 'dict'") using insert_dataframe method clickhouse-driver.Client

I start to use clickhouse-driver Client in my data pipelines and every time I faced an issue: TypeError("unhashable type: 'dict'") I know this kind of error that dict is not hashable type, but maybe I was wrong in arguments which i used below? cl =…
maiseo4allPYwarrior
  • 43
  • 6
0
votes
2 answers

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. ubuntu :) create table…
recepyiyit
  • 3
  • 3
0
votes
0 answers

Understanding Background merges in ClickHouse

I wanted to understand background merges better. I understand that background merges keep happening until it reaches 150GB as defined by max_bytes_to_merge_at_max_space_in_pool. I would like to understand following. Are all parts ordered by ORDER…
Himanshu
  • 1
  • 1
0
votes
1 answer

Insert data into a ClickHouse table from a file with deduplication

I'm importing data into a ClickHouse table from CSV files. cat data.csv | clickhouse-client --config-file=config.xml --query="INSERT INTO data_pool FORMAT CSVWithNames" Often CSV files contain duplicate entries that are already in the ClickHouse…
Greg
  • 137
  • 2
  • 11
0
votes
1 answer

Clickhouse: Want to extract data from Array(Nested) column in Clickhouse

Query used to create the table: CREATE TABLE default.ntest2( job_name String, list_data Array(Nested(s UInt64, e UInt64, name String)) ) ENGINE = MergeTree ORDER BY (job_name) SETTINGS index_granularity = 8192; Table…
Yash Chauhan
  • 174
  • 13
0
votes
1 answer

Clickhouse: Want to extract data from Array(Tupple) column in Clickhouse

Query used to create the table: CREATE TABLE default.ntest2(job_name String, list_data Array(Tuple(s UInt64, e UInt64, name String))) ENGINE = MergeTree ORDER BY (job_name) SETTINGS index_granularity = 8192; Table…
Yash Chauhan
  • 174
  • 13
1
2
3 4