Re:Why is Snowflake so expensive
by kolinko on Monday August 22, 2022 @12:30PM
(#32553741)
in case of BigQuery it makes sense though - they use map reduce on distributed clusters, so there is no easy way to stop after 10 results are found
[ Parent
| on HN ]
Re:Why is Snowflake so expensive
by JimmyAustin on Monday August 22, 2022 @12:34PM
(#32553795)
It's pretty easy to limit the number of results returned by each partition to by limited to 10, then have that further reduced to 10 total during the reduce step.