Hello, fishman

Posts

create gehu table on CK

admin
CREATE TABLE IF NOT EXISTS ghhz (`id` Int32, `good_id` String, `is_oversea` Nullable(String), `province` Nullable(String), `allItemCount` Int32, `shopId` Nullable(String), `starts` Nullable(String), `brand_type` Nullable(String), `longitude` Nullable(String), `latitude` Nullable(String), `registration_institution` Nullable(String), `goodRatePercentage` Nullable(String), `images` Nullable(String), `goodUrl` Nullable(String), `crawl_date` Nullable(String), `subCategoryId`   Nullable(String), `shopUrl` Nullable(String), `commentCount`  Int32, `detailCategoryName` Nullable(String), `district` Nullable(String), `taxFreeZone` Nullable(String), `delivery_from` Nullable(String), `name` Nullable(String), `sellCount` Int32, `is_toplife` Nullable(String), `shopType` Nullable(String), `is_market` Nullable(String), `city` Nullable(String), `shopName` Nullable(String), `title` Nullable(String), `categoryName` Nullable(String), `is_pingou` Nullable(String), `subCategoryName` Nullable(String), `CustomAttrList` Nullable(String), `goodCount` Int32, `salesAmount` Float64, `platformName` String, `priceText` Float64, `poorCount` Int32, `brand_state` Nullable(String), `address` Nullable(String), `is_jingxuan` Nullable(String), `originProduction` Nullable(String), `fans` Int32, `rootCategoryId` Nullable(String), `timeStamp` String, `original_cost` Float64, `generalCount` Int32, `brandValueId` Nullable(String), `is_flagship` Nullable(String), `rootCategoryName` Nullable(String), `brandName_cn` Nullable(String), `categoryId` Nullable(String), `brandName` Nullable(String), `is_newProduct` Nullable(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 *

Back to top