25 questions
0
votes
1
answer
63
views
Bloom index not helping in speeding up queries in clickhouse
We've recently started using Clickhouse and wrote a query to filter entries based on sha data like column named sha_data(256 bit hash). We have a primary index based on 4 other columns in which ...
- 1,574
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
0
answers
301
views
Clickhouse asynchronous_insert_log table not visible
asynchronous_insert_log table is not there under system db in clickhouse. My config.xml contains below configuration by default:
<clickhouse>
<!-- Other settings -->
<...
0
votes
1
answer
673
views
Reproducing ClickHouse Client CLI query result format using Golang ClickHouse library
Clickhouse CLI result
When performing a query using the clickhouse-client command line interface and setting the format as JSON, we not only obtain the result but also statistics.
Command
clickhouse-...
- 2,104
0
votes
1
answer
1k
views
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 =...
- 376
0
votes
1
answer
934
views
playtika.testcontainers Error creating bean with name 'embeddedClickHouse'
I am trying to run tests using playtika.testcontainers embedded-clickhouse, which used to work, but now I am getting java.lang.IllegalStateException: Failed to load ApplicationContext, caused by ...
- 153
1
vote
1
answer
2k
views
Scanning sum() of Decimal type with Go, sqlx, ClickHouse
I have a "Duration" field of type Decimal(38, 3) in a ClickHouse table.
From my Golang service I'm sending a query to get the SUM() of it but I just can't scan the result back. I tried using ...
1
vote
0
answers
787
views
Clickhouse http interface read Native/RowBinary Format data
Want to get the query statistics info like rows_read/bytes_read for a query. But using the native interface(golang client), it seems impossible.
And using Http interface we could get it in the header ...
- 33
1
vote
1
answer
4k
views
ClickHouse - SELECT row of data is too slow
The following problem occurred in our project, which we cannot solve.
We have a huge data of our logs, and we go to ClickHouse from MongoDB.
Our table is created like this:
CREATE TABLE IF NOT EXISTS ...
- 13
1
vote
1
answer
3k
views
How to change order of composed primary key in clickhouse efficiently
I have a table with schema
CREATE TABLE traffic (
date Date,
val1 UInt64,
'val2' UInt64
...
) ENGINE = ReplicatedMergeTree(date, (val1, val2), 8192);
the partition key is date here. I want to change ...
- 79
2
votes
3
answers
9k
views
Getting lot of "DB::NetException: Connection reset by peer, while reading from socket" errors that are creating lot of noise
I am running click house version '20.6.4' with default settings.While walking through the logs i found these logs in abundance.
ServerErrorHandler: Code: 210, e.displayText() = DB::NetException: ...
- 79
3
votes
2
answers
6k
views
Clickhouse : import data having double quotes escaped by backslash
I am trying to import a html snippet which is part of one of the column in csv.
There are double quotes in the html snippet and its is escaped. this csv is created using apache spark.
for ...
- 663
0
votes
2
answers
1k
views
How initialize the result of groupArray function of the ClickHouse to the array
In my Go application, I make a request to the ClickHouse database via clickhouse-go package. This query which I make return always only one record and it's an array of integers. Is there any way to ...
- 5,276