clickhouse create local table

CREATE TABLE IF NOT EXISTS food ( `good_id` String, `delivery_fee` String, `province` String, `district` String, `emotionalKeywords` String, `shopId` String, `longitude` Float64, `registration_institution` String, `goodRatePercentage` String, `shopSellCount` String, `min_delivery_price` String, `phone` String, `opening_hours` String, `sellCount` UInt32, `goodDescription` String, `delivery_mode` String, `city` String, `latitude` Float64, `praiseNum` UInt32, `shopName` String, `city_grade` String, `title` String, `categoryName` String, `shopCommentCount` String, `salesAmount` Float64, `street` String, `administrative_region` String, `platformName` String, `priceText` Float64, `licencePics` String, `address` String, `shopImages` String, `platformId` UInt16, `rootCategoryId` String, `timeStamp` String, `original_cost` String, `shopDescription` String, `rootCategoryName` String, `categoryId` String ) ENGINE = MergeTree() PARTITION BY timeStamp ORDER BY (platformName, good_id) SETTINGS index_granularity = 8192;

Leave a Reply

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