File size: 924 Bytes
c27e67a | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | INSERT INTO tmp_events_v2 (
site_id, timestamp, name, user_id,
session_id, hostname, pathname, referrer,
referrer_source, country_code, screen_size,
operating_system, browser, utm_medium,
utm_source, utm_campaign, meta.key,
meta.value, browser_version, operating_system_version,
subdivision1_code, subdivision2_code,
city_geoname_id, utm_content, utm_term,
transferred_from
)
SELECT
site_id,
timestamp,
name,
user_id,
session_id,
hostname,
pathname,
referrer,
referrer_source,
country_code,
screen_size,
operating_system,
browser,
utm_medium,
utm_source,
utm_campaign,
meta.key,
meta.value,
browser_version,
operating_system_version,
subdivision1_code,
subdivision2_code,
city_geoname_id,
utm_content,
utm_term,
transferred_from
FROM
events
INNER JOIN domains_lookup ON domains_lookup.domain = events.domain
WHERE (_partition_id = '<%= @partition %>')
|