Questions tagged [clickhouse]

Use this tag when referencing Yandex' ClickHouse database management system.

Filter by
Sorted by
Tagged with
0
votes
1answer
57 views

Clickhouse create database structure for json data

New to clickhouse and stuck on the database creation structure for importing json data which is nested Take for example the json data that looks like the following when there is data populated "...
0
votes
2answers
32 views

count distinct events per day

I have dataset: timestamp event user 2020-04-28 20:07:55.503 log_in john 2020-04-28 20:08:01.996 log_out john 2020-04-28 20:08:02.470 log_in john 2020-04-28 20:08:03.996 log_out ...
3
votes
3answers
238 views

Continuously move data from server A to Server B while deleting the data in server A?

I'm developing an ad server that is expected to handle ad impressions/billion clicks per day. The most difficult challenge I am facing is moving data from one server to another. Basically the flow ...
2
votes
1answer
229 views

Correlated subqueries. Count Visits after Last Purchase Date

I'm pretty new to SQL and have been trying to solve this task for a while...still no luck. I would appreciate if someone here could help me out. I have a database with columns: ClientID VisitID ...