File size: 1,581 Bytes
c27e67a | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | ALTER TABLE events_v2
<%= if @cluster? do %>ON CLUSTER '{cluster}'<% end %>
UPDATE
referrer = dictGet('sessions_dict', 'referrer', tuple(site_id, session_id)),
referrer_source = dictGet('sessions_dict', 'referrer_source', tuple(site_id, session_id)),
utm_medium = dictGet('sessions_dict', 'utm_medium', tuple(site_id, session_id)),
utm_source = dictGet('sessions_dict', 'utm_source', tuple(site_id, session_id)),
utm_campaign = dictGet('sessions_dict', 'utm_campaign', tuple(site_id, session_id)),
utm_content = dictGet('sessions_dict', 'utm_content', tuple(site_id, session_id)),
utm_term = dictGet('sessions_dict', 'utm_term', tuple(site_id, session_id)),
country_code = dictGet('sessions_dict', 'country_code', tuple(site_id, session_id)),
subdivision1_code = dictGet('sessions_dict', 'subdivision1_code', tuple(site_id, session_id)),
subdivision2_code = dictGet('sessions_dict', 'subdivision2_code', tuple(site_id, session_id)),
city_geoname_id = dictGet('sessions_dict', 'city_geoname_id', tuple(site_id, session_id)),
screen_size = dictGet('sessions_dict', 'screen_size', tuple(site_id, session_id)),
operating_system = dictGet('sessions_dict', 'operating_system', tuple(site_id, session_id)),
operating_system_version = dictGet('sessions_dict', 'operating_system_version', tuple(site_id, session_id)),
browser = dictGet('sessions_dict', 'browser', tuple(site_id, session_id)),
browser_version = dictGet('sessions_dict', 'browser_version', tuple(site_id, session_id))
IN PARTITION '<%= @partition %>'
WHERE 1=1
|