benchmarks/sql_benchmarks/spill_views/load/distinct.sql

-- All-distinct string values. The Parquet dictionary falls back to plain
-- encoding, and there is no repeated data for spill compaction to remove.
--
-- 1M rows. `id` holds distinct values in shuffled order (7919 is
-- invertible modulo the prime 1000003), so ORDER BY id must really sort.
-- `s` is a 64-byte payload.
COPY (
  SELECT
    (value * 7919) % 1000003 AS id,
    'payload-' || lpad(CAST(value AS VARCHAR), 56, '0') AS s
  FROM generate_series(1, 1000000)
)
TO 'sql_benchmarks/spill_views/scratch/distinct.parquet'
STORED AS PARQUET;

CREATE EXTERNAL TABLE t
STORED AS PARQUET
LOCATION 'sql_benchmarks/spill_views/scratch/distinct.parquet';