mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
12 lines
374 B
SQL
12 lines
374 B
SQL
-- Origin SQL:
|
|
CREATE TABLE example1 (
|
|
timestamp DateTime,
|
|
x UInt32 TTL timestamp + INTERVAL 1 MONTH,
|
|
y UInt32 TTL timestamp + INTERVAL 1 WEEK
|
|
)
|
|
ENGINE = MergeTree
|
|
ORDER BY tuple()
|
|
|
|
-- Format SQL:
|
|
CREATE TABLE example1 (timestamp DateTime, x UInt32 TTL timestamp + INTERVAL 1 MONTH, y UInt32 TTL timestamp + INTERVAL 1 WEEK) ENGINE = MergeTree ORDER BY tuple();
|