I’m really new in grafana and clickhouse, I’m trying to do a filtered dashboard in grafana with information from some CSV logs loaded on clickhouse , this is how it looks the query on clickhouse: I want to plot that in grafana, my table name is logsb and using default db, column where looking matc…
Tag: clickhouse
SQL query to get data without hours in timestamp column
I have written a code and sql query to get data from database: I get this dataframe: I want to write another query to get data only for 2019-05-29: but it brings me an error: How could i do that? How could i get rid of hours in timestamp column in my sql query? Desired result is: Answer toDate(timestamp) SELE…
ClickHouse: How to store JSON data the right way?
I’m going to migrate data from PostgreSQL database to Yandex’s ClickHouse. One of the fields in a source table is of type JSON – called additional_data. So, PostgreSQL allows me to access json attributes during e.g. SELECT … queries with ->> and -> and so on. I need the same b…
How can I find duplicate records in clickhouse [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question I want to know how I can find duplicate data entries within one table in clickhouse. I am act…
include “0” count result in clickhouse
I have one t_table(some_date, id), and i want get count of ids for each day between two input dates. I try this query: SELECT dateDiff(‘day’, toDateTime(‘2020-07-01 07:34:22’), some_date) as day, …
SQL request to Clickhouse: select if value exist in JSON array
I’ve got a following table: How can I do ‘select Status where Name XXX represented at least in one Array[i].Name’? Answer
How to search the string in query with case insensitive on Clickhouse database?
I am developing site using PHP and backend ClickHouse database. When i using like queries , it is not supporting case-sensitive words. select id,comments from discussion where comments LIKE “%Data …