You can export the whole dataset as described here: https://github.com/ClickHouse/ClickHouse/issues/29693 https://github.com/ClickHouse/ClickHouse/issues/29693

You can export the whole dataset as described here: https://github.com/ClickHouse/ClickHouse/issues/29693 https://github.com/ClickHouse/ClickHouse/issues/29693 Or query one of the preloaded datasets: https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPTSBoYWNrZXJuZXdzIFdIRVJFIGJ5ID0gJ3RoeXJveCcgT1JERVIgQlkgdGltZQ== https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT... curl https://clickhouse.com/ | sh ./clickhouse client --host play.clickhouse.com --user play --secure --query "SELECT * FROM hackernews WHERE by = 'thyrox' ORDER BY time" --format JSON