CREATE TABLE lz.braingame_android_distributed_bigbase12_ets_events (`created_at_dt` Date, `file_dt` Date, `file_hr` UInt8, `created_at` UInt32, `installed_at` UInt32, `adid` FixedString(16), `idfa` FixedString(16), `idfv` FixedString(16), `gps_adid` FixedString(16), `city` String, `country_subdivision` String, `postal_code` String, `session_count` String, `install_finish_time` String, `install_begin_time` String, `app_id` String, `app_name` String, `app_version` String, `app_version_raw` String, `network_name` String, `campaign_name` String, `adgroup_name` String, `creative_name` String, `label` String, `is_organic` String, `gclid` String, `click_referer` String, `android_id` String, `referrer` String, `search_term` String, `country` String, `device_name` String, `device_type` String, `os_name` String, `api_level` String, `sdk_version` String, `os_version` String, `revenue_usd` String, `match_type` String, `activity_kind` String, `event_name` String, `tracker` String, `fb_campaign_group_name` String, `fb_campaign_name` String, `fb_adgroup_name` String, `tweet_id` String, `twitter_line_item_id` String, `connection_type` String, `isp` String, `conversion_duration` String, `last_time_spent` String, `time_spent` String, `lifetime_session_count` String, `source` String, `balance_ver` String, `game_count` String, `time_s` String, `score` String, `block_count` String, `lines` String, `squares` String, `best_score` String, `miss_block0` String, `miss_block1` String, `miss_block2` String, `stage` String, `hints` String, `block_value` String, `remove_ad` String, `count` String, `action` String, `skin_id` String, `prv_skin_id` String, `date` String, `time_05s` String, `day` String, `text` String, `placement` String, `place` String, `networkName` String, `creativeId` String, `orientation` String, `mode` String, `time_1s` String, `line_item_1` String, `line_item_2` String, `type` String, `viewCount` String, `id` String, `reason` String, `connection` String, `screen` String, `app` String, `time_01s` String, `statusCode` String, `errorCode` String, `button` String, `eu` String, `issue` String, `per_user` String, `per_session` String, `interval_renamed` String, `ignore_in_a_row` String, `seq_num` String, `mopub_ilrd_adgroup_id` String, `mopub_ilrd_adgroup_name` String, `mopub_ilrd_adgroup_priority` String, `mopub_ilrd_adgroup_type` String, `mopub_ilrd_adunit_format` String, `mopub_ilrd_adunit_id` String, `mopub_ilrd_adunit_name` String, `mopub_ilrd_country` String, `mopub_ilrd_currency` String, `mopub_ilrd_id` String, `mopub_ilrd_network_name` String, `mopub_ilrd_network_placement_id` String, `mopub_ilrd_precision` String, `mopub_ilrd_publisher_revenue` String, `rewarded` String, `session` String, `applies` String, `lat` String, `personalized_ads` String, `consent_ads_state` String, `consent_easy_state` String, `option_state` String, `pages` String, `region_detection` String, `link` String, `banner_request` String, `banner_loaded` String, `banner_failed` String, `inter_request` String, `inter_loaded` String, `inter_failed` String, `rewarded_request` String, `rewarded_loaded` String, `rewarded_failed` String, `name` String, `level_progress` String, `state` String, `level_id` String, `from` String, `hints_unlock` String, `setting` String, `change_count` String, `tasks` String, `level_number` String, `content_version` String, `download_error` String, `middle` String, `value` String, `balance_version` String, `skip` String, `clickTrackingUrl` String, `test` String, `group` String, `fromScrn` String, `fromCtrl` String, `slideOn` String, `slideTo` String, `monthDif` String, `by` String, `dayDif` String, `month` String, `progress` String, `available` String, `userLvl` String, `cnt` String, `year` String, `game_mode` String, `main` String, `daily` String, `consent_ccpa_state` String, `created_at_micro` UInt64, `source_file_name_for_debug` String, `timezone` String, `impression_id` String, `waterfall` String) ENGINE = Distributed('bigbase12', 'lz', 'braingame_android_shard_bigbase12_ets_events', sipHash64(adid))

CREATE TABLE lz.braingame_android_shard_bigbase12_ets_events (`created_at_dt` Date, `file_dt` Date, `file_hr` UInt8, `created_at` UInt32, `installed_at` UInt32, `adid` FixedString(16), `idfa` FixedString(16), `idfv` FixedString(16), `gps_adid` FixedString(16), `city` String, `country_subdivision` String, `postal_code` String, `session_count` String, `install_finish_time` String, `install_begin_time` String, `app_id` String, `app_name` String, `app_version` String, `app_version_raw` String, `network_name` String, `campaign_name` String, `adgroup_name` String, `creative_name` String, `label` String, `is_organic` String, `gclid` String, `click_referer` String, `android_id` String, `referrer` String, `search_term` String, `country` String, `device_name` String, `device_type` String, `os_name` String, `api_level` String, `sdk_version` String, `os_version` String, `revenue_usd` String, `match_type` String, `activity_kind` String, `event_name` String, `tracker` String, `fb_campaign_group_name` String, `fb_campaign_name` String, `fb_adgroup_name` String, `tweet_id` String, `twitter_line_item_id` String, `connection_type` String, `isp` String, `conversion_duration` String, `last_time_spent` String, `time_spent` String, `lifetime_session_count` String, `source` String, `balance_ver` String, `game_count` String, `time_s` String, `score` String, `block_count` String, `lines` String, `squares` String, `best_score` String, `miss_block0` String, `miss_block1` String, `miss_block2` String, `stage` String, `hints` String, `block_value` String, `remove_ad` String, `count` String, `action` String, `skin_id` String, `prv_skin_id` String, `date` String, `time_05s` String, `day` String, `text` String, `placement` String, `place` String, `networkName` String, `creativeId` String, `orientation` String, `mode` String, `time_1s` String, `line_item_1` String, `line_item_2` String, `type` String, `viewCount` String, `id` String, `reason` String, `connection` String, `screen` String, `app` String, `time_01s` String, `statusCode` String, `errorCode` String, `button` String, `eu` String, `issue` String, `per_user` String, `per_session` String, `interval_renamed` String, `ignore_in_a_row` String, `seq_num` String, `mopub_ilrd_adgroup_id` String, `mopub_ilrd_adgroup_name` String, `mopub_ilrd_adgroup_priority` String, `mopub_ilrd_adgroup_type` String, `mopub_ilrd_adunit_format` String, `mopub_ilrd_adunit_id` String, `mopub_ilrd_adunit_name` String, `mopub_ilrd_country` String, `mopub_ilrd_currency` String, `mopub_ilrd_id` String, `mopub_ilrd_network_name` String, `mopub_ilrd_network_placement_id` String, `mopub_ilrd_precision` String, `mopub_ilrd_publisher_revenue` String, `rewarded` String, `session` String, `applies` String, `lat` String, `personalized_ads` String, `consent_ads_state` String, `consent_easy_state` String, `option_state` String, `pages` String, `region_detection` String, `link` String, `banner_request` String, `banner_loaded` String, `banner_failed` String, `inter_request` String, `inter_loaded` String, `inter_failed` String, `rewarded_request` String, `rewarded_loaded` String, `rewarded_failed` String, `idfa__hashed` UUID ALIAS CAST(coalesce(UUIDNumToString(MD5(hex(MD5(hex(MD5(nullif(UUIDNumToString(idfa), '00000000-0000-0000-0000-000000000000'))))))), '00000000-0000-0000-0000-000000000000'), 'UUID'), `idfv__hashed` UUID ALIAS CAST(coalesce(UUIDNumToString(MD5(hex(MD5(hex(MD5(nullif(UUIDNumToString(idfv), '00000000-0000-0000-0000-000000000000'))))))), '00000000-0000-0000-0000-000000000000'), 'UUID'), `gps_adid__hashed` UUID ALIAS CAST(coalesce(UUIDNumToString(MD5(hex(MD5(hex(MD5(nullif(UUIDNumToString(gps_adid), '00000000-0000-0000-0000-000000000000'))))))), '00000000-0000-0000-0000-000000000000'), 'UUID'), `android_id__hashed` UUID ALIAS CAST(coalesce(UUIDNumToString(MD5(hex(MD5(hex(MD5(nullif(lower(android_id), ''))))))), '00000000-0000-0000-0000-000000000000'), 'UUID'), `name` String, `level_progress` String, `state` String, `level_id` String, `from` String, `hints_unlock` String, `setting` String, `change_count` String,

 `tasks` String, `level_number` String, `content_version` String, `download_error` String, `middle` String, `value` String, `balance_version` String, `skip` String, `clickTrackingUrl` String, `test` String, `group` String, `fromScrn` String, `fromCtrl` String, `slideOn` String, `slideTo` String, `monthDif` String, `by` String, `dayDif` String, `month` String, `progress` String, `available` String, `userLvl` String, `cnt` String, `year` String, `game_mode` String, `main` String, `daily` String, `consent_ccpa_state` String, `created_at_micro` UInt64, `source_file_name_for_debug` String, `timezone` String, `impression_id` String, `waterfall` String) ENGINE = MergeTree PARTITION BY (created_at_dt, file_dt) ORDER BY (event_name, adid, created_at) SETTINGS index_granularity = 8192