mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
20 lines
518 B
SQL
20 lines
518 B
SQL
-- Origin SQL:
|
|
CREATE TABLE events
|
|
(
|
|
`event_time` DateTime,
|
|
`event_id` UInt64,
|
|
`user_id` UInt64,
|
|
`huge_string` String,
|
|
PROJECTION order_by_user_id
|
|
(
|
|
SELECT
|
|
_part_offset
|
|
ORDER BY user_id
|
|
)
|
|
)
|
|
ENGINE = MergeTree()
|
|
ORDER BY (event_id);
|
|
|
|
-- Format SQL:
|
|
CREATE TABLE events (`event_time` DateTime, `event_id` UInt64, `user_id` UInt64, `huge_string` String, PROJECTION order_by_user_id (SELECT _part_offset ORDER BY user_id)) ENGINE = MergeTree() ORDER BY (event_id);
|