Questions tagged [ClickHouse] (1)

1
answer

Does the NoSQL database delete and edit lines?

We plan to use the Click House & elastic search for storing logs. Periodically a situation arises where you need to delete some logs or make changes to them. If these two bases to do this?
ava.Kovacek asked April 8th 20 at 18:30
1
answer

How should I store the data in the column or array in ClickHouse?

There are polmilliarda objects, with thousands of attributes (as numbers). Question how should I store attributes in ClickHouse, to quickly find objects with the right attributes, a list of the attributes, and then use hasAny, or in the form of columns (bool)? Fear that when using attributes as columns, you get too low tab...
John_Howell asked April 8th 20 at 17:44
1
answer

How to install clickhouse-jdbc?

Hi all. Difficulties arose when creating JdbcSinkConnector, which would shift data from a Kafka topic in the table Clickhouse: java.sql.SQLException: No suitable driver found for jdbc:clickhouse://localhost:8123/default at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnecti...
Delaney asked April 8th 20 at 09:39
1
answer

How to use like inside a custom variable for Grafana query Clickhouse?

Gathered a bunch Clickhouse + Grafana for this article https://habr.com/ru/post/484640/ I would like to use a single template in Grafana, in which it would be possible to edit variables to change substring the substring AND the request_uri LIKE '%my sub-string in request_uri%' to all dashboards adjusted to this line. Maybe...
Alexys_Schul asked April 7th 20 at 16:15
0
answer

How to delete a record in a large database Clichouse(80 GB)?

How to delete a record in a large database Clichouse(80 GB)?
georgette64 asked April 7th 20 at 11:34
0
answer

How to convert a binary representation to a string?

There is data in clickhouse stored in FixedString(6) the string looks like (&(): the idea is if I use bin2hex 6 bytes should turn into 12 bytes (hex) but in fact all the values are different. Can be 6, 7, 8, 10 and 12 bytes. Because the data of 6 bytes What can be the reason?
dino.Brakus83 asked April 4th 20 at 01:16
0
answer

How to convert from fixedstring(6) in the normal macadress?

There are data on makatea in clickhouse in FixedString(6) how you can convert them using php in their normal form of macadress Tried to do this:$Mac=bin2hex($dann_clickhouse); In response get something like: c8be19efbfbd0c1f and how to reduce it to the form type: E8-40-F2-05-BA-EF
maye60 asked April 4th 20 at 00:56
2
answers

How to persist data in ClickHouse?

I have a task to write a type system Yandex Metrics: users will be hung on the website js code, it will store information about all visits for Analytics and statistics. My choice fell on ClickHouse. Prompt how most effectively to build such an architecture? It is planned not less than 100k records a day to do. The main bott...
Vita_Mraz45 asked April 4th 20 at 00:53
0
answer

In clickhouse to use the IN operator with Ipv6?

I have a query which works well for IPv4SELECT toMinute(toStartOfFiveMinute(minute)) as date_day_minute, sum(qwe1+qwe2) as sumqwe FROM IPv4 WHERE IP IN(3232253331, 3232253332) GROUP BY ORDER BY date_day_minute date_day_minute if you try to do the same for Ipv6 gives the error "DB::Exception: Illegal String type of argument ...
Eriberto_Lark asked April 1st 20 at 16:21
1
answer

As the values of the strings to convert to array?

there are lines zoo_id animal quantity 1 giraffe 3 2 giraffe 2 1 Behemoth 1 2 Hippo 4 quantity to convert into an array grouping on the animal the giraffe [3, 2] Behemoth [1, 4] Is it possible to clickhouse ? if so, how ?
Annabelle_Cruickshank asked March 30th 20 at 00:34