create temporary table orders (
order_product_id bigint,
order_customer_id bigint,
order_update_time as localtimestamp
'connector' = 'datagen',
'rows-per-second'='100',
'fields.order_status.length' = '3',
'fields.order_id.min' = '1',
'fields.order_id.max' = '10000',
'fields.order_product_id.min' = '1',
'fields.order_product_id.max' = '100',
'fields.order_customer_id.min' = '1',
'fields.order_customer_id.max' = '1000'
CREATE CATALOG paimon_catalog WITH (
'warehouse' = 'tos://paimon-dedicated-compaction/filesystem_catalog'
create database if not exists paimon_catalog.paimon_db;
CREATE TABLE IF NOT EXISTS `paimon_catalog`.`paimon_db`.`write_only_paimon_0_8_2_20250911` (
order_product_id bigint,
order_customer_id bigint,
PRIMARY KEY (order_id, dt, hh) NOT ENFORCED
) PARTITIONED BY (dt, hh) WITH (
'changelog-producer' = 'none',
'file.compression'='zstd'
insert into `paimon_catalog`.`paimon_db`.`write_only_paimon_0_8_2_20250911`
DATE_FORMAT(order_update_time, 'yyyyMMdd') AS dt,
DATE_FORMAT(order_update_time, 'HH') AS hh