Hello, fishman

Posts

clickhouse 建表

admin
CREATE TABLE IF NOT EXISTS phone (`id` Int32, `good_id` String, `title` String, `province` Nullable(String), `city` Nullable(String), `brandName` Nullable(String), `shopName` Nullable(String), `platFormName` String, `sellCount` Int32, `priceText` Float64, `salesAmount` Nullable(Float64), `model` Nullable(String), `rom` Nullable(String), `color` Nullable(String), `ram` Nullable(String), `name` Nullable(String), `timeStamp` String ) ENGINE = MergeTree() PARTITION BY timeStamp ORDER BY (platFormName, good_id) SETTINGS index_granularity = 8192;
Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top