Hello, fishman

Category: Posts

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

mysql update for food

SELECT good_id, delivery_fee, province, emotionalKeywords, shopId, longitude, registration_institution, goodRatePercentage, shopSellCount, min_delivery_price, phone, district, opening_hours, sellCount, goodDescription, delivery_mode, city, latitude, praiseNum, shopName, city_grade, title, categoryName, shopCommentCount, salesAmount, street, administrative_region, platformName, priceText, licencePics, address, shopImages, platformId, rootCategoryId, timeStamp, original_cost, shopDescription, rootCategoryName, categoryId from mt limit 1000 UPDATE elm set registration_institution=-1 where registration_institution is NULL UPDATE mt set […]

erji Honor

GET 2019_tmall/_search { “size”: 0, “query”: { “bool”: { “must”: [ { “bool”: { “should”: [ { “match_phrase”: { “categoryId”: “50005050” } },{ “match_phrase”: { “categoryId”: “1205” } } ] } },{ “bool”: { “should”: [ { “match_phrase”: { “title”: “tws” } },{ “match_phrase”: { “title”: “真无线” } },{ “match_phrase”: { “title”: “airpods” } } […]

Back to top