Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS ff_events (
- Sign Int8,
- Hash String CODEC(ZSTD),
- InsertTime DateTime Codec(T64),
- EventType UInt8,
- TrackingDomain LowCardinality(String),
- EntranceID UInt64,
- VisitorID UInt64,
- VisitorTagIDs Array(LowCardinality(String)),
- HitID UInt64,
- TrafficSourceID UInt64,
- TrackingFields String CODEC(ZSTD),
- MVTCombination String CODEC(ZSTD),
- MVTPairs Array(LowCardinality(String)) CODEC(ZSTD),
- CampaignID UInt64,
- FunnelID UInt64,
- NodeID UInt64,
- NodeType UInt8,
- OfferSourceID UInt64,
- PageID UInt64,
- PageCategoryID UInt64,
- TimeOnPage Nullable(UInt32),
- NodesPath Array(LowCardinality(String)),
- PagesPath Array(LowCardinality(String)),
- ClickID UInt64,
- ConversionID UInt64,
- ConversionTransaction String CODEC(ZSTD),
- ConvertedHitID UInt64,
- LocationContinent LowCardinality(String),
- LocationCountry FixedString(2),
- LocationRegion LowCardinality(String),
- LocationCity LowCardinality(String),
- LocationTimezone LowCardinality(String),
- DeviceType UInt8,
- DeviceBrand LowCardinality(String),
- DeviceModel LowCardinality(String),
- DeviceModelName LowCardinality(String),
- DeviceOS LowCardinality(String),
- DeviceOSVersion LowCardinality(String),
- DeviceBrowser LowCardinality(String),
- DeviceBrowserVersion LowCardinality(String),
- DeviceMainLanguage LowCardinality(String),
- DeviceOtherLanguages Array(LowCardinality(String)),
- DeviceUserAgent String CODEC(ZSTD),
- ConnectionIPv4 Nullable(IPv4),
- ConnectionIPv6 Nullable(IPv6),
- ConnectionISP LowCardinality(String),
- ConnectionMobileCarrier LowCardinality(String),
- ConnectionType UInt8,
- ConnectionReferrer String CODEC(ZSTD),
- ConnectionReferrerDomain LowCardinality(String),
- IsFiltered UInt8,
- IsEntrance UInt8,
- IsEntranceUniq UInt8,
- IsNodeView UInt8,
- IsNodeViewUniq UInt8,
- IsLanderView UInt8,
- IsLanderViewUniq UInt8,
- IsOfferView UInt8,
- IsOfferViewUniq UInt8,
- IsLanderClick UInt8,
- IsLanderClickUniq UInt8,
- IsOfferClick UInt8,
- IsOfferClickUniq UInt8,
- IsConversion UInt8,
- IsPathConversion UInt8,
- IsIndirectConversion UInt8,
- IsClickConversion UInt8,
- Revenue Float64,
- PathRevenue Float64,
- IndirectRevenue Float64,
- ClickRevenue Float64,
- ClickActionNum UInt8,
- Cost Float64,
- EntranceTime DateTime Codec(T64),
- HitTime DateTime Codec(T64),
- ClickTime Nullable(DateTime),
- ConversionTime Nullable(DateTime),
- EntranceDate Date Codec(T64)
- ) ENGINE = CollapsingMergeTree(Sign)
- PARTITION BY (toYYYYMM(EntranceDate))
- ORDER BY (EntranceDate, TrafficSourceID, CampaignID, FunnelID, NodeID, PageID, PagesPath, NodesPath, VisitorID, Hash)
- SELECT
- partition,
- name,
- active,
- rows,
- bytes_on_disk,
- modification_time
- FROM system.parts
- WHERE table = 'ff_events'
- ┌─partition─┬─name────────────────────┬─active─┬───rows─┬─bytes_on_disk─┬───modification_time─┐
- │ 202003 │ 202003_1_19104_1771 │ 1 │ 236544 │ 20392175 │ 2020-03-30 01:58:19 │
- │ 202003 │ 202003_19105_41223_2446 │ 1 │ 245469 │ 21930769 │ 2020-03-30 15:55:14 │
- │ 202003 │ 202003_41224_45757_350 │ 1 │ 139759 │ 12079070 │ 2020-03-30 18:03:35 │
- │ 202003 │ 202003_45758_52792_841 │ 1 │ 137461 │ 11120401 │ 2020-03-30 21:44:25 │
- │ 202003 │ 202003_52793_62584_1155 │ 1 │ 121124 │ 8697405 │ 2020-03-31 02:03:40 │
- │ 202003 │ 202003_62585_66159_1302 │ 1 │ 26588 │ 1677115 │ 2020-03-31 04:46:54 │
- │ 202003 │ 202003_66160_66268_27 │ 0 │ 675 │ 53254 │ 2020-03-31 04:55:34 │
- │ 202003 │ 202003_66160_66272_28 │ 0 │ 708 │ 55218 │ 2020-03-31 04:55:48 │
- │ 202003 │ 202003_66160_66276_29 │ 0 │ 742 │ 57152 │ 2020-03-31 04:55:53 │
- │ 202003 │ 202003_66160_66280_30 │ 0 │ 768 │ 58293 │ 2020-03-31 04:56:00 │
- │ 202003 │ 202003_66160_66284_31 │ 0 │ 797 │ 59932 │ 2020-03-31 04:56:05 │
- │ 202003 │ 202003_66160_66288_32 │ 0 │ 824 │ 61732 │ 2020-03-31 04:56:15 │
- │ 202003 │ 202003_66160_66292_33 │ 0 │ 857 │ 64103 │ 2020-03-31 04:56:32 │
- │ 202003 │ 202003_66160_66296_34 │ 0 │ 878 │ 65339 │ 2020-03-31 04:56:43 │
- │ 202003 │ 202003_66160_66300_35 │ 0 │ 896 │ 66457 │ 2020-03-31 04:56:53 │
- │ 202003 │ 202003_66160_66304_36 │ 0 │ 916 │ 67790 │ 2020-03-31 04:57:13 │
- │ 202003 │ 202003_66160_66308_37 │ 0 │ 936 │ 68750 │ 2020-03-31 04:57:25 │
- │ 202003 │ 202003_66160_66312_38 │ 0 │ 968 │ 71269 │ 2020-03-31 04:58:04 │
- │ 202003 │ 202003_66160_66316_39 │ 0 │ 993 │ 72339 │ 2020-03-31 04:58:16 │
- │ 202003 │ 202003_66160_66320_40 │ 0 │ 1020 │ 73771 │ 2020-03-31 04:58:53 │
- │ 202003 │ 202003_66160_66324_41 │ 0 │ 1047 │ 75274 │ 2020-03-31 04:59:07 │
- │ 202003 │ 202003_66160_66328_42 │ 0 │ 1068 │ 76278 │ 2020-03-31 04:59:23 │
- │ 202003 │ 202003_66160_66332_43 │ 0 │ 1096 │ 77944 │ 2020-03-31 04:59:31 │
- │ 202003 │ 202003_66160_66336_44 │ 0 │ 1114 │ 79151 │ 2020-03-31 04:59:59 │
- │ 202003 │ 202003_66160_66340_45 │ 0 │ 1136 │ 80260 │ 2020-03-31 05:00:29 │
- │ 202003 │ 202003_66160_66344_46 │ 0 │ 1155 │ 81517 │ 2020-03-31 05:00:46 │
- │ 202003 │ 202003_66160_66348_47 │ 0 │ 1179 │ 82405 │ 2020-03-31 05:00:57 │
- │ 202003 │ 202003_66160_66352_48 │ 0 │ 1201 │ 83954 │ 2020-03-31 05:01:23 │
- │ 202003 │ 202003_66160_66356_49 │ 0 │ 1230 │ 86141 │ 2020-03-31 05:01:36 │
- │ 202003 │ 202003_66160_66360_50 │ 0 │ 1258 │ 87621 │ 2020-03-31 05:01:48 │
- │ 202003 │ 202003_66160_66364_51 │ 0 │ 1278 │ 88415 │ 2020-03-31 05:02:00 │
- │ 202003 │ 202003_66160_66368_52 │ 0 │ 1317 │ 90547 │ 2020-03-31 05:02:09 │
- │ 202003 │ 202003_66160_66372_53 │ 0 │ 1335 │ 91271 │ 2020-03-31 05:02:23 │
- │ 202003 │ 202003_66160_66376_54 │ 0 │ 1360 │ 92866 │ 2020-03-31 05:02:45 │
- │ 202003 │ 202003_66160_66380_55 │ 1 │ 1381 │ 94127 │ 2020-03-31 05:03:11 │
- │ 202003 │ 202003_66269_66269_0 │ 0 │ 10 │ 10940 │ 2020-03-31 04:55:37 │
- │ 202003 │ 202003_66270_66270_0 │ 0 │ 9 │ 11465 │ 2020-03-31 04:55:41 │
- │ 202003 │ 202003_66271_66271_0 │ 0 │ 5 │ 10179 │ 2020-03-31 04:55:45 │
- │ 202003 │ 202003_66272_66272_0 │ 0 │ 9 │ 10827 │ 2020-03-31 04:55:47 │
- │ 202003 │ 202003_66273_66273_0 │ 0 │ 5 │ 10283 │ 2020-03-31 04:55:48 │
- │ 202003 │ 202003_66274_66274_0 │ 0 │ 12 │ 11283 │ 2020-03-31 04:55:49 │
- │ 202003 │ 202003_66275_66275_0 │ 0 │ 4 │ 10447 │ 2020-03-31 04:55:51 │
- │ 202003 │ 202003_66276_66276_0 │ 0 │ 13 │ 11492 │ 2020-03-31 04:55:53 │
- │ 202003 │ 202003_66277_66277_0 │ 0 │ 9 │ 10788 │ 2020-03-31 04:55:54 │
- │ 202003 │ 202003_66278_66278_0 │ 0 │ 4 │ 10516 │ 2020-03-31 04:55:56 │
- │ 202003 │ 202003_66279_66279_0 │ 0 │ 5 │ 10294 │ 2020-03-31 04:55:58 │
- │ 202003 │ 202003_66280_66280_0 │ 0 │ 8 │ 10545 │ 2020-03-31 04:56:00 │
- │ 202003 │ 202003_66281_66281_0 │ 0 │ 12 │ 11173 │ 2020-03-31 04:56:01 │
- │ 202003 │ 202003_66282_66282_0 │ 0 │ 5 │ 10212 │ 2020-03-31 04:56:02 │
- │ 202003 │ 202003_66283_66283_0 │ 0 │ 4 │ 10588 │ 2020-03-31 04:56:03 │
- │ 202003 │ 202003_66284_66284_0 │ 0 │ 8 │ 10573 │ 2020-03-31 04:56:05 │
- │ 202003 │ 202003_66285_66285_0 │ 0 │ 4 │ 10193 │ 2020-03-31 04:56:06 │
- │ 202003 │ 202003_66286_66286_0 │ 0 │ 8 │ 10609 │ 2020-03-31 04:56:07 │
- │ 202003 │ 202003_66287_66287_0 │ 0 │ 5 │ 10284 │ 2020-03-31 04:56:09 │
- │ 202003 │ 202003_66288_66288_0 │ 0 │ 10 │ 10789 │ 2020-03-31 04:56:15 │
- │ 202003 │ 202003_66289_66289_0 │ 0 │ 5 │ 10300 │ 2020-03-31 04:56:18 │
- │ 202003 │ 202003_66290_66290_0 │ 0 │ 10 │ 11262 │ 2020-03-31 04:56:25 │
- │ 202003 │ 202003_66291_66291_0 │ 0 │ 10 │ 10811 │ 2020-03-31 04:56:29 │
- │ 202003 │ 202003_66292_66292_0 │ 0 │ 8 │ 11598 │ 2020-03-31 04:56:32 │
- │ 202003 │ 202003_66293_66293_0 │ 0 │ 3 │ 10533 │ 2020-03-31 04:56:37 │
- │ 202003 │ 202003_66294_66294_0 │ 0 │ 9 │ 10791 │ 2020-03-31 04:56:39 │
- │ 202003 │ 202003_66295_66295_0 │ 0 │ 4 │ 10235 │ 2020-03-31 04:56:41 │
- │ 202003 │ 202003_66296_66296_0 │ 0 │ 5 │ 10207 │ 2020-03-31 04:56:43 │
- │ 202003 │ 202003_66297_66297_0 │ 0 │ 4 │ 10726 │ 2020-03-31 04:56:45 │
- │ 202003 │ 202003_66298_66298_0 │ 0 │ 5 │ 10320 │ 2020-03-31 04:56:50 │
- │ 202003 │ 202003_66299_66299_0 │ 0 │ 5 │ 10282 │ 2020-03-31 04:56:52 │
- │ 202003 │ 202003_66300_66300_0 │ 0 │ 5 │ 10653 │ 2020-03-31 04:56:53 │
- │ 202003 │ 202003_66301_66301_0 │ 0 │ 3 │ 9912 │ 2020-03-31 04:57:02 │
- │ 202003 │ 202003_66302_66302_0 │ 0 │ 6 │ 10457 │ 2020-03-31 04:57:03 │
- │ 202003 │ 202003_66303_66303_0 │ 0 │ 4 │ 10193 │ 2020-03-31 04:57:08 │
- │ 202003 │ 202003_66304_66304_0 │ 0 │ 8 │ 11379 │ 2020-03-31 04:57:12 │
- │ 202003 │ 202003_66305_66305_0 │ 0 │ 4 │ 10399 │ 2020-03-31 04:57:13 │
- │ 202003 │ 202003_66306_66306_0 │ 0 │ 4 │ 10194 │ 2020-03-31 04:57:19 │
- │ 202003 │ 202003_66307_66307_0 │ 0 │ 4 │ 10524 │ 2020-03-31 04:57:25 │
- │ 202003 │ 202003_66308_66308_0 │ 0 │ 9 │ 10803 │ 2020-03-31 04:57:25 │
- │ 202003 │ 202003_66309_66309_0 │ 0 │ 5 │ 10280 │ 2020-03-31 04:57:26 │
- │ 202003 │ 202003_66310_66310_0 │ 0 │ 14 │ 11528 │ 2020-03-31 04:57:36 │
- │ 202003 │ 202003_66311_66311_0 │ 0 │ 3 │ 10022 │ 2020-03-31 04:57:41 │
- │ 202003 │ 202003_66312_66312_0 │ 0 │ 10 │ 11066 │ 2020-03-31 04:58:04 │
- │ 202003 │ 202003_66313_66313_0 │ 0 │ 4 │ 10663 │ 2020-03-31 04:58:08 │
- │ 202003 │ 202003_66314_66314_0 │ 0 │ 8 │ 10601 │ 2020-03-31 04:58:10 │
- │ 202003 │ 202003_66315_66315_0 │ 0 │ 8 │ 10617 │ 2020-03-31 04:58:14 │
- │ 202003 │ 202003_66316_66316_0 │ 0 │ 5 │ 10250 │ 2020-03-31 04:58:16 │
- │ 202003 │ 202003_66317_66317_0 │ 0 │ 4 │ 10566 │ 2020-03-31 04:58:19 │
- │ 202003 │ 202003_66318_66318_0 │ 0 │ 5 │ 10186 │ 2020-03-31 04:58:45 │
- │ 202003 │ 202003_66319_66319_0 │ 0 │ 9 │ 11677 │ 2020-03-31 04:58:50 │
- │ 202003 │ 202003_66320_66320_0 │ 0 │ 9 │ 11024 │ 2020-03-31 04:58:53 │
- │ 202003 │ 202003_66321_66321_0 │ 0 │ 4 │ 10885 │ 2020-03-31 04:58:56 │
- │ 202003 │ 202003_66322_66322_0 │ 0 │ 9 │ 10825 │ 2020-03-31 04:59:00 │
- │ 202003 │ 202003_66323_66323_0 │ 0 │ 5 │ 10244 │ 2020-03-31 04:59:01 │
- │ 202003 │ 202003_66324_66324_0 │ 0 │ 9 │ 11603 │ 2020-03-31 04:59:07 │
- │ 202003 │ 202003_66325_66325_0 │ 0 │ 5 │ 10220 │ 2020-03-31 04:59:14 │
- │ 202003 │ 202003_66326_66326_0 │ 0 │ 9 │ 10812 │ 2020-03-31 04:59:15 │
- │ 202003 │ 202003_66327_66327_0 │ 0 │ 4 │ 10943 │ 2020-03-31 04:59:16 │
- │ 202003 │ 202003_66328_66328_0 │ 0 │ 3 │ 10400 │ 2020-03-31 04:59:23 │
- │ 202003 │ 202003_66329_66329_0 │ 0 │ 13 │ 11274 │ 2020-03-31 04:59:26 │
- │ 202003 │ 202003_66330_66330_0 │ 0 │ 6 │ 10475 │ 2020-03-31 04:59:28 │
- │ 202003 │ 202003_66331_66331_0 │ 0 │ 5 │ 10172 │ 2020-03-31 04:59:29 │
- │ 202003 │ 202003_66332_66332_0 │ 0 │ 4 │ 10543 │ 2020-03-31 04:59:31 │
- │ 202003 │ 202003_66333_66333_0 │ 0 │ 3 │ 10469 │ 2020-03-31 04:59:34 │
- │ 202003 │ 202003_66334_66334_0 │ 0 │ 5 │ 10223 │ 2020-03-31 04:59:34 │
- │ 202003 │ 202003_66335_66335_0 │ 0 │ 4 │ 10486 │ 2020-03-31 04:59:42 │
- │ 202003 │ 202003_66336_66336_0 │ 0 │ 6 │ 10404 │ 2020-03-31 04:59:59 │
- │ 202003 │ 202003_66337_66337_0 │ 0 │ 7 │ 10674 │ 2020-03-31 05:00:18 │
- │ 202003 │ 202003_66338_66338_0 │ 0 │ 5 │ 10161 │ 2020-03-31 05:00:20 │
- │ 202003 │ 202003_66339_66339_0 │ 0 │ 5 │ 10178 │ 2020-03-31 05:00:26 │
- │ 202003 │ 202003_66340_66340_0 │ 0 │ 5 │ 10205 │ 2020-03-31 05:00:29 │
- │ 202003 │ 202003_66341_66341_0 │ 0 │ 5 │ 10171 │ 2020-03-31 05:00:34 │
- │ 202003 │ 202003_66342_66342_0 │ 0 │ 5 │ 10221 │ 2020-03-31 05:00:38 │
- │ 202003 │ 202003_66343_66343_0 │ 0 │ 4 │ 10502 │ 2020-03-31 05:00:40 │
- │ 202003 │ 202003_66344_66344_0 │ 0 │ 5 │ 10188 │ 2020-03-31 05:00:46 │
- │ 202003 │ 202003_66345_66345_0 │ 0 │ 5 │ 10142 │ 2020-03-31 05:00:49 │
- │ 202003 │ 202003_66346_66346_0 │ 0 │ 9 │ 10784 │ 2020-03-31 05:00:50 │
- │ 202003 │ 202003_66347_66347_0 │ 0 │ 5 │ 10238 │ 2020-03-31 05:00:52 │
- │ 202003 │ 202003_66348_66348_0 │ 0 │ 5 │ 10184 │ 2020-03-31 05:00:57 │
- │ 202003 │ 202003_66349_66349_0 │ 0 │ 10 │ 11090 │ 2020-03-31 05:00:59 │
- │ 202003 │ 202003_66350_66350_0 │ 0 │ 4 │ 10743 │ 2020-03-31 05:01:02 │
- │ 202003 │ 202003_66351_66351_0 │ 0 │ 4 │ 10660 │ 2020-03-31 05:01:06 │
- │ 202003 │ 202003_66352_66352_0 │ 0 │ 4 │ 10806 │ 2020-03-31 05:01:23 │
- │ 202003 │ 202003_66353_66353_0 │ 0 │ 11 │ 11918 │ 2020-03-31 05:01:25 │
- │ 202003 │ 202003_66354_66354_0 │ 0 │ 5 │ 10196 │ 2020-03-31 05:01:26 │
- │ 202003 │ 202003_66355_66355_0 │ 0 │ 5 │ 10312 │ 2020-03-31 05:01:29 │
- │ 202003 │ 202003_66356_66356_0 │ 0 │ 11 │ 10929 │ 2020-03-31 05:01:36 │
- │ 202003 │ 202003_66357_66357_0 │ 0 │ 5 │ 10157 │ 2020-03-31 05:01:41 │
- │ 202003 │ 202003_66358_66358_0 │ 0 │ 5 │ 10178 │ 2020-03-31 05:01:44 │
- │ 202003 │ 202003_66359_66359_0 │ 0 │ 9 │ 11027 │ 2020-03-31 05:01:47 │
- │ 202003 │ 202003_66360_66360_0 │ 0 │ 9 │ 10821 │ 2020-03-31 05:01:48 │
- │ 202003 │ 202003_66361_66361_0 │ 0 │ 4 │ 10495 │ 2020-03-31 05:01:49 │
- │ 202003 │ 202003_66362_66362_0 │ 0 │ 5 │ 10268 │ 2020-03-31 05:01:50 │
- │ 202003 │ 202003_66363_66363_0 │ 0 │ 8 │ 10600 │ 2020-03-31 05:01:53 │
- │ 202003 │ 202003_66364_66364_0 │ 0 │ 3 │ 10417 │ 2020-03-31 05:02:00 │
- │ 202003 │ 202003_66365_66365_0 │ 0 │ 12 │ 12054 │ 2020-03-31 05:02:04 │
- │ 202003 │ 202003_66366_66366_0 │ 0 │ 18 │ 12977 │ 2020-03-31 05:02:06 │
- │ 202003 │ 202003_66367_66367_0 │ 0 │ 8 │ 11248 │ 2020-03-31 05:02:08 │
- │ 202003 │ 202003_66368_66368_0 │ 0 │ 3 │ 10806 │ 2020-03-31 05:02:09 │
- │ 202003 │ 202003_66369_66369_0 │ 0 │ 3 │ 9983 │ 2020-03-31 05:02:15 │
- │ 202003 │ 202003_66370_66370_0 │ 0 │ 6 │ 10527 │ 2020-03-31 05:02:16 │
- │ 202003 │ 202003_66371_66371_0 │ 0 │ 5 │ 10197 │ 2020-03-31 05:02:21 │
- │ 202003 │ 202003_66372_66372_0 │ 0 │ 5 │ 10348 │ 2020-03-31 05:02:23 │
- │ 202003 │ 202003_66373_66373_0 │ 0 │ 9 │ 11119 │ 2020-03-31 05:02:26 │
- │ 202003 │ 202003_66374_66374_0 │ 0 │ 5 │ 10186 │ 2020-03-31 05:02:42 │
- │ 202003 │ 202003_66375_66375_0 │ 0 │ 3 │ 10482 │ 2020-03-31 05:02:43 │
- │ 202003 │ 202003_66376_66376_0 │ 0 │ 8 │ 10640 │ 2020-03-31 05:02:45 │
- │ 202003 │ 202003_66377_66377_0 │ 0 │ 4 │ 10616 │ 2020-03-31 05:02:46 │
- │ 202003 │ 202003_66378_66378_0 │ 0 │ 4 │ 10741 │ 2020-03-31 05:02:50 │
- │ 202003 │ 202003_66379_66379_0 │ 0 │ 4 │ 10841 │ 2020-03-31 05:02:52 │
- │ 202003 │ 202003_66380_66380_0 │ 0 │ 9 │ 10891 │ 2020-03-31 05:03:11 │
- │ 202003 │ 202003_66381_66381_0 │ 1 │ 5 │ 10166 │ 2020-03-31 05:03:22 │
- │ 202003 │ 202003_66382_66382_0 │ 1 │ 5 │ 10289 │ 2020-03-31 05:03:30 │
- └───────────┴─────────────────────────┴────────┴────────┴───────────────┴─────────────────────┘
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement