CREATE TABLE orders
(
id INT
,name VARCHAR
,grass_date VARCHAR
)
WITH
(
FORMAT = 'Parquet',
PARTITIONED_BY = array['grass_date']
)
;
INSERT INTO orders
VALUES
(1, 'part-1', '2020-11-18'),
(2, 'part-2', '2020-11-18'),
(3, 'part-3', '2020-11-19'),
(4, 'part-4', '2020-11-19'),
(5, 'part-5', '2020-11-20'),
(6, 'part-6', '2020-11-20');
Presto 创建表例子
于 2022-04-20 17:34:58 首次发布