1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
# name: test/sql/parallelism/intraquery/parallel_sample.test
# description: Test parallel reservoir sampling
# group: [intraquery]
statement ok
PRAGMA enable_verification
statement ok
PRAGMA threads=4
statement ok
PRAGMA verify_parallelism
statement ok
PRAGMA enable_profiling='json'
statement ok
PRAGMA profiling_output='__TEST_DIR__/test.json'
statement ok
PRAGMA profiling_mode = detailed
statement ok
CREATE TABLE integers AS SELECT * FROM range(50000) tbl(i)
loop i 0 3
query I
SELECT COUNT(*) FROM integers TABLESAMPLE RESERVOIR(100)
----
100
endloop
|