Hello, fishman

Day: January 7, 2020

clickhouse create distributed table

CREATE TABLE canyin_local ON CLUSTER default ( `good_id` String, `delivery_fee` String, `province` String, `emotionalKeywords` String, `shopId` String, `longitude` String, `registration_institution` String, `goodRatePercentage` String, `shopSellCount` String, `min_delivery_price` String, `phone` String, `district` String, `opening_hours` String, `sellCount` String, `goodDescription` String, `delivery_mode` String, `city` String, `latitude` String, `praiseNum` String, `shopName` String, `city_grade` String, `title` String, `categoryName` String, `shopCommentCount` String, […]

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, […]

Back to top