(simonwillison.net)

152 points po | 1 comments | 20 Nov 24 08:19 UTC | HN request time: 0.279s | source

1. hu3 ◴[20 Nov 24 11:14 UTC] No.42192792[source]▶

Nice. Works with clickhouse local cli too.

./clickhouse local -q "select count(*) from s3('s3://fsq-os-places-us-east-1/release/dt=2024-11-19/places/parquet/places-00000.snappy.parquet');"

prints: 4180424

Foursquare Open Source Places: A new foundational dataset