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

Code: 306. DB::Exception: Received from localhost:9000. DB::Exception: Stack size too large. Stack address

Trying to deploy clickhouse on k8s to use as graphite backend. New to clickhouse I have gone through links with same issue but none is helping me. Trying to create two clickhouse servers planning to add one more in-future.. clickhouse server…
vicky
  • 23
  • 5
0
votes
1 answer

Create materialized view based on aggregate materialized view

The base table CREATE TABLE IF NOT EXISTS test_sessions ( session_id UInt64, session_name String, created_at DateTime ) ENGINE = MergeTree() PARTITION BY toYYYYMM(created_at) ORDER BY (session_id); With the following data INSERT…
cetver
  • 11,279
  • 5
  • 36
  • 56
0
votes
1 answer

ClickHouse Kafka Table Engine and exactly once support

I'm looking for some clarity as to if the Kafka Table engine supports exactly once semantics. I understand that clickhouse uses librdkafka, and that librdafka supports EOS as of v1.4. The latest versions of clickhouse are using librdkafka v1.5+. Is…
inquisitive
  • 3
  • 1
0
votes
1 answer

Cannot install a new clickhouse-server. Installation fails with Poco::Exception. Code: 1000

I am installing clickhouse-server and clickhouse-client locally on Ubuntu 20.04.1 LTS. I had a previous installation that worked fine, but at some point it was broken. After running officially recommended script from…
vitaliis
  • 4,082
  • 5
  • 18
  • 40
0
votes
1 answer

Clickhouse prioritize kafka import threads over other queries

TLDR; Is there any way to prioritize the kafka-engine import threads over any other CH threads OR can i reserve CPUs for the kafka consumers? In my setup, the kafkalag increases too much when issuing a big query. I guess, this is because the import…
the_dude
  • 11
  • 2
0
votes
1 answer

fail to connect to remote clickhouse-server with clickhouse-client

I hosted a clickhouse server on azure VM (I'm able to run clickhouse-client inside the VM) with a nginx proxy, below is the nginx setting server { listen 5000; server_name myhost.cloudapp.azure.com; …
dex
  • 77
  • 4
  • 13
0
votes
1 answer

UInt64 vs string in Clickhouse?

I store a big information in one table, the records go to about 1 bilion recors. I assume that after some time it will go above 4 bilion which is maximum of uint32. So I am wondering is uint64 faster than string in this case? Clickhouse has good…
Sakezzz
  • 468
  • 6
  • 16
0
votes
1 answer

Use raw strings in ClickHouse

I'm using regex to make some searches on strings with ClickHouse and as the docs say here Note that the backslash symbol () is used for escaping in the regular expression. The same symbol is used for escaping in string literals. So in order to…
Xoel
  • 318
  • 4
  • 15
0
votes
1 answer

How to improve the query speed of clickhouse

In clickhouse, I want to do a query operation. The query contains group by QJTD1, but QJTD1 is obtained by querying the dictionary. The statement is as follows: `SELECT IF( sale_mode = 'owner', dictGetString( 'dict.dict_sku', …
moneyleaf
  • 11
  • 5
0
votes
0 answers

clickhouse gives "create user" as syntax error

I have enabled access_management also but when I try show users or create user this is how I'm getting. 3e6af090665c :) show users; Syntax error: failed at position 6: show users; Expected one of: CREATE, TABLES, DICTIONARIES, PROCESSLIST Please…
Mammu yedukondalu
  • 136
  • 2
  • 14
0
votes
2 answers

how to query group by with group by?

My table: bucket | bytes | url ----- a | 111 | url_1 a | 222 | url_1 a | 222 | url_2 a | 222 | url_3 a | 222 | url_4 a | 222 | url_5 a | 222 | url_6 a | 222 |…
Rife
  • 487
  • 2
  • 7
  • 18
0
votes
1 answer

Helm template order for CustomResourceDefinition and ClickHouseInstallation

I have created a helm directory called clickhouse: Inside the template subdirectory I have a crd.yaml (kind: CustomResourceDefinition) which has to be run before the installation.yaml (kind: ClickHouseInstallation). Right now the installation.yaml…
user14965964
0
votes
1 answer

can't connect to Clickhouse database using apache Nifi

I am trying to connect to the Clickhouse database Using Apache Nifi. I can't fix this error. NIFI 1.12.1 StandardControllerServiceNode[service=DBCPConnectionPool[id=f73ad0c3-0176-1000-0546-94e4c6c6fe9b], versionedComponentId=null, …
ali
  • 81
  • 3
  • 13
0
votes
1 answer

Clickhouse - TTL - Move data to another table

Is it possible to transfer expired data into another table ? I want to implement an efficient mechanism to transfer previous day data into weekly table, previous week data into monthly table etc. I don't want to use multiple materialized views, to…
user
  • 43
  • 5
0
votes
1 answer

Clickhouse - Split arrayMap to colums to sort on

Ive a Clickhouse query question, Im pretty new to Clickhouse so maybe its an easy one for the experts ;)! We have a single table with events in, each event is linked to a product fe product_click, product_view. I want to extract the data grouped by…
Dimi
  • 279
  • 1
  • 3
  • 11
1 2 3
…
99
100