Questions tagged [ClickHouse] (1)

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?

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...

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...

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...

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

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?

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

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...

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 ...

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 ?