· 8 years ago · May 08, 2018, 06:46 AM
1CREATE TABLE IF NOT EXISTS "cabinet"."aggregate_event_fact" (
2 "ad_campaign_id" LONG,
3 "ad_campaign_type" STRING,
4 "ad_city_id" INTEGER,
5 "ad_clicks" DOUBLE,
6 "ad_conversions" DOUBLE,
7 "ad_cost" DOUBLE,
8 "ad_country_id" INTEGER,
9 "ad_device_type" STRING,
10 "ad_group_id" LONG,
11 "ad_id" LONG,
12 "ad_impressions" DOUBLE,
13 "ad_phrase" STRING,
14 "ad_phrase_id" LONG,
15 "ad_position" INTEGER,
16 "ad_provider_id" STRING,
17 "ad_provider_region_id" INTEGER,
18 "ad_region_id" INTEGER,
19 "ad_source" STRING,
20 "ad_source_type" STRING,
21 "advertiser_approved" INTEGER,
22 "advertiser_id" INTEGER,
23 "advertiser_pending" INTEGER,
24 "advertiser_rejected" INTEGER,
25 "aff_sub1" STRING,
26 "aff_sub2" STRING,
27 "aff_sub3" STRING,
28 "aff_sub4" STRING,
29 "aff_sub5" STRING,
30 "affiliate_approved" INTEGER,
31 "affiliate_employee_id" INTEGER,
32 "affiliate_id" INTEGER,
33 "affiliate_pending" INTEGER,
34 "affiliate_rejected" INTEGER,
35 "browser_app" STRING,
36 "browser_device" STRING,
37 "browser_format" STRING,
38 "city_id" INTEGER,
39 "click_id" STRING,
40 "clicks_total" INTEGER,
41 "clicks_unique" INTEGER,
42 "conversion_approved" INTEGER,
43 "conversion_id" LONG,
44 "conversion_pending" INTEGER,
45 "conversion_rejected" INTEGER,
46 "conversion_source" STRING,
47 "conversion_total" INTEGER,
48 "country_id" INTEGER,
49 "current_affiliate_employee_id" INTEGER,
50 "default_payout" DOUBLE,
51 "default_revenue" DOUBLE,
52 "domain" STRING,
53 "event_http_host" STRING,
54 "file_id" INTEGER,
55 "file_type" STRING,
56 "goal_id" INTEGER,
57 "has_personal_payout" INTEGER,
58 "hour" TIMESTAMP,
59 "http_host" STRING,
60 "id" LONG,
61 "ip_addr" STRING,
62 "is_test" INTEGER,
63 "is_unique_conversion" INTEGER,
64 "keyword" STRING,
65 "lead_id" LONG,
66 "lead_offer_id" INTEGER,
67 "lead_total" INTEGER,
68 "offer_employee_id" INTEGER,
69 "offer_id" INTEGER,
70 "offer_url_id" INTEGER,
71 "os" STRING,
72 "payout" DOUBLE,
73 "platform_id" INTEGER,
74 "preoffer_url_id" INTEGER,
75 "protocol_type" STRING,
76 "referrer" STRING,
77 "region_id" INTEGER,
78 "revenue" DOUBLE,
79 "rotator_id" INTEGER,
80 "row_type" STRING,
81 "search_engine" STRING,
82 "source" STRING,
83 "status" STRING,
84 "status_advertiser" STRING,
85 "status_affiliate" STRING,
86 "sys_sub1" STRING,
87 "sys_sub2" STRING,
88 "sys_sub3" STRING,
89 "sys_sub4" STRING,
90 "sys_sub5" STRING,
91 "user_agent" STRING,
92 "utm_campaign" STRING,
93 "utm_content" STRING,
94 "utm_medium" STRING,
95 "utm_referrer" STRING,
96 "utm_source" STRING,
97 "utm_term" STRING,
98 "valuta_id" INTEGER,
99 "valuta_payout" DOUBLE,
100 "valuta_rate_id" INTEGER,
101 "valuta_revenue" DOUBLE,
102 "views_total" INTEGER,
103 "views_unique" INTEGER,
104 PRIMARY KEY ("id")
105)
106CLUSTERED BY ("id") INTO 4 SHARDS
107WITH (
108 "allocation.max_retries" = 5,
109 "blocks.metadata" = false,
110 "blocks.read" = false,
111 "blocks.read_only" = false,
112 "blocks.write" = false,
113 column_policy = 'strict',
114 "mapping.total_fields.limit" = 1000,
115 number_of_replicas = '0',
116 "recovery.initial_shards" = 'quorum',
117 refresh_interval = 1000,
118 "routing.allocation.enable" = 'all',
119 "routing.allocation.total_shards_per_node" = -1,
120 "translog.durability" = 'REQUEST',
121 "translog.flush_threshold_size" = 536870912,
122 "translog.sync_interval" = 5000,
123 "unassigned.node_left.delayed_timeout" = 15000,
124 "warmer.enabled" = true,
125 "write.wait_for_active_shards" = 'all'
126)