CREATE TABLE `test1`( `col1` bigint, `col2` bigint, `col3` string, `col4` string, `col5` bigint, `col6` bigint, `col7` bigint, `col8` bigint, `col9` string, `col10` bigint, `col11` string, `col12` string, `col13` string, `col14` string, `col15` string); CREATE TABLE `test2`( `col16` string, `col17` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col22` string, `col23` string, `col24` bigint, `col25` bigint, `col26` timestamp, `col27` double, `col28` double, `col29` string, `col30` bigint, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col33` double, `col34` double, `col35` timestamp, `col36` string, `col37` string, `col38` string, `col39` timestamp, `col40` timestamp, `col41` string, `col42` string, `col43` boolean, `col44` string, `col45` string, `col46` boolean, `col47` string, `col48` boolean, `col49` string, `col50` boolean, `col51` string, `col52` string, `col53` string, `col54` boolean, `col55` boolean, `col56` boolean, `col57` boolean, `col58` boolean, `col59` boolean, `col60` boolean, `col61` boolean, `col62` double, `col63` timestamp, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col68` bigint, `col69` string, `col70` string, `col71` bigint, `col5` bigint, `col6` bigint, `col72` double, `col11` string, `col73` string, `col74` string, `col75` double, `col76` double, `col77` string, `col78` bigint, `col79` string, `col80` string, `col81` string, `col82` bigint, `col83` bigint, `col117` bigint, `col13` string, `col84` string, `col85` string, `col86` timestamp, `col87` bigint, `col88` string, `col1` bigint, `col89` string, `col4` string, `col90` string, `col14` string, `col3` string, `col91` timestamp, `col92` bigint, `col93` string, `col2` bigint, `col94` string, `col95` string, `col96` bigint, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test3`( `col16` string, `col106` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col101` string, `col102` string, `col103` bigint, `col104` string, `col29` string, `col105` string, `col30_seconds` bigint, `col31` string, `col32` bigint, `col107` bigint, `col7` bigint, `col8` bigint, `col108` double, `col12` string, `col109` bigint, `col41` string, `col47` string, `col48` boolean, `col52` string, `col110` string, `col111` boolean, `col112` string, `col53` string, `col113` boolean, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col114` bigint, `col115` bigint, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col116` boolean, `col73` string, `col74` string, `col82` bigint, `col83` bigint, `col117` bigint, `col13` string, `col84` string, `col85` string, `col118` double, `col119` double, `col120` bigint, `col87` bigint, `col121` boolean, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test4`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col122` double, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test5`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col101` string, `col102` string, `col123` double, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col113` boolean, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test6`( `col16` string, `col124` bigint, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col101` string, `col102` string, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col125` bigint, `col126` boolean, `col41` string, `col47` string, `col48` boolean, `col52` string, `col127` string, `col128` boolean, `col129` string, `col53` string, `col113` boolean, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col130` string, `col131` timestamp, `col82` bigint, `col83` bigint, `col117` bigint, `col13` string, `col84` string, `col85` string, `col132` double, `col133` double, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test7`( `col16` string, `col134` string, `col135` string, `col136` boolean, `col137` boolean, `col138` string, `col18` string, `col139` string, `col19` boolean, `col20` boolean, `col21` boolean, `col101` string, `col140` bigint, `col141` string, `col142` string, `col143` string, `col144` string, `col145` boolean, `col146` double, `col147` bigint, `col148` string, `col29` string, `col149` string, `col150` string, `col30` bigint, `col151` bigint, `col31` string, `col152` string, `col32` bigint, `col153` double, `col154` double, `col7` bigint, `col155` string, `col8` bigint, `col156` string, `col12` string, `col157` boolean, `col158` boolean, `col159` boolean, `col160` boolean, `col161` boolean, `col162` boolean, `col163` boolean, `col164` string, `col165` string, `col41` string, `col166` string, `col167` string, `col168` boolean, `col169` string, `col47` string, `col48` boolean, `col52` string, `col110` string, `col111` boolean, `col112` string, `col53` string, `col113` boolean, `col57` boolean, `col62` double, `col64` double, `col170` string, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col171` bigint, `col11` string, `col172` boolean, `col73` string, `col74` string, `col173` string, `col174` boolean, `col175` string, `col176` string, `col177` string, `col178` bigint, `col179` bigint, `col180` bigint, `reason` string, `col13` string, `col181` string, `col84` string, `col85` string, `col118` double, `col119` double, `col87` bigint, `col88` string, `col182` bigint, `col1` bigint, `col184` string, `col4` string, `col183` string, `col14` string, `col3` string, `col2` bigint, `col185` bigint, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test8`( `col16` string, `col186` timestamp, `col17` string, `col138` string, `col18` string, `col139` string, `col19` boolean, `col20` boolean, `col21` boolean, `col187` timestamp, `col101` string, `col188` boolean, `col142` string, `col189` string, `col143` string, `col144` string, `col145` boolean, `col146` double, `col27` double, `col28` double, `col190` string, `col147` bigint, `col148` string, `col29` string, `col149` string, `col150` string, `col31` string, `col152` string, `col32` bigint, `col7` bigint, `col155` string, `col8` bigint, `col156` string, `col12` string, `col191` string, `col192` boolean, `col193` boolean, `col194` boolean, `col163` boolean, `col164` string, `col165` string, `col195` boolean, `col41` string, `col166` string, `col42` string, `col43` boolean, `col44` string, `col47` string, `col48` boolean, `col52` string, `col196` string, `col197` boolean, `col198` string, `col53` string, `col113` boolean, `col54` boolean, `col57` boolean, `col199` boolean, `col62` double, `col200` bigint, `col201` bigint, `col64` double, `col202` string, `col170` string, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col203` bigint, `col73` string, `col74` string, `col204` bigint, `col174` boolean, `col175` string, `col205` timestamp, `col80` string, `col81` string, `col206` string, `col176` string, `col177` string, `col178` bigint, `col179` bigint, `col180` bigint, `col207` bigint, `col208` bigint, `col209` double, `col210` bigint, `col13` string, `col181` string, `col84` string, `col85` string, `col87` bigint, `col88` string, `col211` bigint, `col212` bigint, `col182` bigint, `col1` bigint, `col213` string, `col214` double, `col215` double, `col216` string, `col217` string, `col218` string, `col4` string, `col183` string, `col90` string, `col14` string, `col3` string, `col2` bigint, `col94` string, `col95` string, `col219` bigint, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test9`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col41` string, `col47` string, `col48` boolean, `col220` string, `col221` boolean, `col222` string, `col52` string, `col53` string, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col223` double, `col224` double, `col225` timestamp, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col73` string, `col74` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test10`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col57` boolean, `col226` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col227` boolean, `col73` string, `col74` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col2` bigint, `col94` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test11`( `col16` string, `col138` string, `col18` string, `col139` string, `col19` boolean, `col20` boolean, `col21` boolean, `col101` string, `col22` string, `col142` string, `col143` string, `col144` string, `col145` boolean, `col146` double, `col228` double, `col148` string, `col29` string, `col149` string, `col150` string, `col229` string, `col31` string, `col152` string, `col32` bigint, `col230` double, `col7` bigint, `col155` string, `col8` bigint, `col156` string, `col231` bigint, `col12` string, `col232` string, `col233` string, `col36` string, `col163` boolean, `col234` string, `col235` string, `col164` string, `col165` string, `col41` string, `col166` string, `col236` boolean, `col237` boolean, `col238` boolean, `col239` boolean, `col240` boolean, `col241` boolean, `col242` boolean, `col243` boolean, `col47` string, `col48` boolean, `col52` string, `col53` string, `col113` boolean, `col54` boolean, `col57` boolean, `col62` double, `col64` double, `col244` double, `col170` string, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col245` double, `col5` bigint, `col6` bigint, `col246` bigint, `col11` string, `col73` string, `col74` string, `col174` boolean, `col175` string, `col176` string, `col177` string, `col247` bigint, `col178` bigint, `col179` bigint, `col180` bigint, `col208` double, `col209` double, `col210` bigint, `col13` string, `col181` string, `col84` string, `col85` string, `col87` bigint, `col88` string, `col212` bigint, `col182` bigint, `col1` bigint, `col89` string, `col4` string, `col183` string, `col14` string, `col3` string, `col94` string, `col95` string, `col248` double, `col249` double, `col97` bigint, `col98` bigint, `col99` bigint, `col9` string, `col10` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test12`( `col16` string, `col250` bigint, `col251` string, `col252` string, `col253` string, `col27` double, `col28` double, `col38` string, `col41` string, `col42` string, `col43` boolean, `col44` string, `col49` string, `col50` boolean, `col51` string, `col67` timestamp, `col71` bigint, `col11` string, `col73` string, `col74` string, `col254` string, `col75` double, `col76` double, `col78` bigint, `col255` bigint, `col256` string, `col84` string, `col85` string, `col87` bigint, `col4` string, `col91` timestamp, `col2` bigint, `col95` string, `col257` string, `col258` bigint, `col259` string, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test13`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col260` string, `col261` string, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col262` bigint, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col73` string, `col74` string, `col263` bigint, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test14`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col253` string, `col264` boolean, `col27` double, `col28` double, `col265` string, `col266` string, `col267` string, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col12` string, `col41` string, `col42` string, `col43` boolean, `col44` string, `col47` string, `col48` boolean, `col52` string, `col196` string, `col197` boolean, `col198` string, `col53` string, `col268` boolean, `col57` boolean, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col213` string, `col269` boolean, `col214` double, `col215` double, `col216` string, `col217` string, `col218` string, `col4` string, `col14` string, `col3` string, `col94` string, `col270` string, `col95` string, `col97` bigint, `col98` bigint, `col99` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test15`( `col16` string, `col67` timestamp, `reason` string, `col84` string, `col85` string, `col1` bigint, `col95` string, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test16`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col271` bigint, `col272` bigint, `col273` bigint, `col274` bigint, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col275` string, `col12` string, `col276` bigint, `col277` string, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col57` boolean, `col278` boolean, `col279` string, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col280` bigint, `col281` bigint, `col282` bigint, `col283` string, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col284` string, `col97` bigint, `col98` bigint, `col99` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE TABLE `test17`( `col16` string, `col18` string, `col19` boolean, `col20` boolean, `col21` boolean, `col271` bigint, `col272` bigint, `col273` bigint, `col274` bigint, `col29` string, `col31` string, `col32` bigint, `col7` bigint, `col8` bigint, `col275` string, `col12` string, `col276` bigint, `col277` string, `col41` string, `col47` string, `col48` boolean, `col52` string, `col53` string, `col57` boolean, `col278` boolean, `col279` string, `col62` double, `col64` double, `col65` string, `col66` string, `col67` timestamp, `col69` string, `col71` bigint, `col5` bigint, `col6` bigint, `col11` string, `col73` string, `col74` string, `col280` bigint, `col281` bigint, `col282` bigint, `col283` string, `col285` boolean, `col13` string, `col84` string, `col85` string, `col87` bigint, `col1` bigint, `col4` string, `col14` string, `col3` string, `col94` string, `col95` string, `col284` string, `col97` bigint, `col98` bigint, `col99` bigint, `col100` timestamp) PARTITIONED BY ( `ds` string); CREATE VIEW `test_view` AS SELECT CAST ('test' AS STRING) AS `vcol1`, `test2`.`col16` AS `col16`, `test2`.`col100` AS `col100`, `test2`.`col67` AS `col67`, `test2`.`col84` AS `col84`, `test2`.`col85` AS `col85`, `test2`.`col95` AS `col95`, `test2`.`col41` AS `col41`, `test2`.`col53` AS `col53`, `test2`.`col1` AS `col1`, `test2`.`col13` AS `col13`, `test2`.`col71` AS `col71`, `test2`.`col74` AS `col74`, `test2`.`col4` AS `col4`, `test2`.`col57` AS `col57`, `test2`.`col69` AS `col69`, `test2`.`col5` AS `col5`, `test2`.`col6` AS `col6`, `test2`.`col73` AS `col73`, `test2`.`col87` AS `col87`, `test2`.`col11` AS `col11`, `test2`.`col47` AS `col47`, `test2`.`col48` AS `col48`, `test2`.`col52` AS `col52`, `test2`.`col62` AS `col62`, `test2`.`col64` AS `col64`, CAST (`test2`.`col82` AS INT) AS `col82`, CAST (`test2`.`col117` AS INT) AS `col117`, `test2`.`col54` AS `col54`, `test2`.`col56` AS `col56`, `test2`.`col59` AS `col59`, `test2`.`col60` AS `col60`, `test2`.`col61` AS `col61`, `test2`.`col70` AS `col70`, `test2`.`col77` AS `col77`, `test2`.`col88` AS `col88`, `test2`.`col90` AS `col90`, `test2`.`col72` AS `col72`, `test2`.`col27` AS `col27`, `test2`.`col28` AS `col28`, `test2`.`col42` AS `col42`, `test2`.`col43` AS `col43`, `test2`.`col44` AS `col44`, `test2`.`col3` AS `col3`, `test2`.`col14` AS `col14`, `test2`.`col17` AS `col17`, CAST (`test2`.`col83` AS INT) AS `col83`, `test2`.`col81` AS `col81`, CAST (`test2`.`col96` AS INT) AS `col96`, `test2`.`col80` AS `col80`, CAST (`test2`.`col25` AS INT) AS `col25`, CAST (`test2`.`col68` AS INT) AS `col68`, `test2`.`col23` AS `col23`, CAST (`test2`.`col24` AS INT) AS `col24`, `test2`.`col79` AS `col79`, `test2`.`col2` AS `col2`, `test2`.`col91` AS `col91`, CAST (`test2`.`col78` AS INT) AS `col78`, `test2`.`col93` AS `col93`, CAST (`test2`.`col92` AS INT) AS `col92`, `test2`.`col22` AS `col22`, `test2`.`col36` AS `col36`, `test2`.`col37` AS `col37`, CAST (NULL AS STRING) AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, CAST (NULL AS BIGINT) AS `col7`, CAST (NULL AS BIGINT) AS `col32`, CAST (NULL AS BIGINT) AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, `test2`.`col58` AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test2`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test2`.`ds` FROM `test2` UNION ALL SELECT CAST ('rtestd' AS STRING) AS `event_type`, `test3`.`col16` AS `col16`, `test3`.`col100` AS `col100`, `test3`.`col67` AS `col67`, `test3`.`col84` AS `col84`, `test3`.`col85` AS `col85`, `test3`.`col95` AS `col95`, `test3`.`col41` AS `col41`, `test3`.`col53` AS `col53`, `test3`.`col1` AS `col1`, `test3`.`col13` AS `col13`, `test3`.`col71` AS `col71`, `test3`.`col74` AS `col74`, `test3`.`col4` AS `col4`, `test3`.`col57` AS `col57`, `test3`.`col69` AS `col69`, `test3`.`col5` AS `col5`, `test3`.`col6` AS `col6`, `test3`.`col73` AS `col73`, `test3`.`col87` AS `col87`, `test3`.`col11` AS `col11`, `test3`.`col47` AS `col47`, `test3`.`col48` AS `col48`, `test3`.`col52` AS `col52`, `test3`.`col62` AS `col62`, `test3`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test3`.`col3` AS `col3`, `test3`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test3`.`col29` AS `col29`, `test3`.`col110` AS `col110`, `test3`.`col111` AS `col111`, `test3`.`col112` AS `col112`, `test3`.`col118` AS `col118`, `test3`.`col119` AS `col119`, `test3`.`col105` AS `col105`, `test3`.`col106` AS `col106`, CAST (`test3`.`col107` AS INT) AS `col107`, CAST (`test3`.`col109` AS INT) AS `col109`, CAST (`test3`.`col114` AS INT) AS `col114`, CAST (`test3`.`col115` AS INT) AS `col115`, `test3`.`col116` AS `col116`, CAST (`test3`.`col120` AS INT) AS `col120`, `test3`.`col121` AS `col121`, `test3`.`col7` AS `col7`, `test3`.`col32` AS `col32`, `test3`.`col8` AS `col8`, `test3`.`col12` AS `col12`, `test3`.`col108` AS `col108`, CAST (`test3`.`col30_seconds` AS INT) AS `col30_seconds`, `test3`.`col103` AS `col103`, `test3`.`col104` AS `col104`, `test3`.`col102` AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test3`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test3`.`ds` FROM `test3` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test4`.`col16` AS `col16`, `test4`.`col100` AS `col100`, `test4`.`col67` AS `col67`, `test4`.`col84` AS `col84`, `test4`.`col85` AS `col85`, `test4`.`col95` AS `col95`, `test4`.`col41` AS `col41`, `test4`.`col53` AS `col53`, `test4`.`col1` AS `col1`, `test4`.`col13` AS `col13`, `test4`.`col71` AS `col71`, `test4`.`col74` AS `col74`, `test4`.`col4` AS `col4`, `test4`.`col57` AS `col57`, `test4`.`col69` AS `col69`, `test4`.`col5` AS `col5`, `test4`.`col6` AS `col6`, `test4`.`col73` AS `col73`, `test4`.`col87` AS `col87`, `test4`.`col11` AS `col11`, `test4`.`col47` AS `col47`, `test4`.`col48` AS `col48`, `test4`.`col52` AS `col52`, `test4`.`col62` AS `col62`, `test4`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test4`.`col3` AS `col3`, `test4`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test4`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test4`.`col7` AS `col7`, `test4`.`col32` AS `col32`, `test4`.`col8` AS `col8`, `test4`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, `test4`.`col122` AS `col122`, `test4`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test4`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test4`.`ds` FROM `test4` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test5`.`col16` AS `col16`, `test5`.`col100` AS `col100`, `test5`.`col67` AS `col67`, `test5`.`col84` AS `col84`, `test5`.`col85` AS `col85`, `test5`.`col95` AS `col95`, `test5`.`col41` AS `col41`, `test5`.`col53` AS `col53`, `test5`.`col1` AS `col1`, `test5`.`col13` AS `col13`, `test5`.`col71` AS `col71`, `test5`.`col74` AS `col74`, `test5`.`col4` AS `col4`, `test5`.`col57` AS `col57`, `test5`.`col69` AS `col69`, `test5`.`col5` AS `col5`, `test5`.`col6` AS `col6`, `test5`.`col73` AS `col73`, `test5`.`col87` AS `col87`, `test5`.`col11` AS `col11`, `test5`.`col47` AS `col47`, `test5`.`col48` AS `col48`, `test5`.`col52` AS `col52`, `test5`.`col62` AS `col62`, `test5`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test5`.`col3` AS `col3`, `test5`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test5`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test5`.`col7` AS `col7`, `test5`.`col32` AS `col32`, `test5`.`col8` AS `col8`, `test5`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, `test5`.`col102` AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test5`.`col9` AS `col9`, `test5`.`col123` AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test5`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test5`.`ds` FROM `test5` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test6`.`col16` AS `col16`, `test6`.`col100` AS `col100`, `test6`.`col67` AS `col67`, `test6`.`col84` AS `col84`, `test6`.`col85` AS `col85`, `test6`.`col95` AS `col95`, `test6`.`col41` AS `col41`, `test6`.`col53` AS `col53`, `test6`.`col1` AS `col1`, `test6`.`col13` AS `col13`, `test6`.`col71` AS `col71`, `test6`.`col74` AS `col74`, `test6`.`col4` AS `col4`, `test6`.`col57` AS `col57`, `test6`.`col69` AS `col69`, `test6`.`col5` AS `col5`, `test6`.`col6` AS `col6`, `test6`.`col73` AS `col73`, `test6`.`col87` AS `col87`, `test6`.`col11` AS `col11`, `test6`.`col47` AS `col47`, `test6`.`col48` AS `col48`, `test6`.`col52` AS `col52`, `test6`.`col62` AS `col62`, `test6`.`col64` AS `col64`, CAST (`test6`.`col82` AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test6`.`col3` AS `col3`, `test6`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test6`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test6`.`col7` AS `col7`, `test6`.`col32` AS `col32`, `test6`.`col8` AS `col8`, `test6`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, `test6`.`col102` AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test6`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, `test6`.`col126` AS `col126`, `test6`.`col127` AS `col127`, `test6`.`col128` AS `col128`, `test6`.`col129` AS `col129`, `test6`.`col132` AS `col132`, `test6`.`col133` AS `col133`, CAST (`test6`.`col124` AS INT) AS `col124`, CAST (`test6`.`col125` AS INT) AS `col125`, `test6`.`col130` AS `col130`, `test6`.`col131` AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test6`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test6`.`ds` FROM `test6` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test7`.`col16` AS `col16`, `test7`.`col100` AS `col100`, `test7`.`col67` AS `col67`, `test7`.`col84` AS `col84`, `test7`.`col85` AS `col85`, `test7`.`col95` AS `col95`, `test7`.`col41` AS `col41`, `test7`.`col53` AS `col53`, `test7`.`col1` AS `col1`, `test7`.`col13` AS `col13`, `test7`.`col71` AS `col71`, `test7`.`col74` AS `col74`, `test7`.`col4` AS `col4`, `test7`.`col57` AS `col57`, `test7`.`col69` AS `col69`, `test7`.`col5` AS `col5`, `test7`.`col6` AS `col6`, `test7`.`col73` AS `col73`, `test7`.`col87` AS `col87`, `test7`.`col11` AS `col11`, `test7`.`col47` AS `col47`, `test7`.`col48` AS `col48`, `test7`.`col52` AS `col52`, `test7`.`col62` AS `col62`, `test7`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, `test7`.`col88` AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test7`.`col3` AS `col3`, `test7`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test7`.`col29` AS `col29`, `test7`.`col110` AS `col110`, `test7`.`col111` AS `col111`, `test7`.`col112` AS `col112`, `test7`.`col118` AS `col118`, `test7`.`col119` AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test7`.`col7` AS `col7`, `test7`.`col32` AS `col32`, `test7`.`col8` AS `col8`, `test7`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test7`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, `test7`.`col139` AS `col139`, `test7`.`col163` AS `col163`, `test7`.`col176` AS `col176`, `test7`.`col177` AS `col177`, `test7`.`col134` AS `col134`, `test7`.`col136` AS `col136`, `test7`.`col137` AS `col137`, CAST (`test7`.`col140` AS INT) AS `col140`, `test7`.`col141` AS `col141`, `test7`.`col172` AS `col172`, `test7`.`col175` AS `col175`, `test7`.`col144` AS `col144`, `test7`.`col143` AS `col143`, `test7`.`col145` AS `col145`, `test7`.`col146` AS `col146`, `test7`.`col181` AS `col181`, `test7`.`col174` AS `col174`, `test7`.`col142` AS `col142`, `test7`.`col170` AS `col170`, CAST (`test7`.`col182` AS INT) AS `col182`, `test7`.`col153` AS `col153`, `test7`.`col154` AS `col154`, `test7`.`col167` AS `col167`, `test7`.`col168` AS `col168`, `test7`.`col169` AS `col169`, CAST (`test7`.`col185` AS INT) AS `col185`, `test7`.`col166` AS `col166`, `test7`.`col173` AS `col173`, CAST (`test7`.`col30` AS INT) AS `col30`, CAST (`test7`.`col151` AS INT) AS `col151`, `test7`.`col138` AS `col138`, `test7`.`col165` AS `col165`, CAST (`test7`.`col171` AS INT) AS `col171`, `test7`.`col164` AS `col164`, `test7`.`col160` AS `col160`, CAST (`test7`.`col147` AS INT) AS `col147`, `test7`.`col157` AS `col157`, `test7`.`col158` AS `col158`, `test7`.`col161` AS `col161`, `test7`.`col159` AS `col159`, `test7`.`col162` AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test7`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test7`.`ds` FROM `test7` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test8`.`col16` AS `col16`, `test8`.`col100` AS `col100`, `test8`.`col67` AS `col67`, `test8`.`col84` AS `col84`, `test8`.`col85` AS `col85`, `test8`.`col95` AS `col95`, `test8`.`col41` AS `col41`, `test8`.`col53` AS `col53`, `test8`.`col1` AS `col1`, `test8`.`col13` AS `col13`, `test8`.`col71` AS `col71`, `test8`.`col74` AS `col74`, `test8`.`col4` AS `col4`, `test8`.`col57` AS `col57`, `test8`.`col69` AS `col69`, `test8`.`col5` AS `col5`, `test8`.`col6` AS `col6`, `test8`.`col73` AS `col73`, `test8`.`col87` AS `col87`, `test8`.`col11` AS `col11`, `test8`.`col47` AS `col47`, `test8`.`col48` AS `col48`, `test8`.`col52` AS `col52`, `test8`.`col62` AS `col62`, `test8`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, `test8`.`col88` AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, `test8`.`col27` AS `col27`, `test8`.`col28` AS `col28`, `test8`.`col42` AS `col42`, `test8`.`col43` AS `col43`, `test8`.`col44` AS `col44`, `test8`.`col3` AS `col3`, `test8`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test8`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test8`.`col7` AS `col7`, `test8`.`col32` AS `col32`, `test8`.`col8` AS `col8`, `test8`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test8`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, `test8`.`col139` AS `col139`, `test8`.`col163` AS `col163`, `test8`.`col176` AS `col176`, `test8`.`col177` AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, `test8`.`col175` AS `col175`, `test8`.`col144` AS `col144`, `test8`.`col143` AS `col143`, `test8`.`col145` AS `col145`, `test8`.`col146` AS `col146`, `test8`.`col181` AS `col181`, `test8`.`col174` AS `col174`, `test8`.`col142` AS `col142`, `test8`.`col170` AS `col170`, CAST (`test8`.`col182` AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, `test8`.`col166` AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, `test8`.`col138` AS `col138`, `test8`.`col165` AS `col165`, CAST (NULL AS INT) AS `col171`, `test8`.`col164` AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (`test8`.`col147` AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, `test8`.`col183` AS `col183`, CAST (`test8`.`col208` AS DOUBLE) AS `col208`, `test8`.`col209` AS `col209`, CAST (`test8`.`col219` AS INT) AS `col219`, `test8`.`col186` AS `col186`, `test8`.`col187` AS `col187`, `test8`.`col188` AS `col188`, `test8`.`col192` AS `col192`, `test8`.`col193` AS `col193`, `test8`.`col194` AS `col194`, `test8`.`col195` AS `col195`, `test8`.`col196` AS `col196`, `test8`.`col197` AS `col197`, `test8`.`col198` AS `col198`, `test8`.`col205` AS `col205`, `test8`.`col206` AS `col206`, CAST (`test8`.`col207` AS INT) AS `col207`, CAST (`test8`.`col211` AS INT) AS `col211`, `test8`.`col214` AS `col214`, `test8`.`col215` AS `col215`, CAST (`test8`.`col203` AS INT) AS `col203`, CAST (`test8`.`col212` AS INT) AS `col212`, CAST (`test8`.`col201` AS INT) AS `col201`, CAST (`test8`.`col200` AS INT) AS `col200`, `test8`.`col202` AS `col202`, `test8`.`col218` AS `col218`, `test8`.`col217` AS `col217`, `test8`.`col190` AS `col190`, `test8`.`col213` AS `col213`, CAST (`test8`.`col178` AS INT) AS `col178`, `test8`.`col216` AS `col216`, `test8`.`col210` AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test8`.`col10` AS `col10`, `test8`.`col191` AS `col191`, `test8`.`ds` FROM `test8` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test9`.`col16` AS `col16`, `test9`.`col100` AS `col100`, `test9`.`col67` AS `col67`, `test9`.`col84` AS `col84`, `test9`.`col85` AS `col85`, `test9`.`col95` AS `col95`, `test9`.`col41` AS `col41`, `test9`.`col53` AS `col53`, `test9`.`col1` AS `col1`, `test9`.`col13` AS `col13`, `test9`.`col71` AS `col71`, `test9`.`col74` AS `col74`, `test9`.`col4` AS `col4`, `test9`.`col57` AS `col57`, `test9`.`col69` AS `col69`, `test9`.`col5` AS `col5`, `test9`.`col6` AS `col6`, `test9`.`col73` AS `col73`, `test9`.`col87` AS `col87`, CAST (NULL AS STRING) AS `col11`, `test9`.`col47` AS `col47`, `test9`.`col48` AS `col48`, `test9`.`col52` AS `col52`, `test9`.`col62` AS `col62`, `test9`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test9`.`col3` AS `col3`, `test9`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test9`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test9`.`col7` AS `col7`, `test9`.`col32` AS `col32`, `test9`.`col8` AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test9`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, `test9`.`col220` AS `col220`, `test9`.`col221` AS `col221`, `test9`.`col222` AS `col222`, `test9`.`col223` AS `col223`, `test9`.`col224` AS `col224`, `test9`.`col225` AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test9`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test9`.`ds` FROM `test9` UNION ALL SELECT CAST ('rtestd' AS STRING) AS `event_type`, `test10`.`col16` AS `col16`, `test10`.`col100` AS `col100`, `test10`.`col67` AS `col67`, `test10`.`col84` AS `col84`, `test10`.`col85` AS `col85`, `test10`.`col95` AS `col95`, `test10`.`col41` AS `col41`, `test10`.`col53` AS `col53`, `test10`.`col1` AS `col1`, `test10`.`col13` AS `col13`, `test10`.`col71` AS `col71`, `test10`.`col74` AS `col74`, `test10`.`col4` AS `col4`, `test10`.`col57` AS `col57`, `test10`.`col69` AS `col69`, `test10`.`col5` AS `col5`, `test10`.`col6` AS `col6`, `test10`.`col73` AS `col73`, `test10`.`col87` AS `col87`, `test10`.`col11` AS `col11`, `test10`.`col47` AS `col47`, `test10`.`col48` AS `col48`, `test10`.`col52` AS `col52`, `test10`.`col62` AS `col62`, `test10`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test10`.`col3` AS `col3`, `test10`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, `test10`.`col2` AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, CAST (NULL AS STRING) AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, CAST (NULL AS BIGINT) AS `col7`, CAST (NULL AS BIGINT) AS `col32`, CAST (NULL AS BIGINT) AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test10`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, `test10`.`col226` AS `col226`, `test10`.`col227` AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test10`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test10`.`ds` FROM `test10` UNION ALL SELECT CAST ('rtestd' AS STRING) AS `event_type`, `test11`.`col16` AS `col16`, `test11`.`col100` AS `col100`, `test11`.`col67` AS `col67`, `test11`.`col84` AS `col84`, `test11`.`col85` AS `col85`, `test11`.`col95` AS `col95`, `test11`.`col41` AS `col41`, `test11`.`col53` AS `col53`, `test11`.`col1` AS `col1`, `test11`.`col13` AS `col13`, `test11`.`col71` AS `col71`, `test11`.`col74` AS `col74`, `test11`.`col4` AS `col4`, `test11`.`col57` AS `col57`, `test11`.`col69` AS `col69`, `test11`.`col5` AS `col5`, `test11`.`col6` AS `col6`, `test11`.`col73` AS `col73`, `test11`.`col87` AS `col87`, `test11`.`col11` AS `col11`, `test11`.`col47` AS `col47`, `test11`.`col48` AS `col48`, `test11`.`col52` AS `col52`, `test11`.`col62` AS `col62`, `test11`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, `test11`.`col88` AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test11`.`col3` AS `col3`, `test11`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, `test11`.`col22` AS `col22`, `test11`.`col36` AS `col36`, CAST (NULL AS STRING) AS `col37`, `test11`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test11`.`col7` AS `col7`, `test11`.`col32` AS `col32`, `test11`.`col8` AS `col8`, `test11`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, `test11`.`col9` AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, `test11`.`col139` AS `col139`, `test11`.`col163` AS `col163`, `test11`.`col176` AS `col176`, `test11`.`col177` AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, `test11`.`col175` AS `col175`, `test11`.`col144` AS `col144`, `test11`.`col143` AS `col143`, `test11`.`col145` AS `col145`, `test11`.`col146` AS `col146`, `test11`.`col181` AS `col181`, `test11`.`col174` AS `col174`, `test11`.`col142` AS `col142`, `test11`.`col170` AS `col170`, CAST (`test11`.`col182` AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, `test11`.`col166` AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, `test11`.`col138` AS `col138`, `test11`.`col165` AS `col165`, CAST (NULL AS INT) AS `col171`, `test11`.`col164` AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, `test11`.`col183` AS `col183`, `test11`.`col208` AS `col208`, `test11`.`col209` AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (`test11`.`col212` AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (`test11`.`col178` AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, `test11`.`col210` AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, `test11`.`col228` AS `col228`, `test11`.`col244` AS `col244`, `test11`.`col248` AS `col248`, `test11`.`col249` AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (`test11`.`col246` AS INT) AS `col246`, CAST (`test11`.`col231` AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, `test11`.`col236` AS `col236`, `test11`.`col239` AS `col239`, `test11`.`col242` AS `col242`, `test11`.`col238` AS `col238`, `test11`.`col241` AS `col241`, `test11`.`col240` AS `col240`, `test11`.`col243` AS `col243`, `test11`.`col237` AS `col237`, `test11`.`col245` AS `col245`, `test11`.`col230` AS `col230`, `test11`.`col234` AS `col234`, `test11`.`col235` AS `col235`, CAST (`test11`.`col247` AS INT) AS `col247`, `test11`.`col233` AS `col233`, `test11`.`col232` AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, `test11`.`col10` AS `col10`, CAST (NULL AS STRING) AS `col191`, `test11`.`ds` FROM `test11` UNION ALL SELECT CAST ('stestd' AS STRING) AS `event_type`, `test12`.`col16` AS `col16`, `test12`.`col100` AS `col100`, `test12`.`col67` AS `col67`, `test12`.`col84` AS `col84`, `test12`.`col85` AS `col85`, `test12`.`col95` AS `col95`, `test12`.`col41` AS `col41`, CAST (NULL AS STRING) AS `col53`, CAST (NULL AS BIGINT) AS `col1`, CAST (NULL AS STRING) AS `col13`, `test12`.`col71` AS `col71`, `test12`.`col74` AS `col74`, `test12`.`col4` AS `col4`, CAST (NULL AS BOOLEAN) AS `col57`, CAST (NULL AS STRING) AS `col69`, CAST (NULL AS BIGINT) AS `col5`, CAST (NULL AS BIGINT) AS `col6`, `test12`.`col73` AS `col73`, `test12`.`col87` AS `col87`, CAST (NULL AS STRING) AS `col11`, CAST (NULL AS STRING) AS `col47`, CAST (NULL AS BOOLEAN) AS `col48`, CAST (NULL AS STRING) AS `col52`, CAST (NULL AS DOUBLE) AS `col62`, CAST (NULL AS DOUBLE) AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, `test12`.`col27` AS `col27`, `test12`.`col28` AS `col28`, `test12`.`col42` AS `col42`, `test12`.`col43` AS `col43`, `test12`.`col44` AS `col44`, CAST (NULL AS STRING) AS `col3`, CAST (NULL AS STRING) AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, `test12`.`col2` AS `col2`, `test12`.`col91` AS `col91`, CAST (`test12`.`col78` AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, CAST (NULL AS STRING) AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, CAST (NULL AS BIGINT) AS `col7`, CAST (NULL AS BIGINT) AS `col32`, CAST (NULL AS BIGINT) AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, `test12`.`col75` AS `col75`, `test12`.`col76` AS `col76`, `test12`.`col49` AS `col49`, `test12`.`col50` AS `col50`, `test12`.`col51` AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, `test12`.`col257` AS `col257`, CAST (`test12`.`col255` AS INT) AS `col255`, `test12`.`col254` AS `col254`, `test12`.`col253` AS `col253`, `test12`.`col258` AS `col258`, `test12`.`col259` AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test12`.`ds` FROM `test12` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test13`.`col16` AS `col16`, `test13`.`col100` AS `col100`, `test13`.`col67` AS `col67`, `test13`.`col84` AS `col84`, `test13`.`col85` AS `col85`, `test13`.`col95` AS `col95`, `test13`.`col41` AS `col41`, `test13`.`col53` AS `col53`, `test13`.`col1` AS `col1`, `test13`.`col13` AS `col13`, `test13`.`col71` AS `col71`, `test13`.`col74` AS `col74`, `test13`.`col4` AS `col4`, `test13`.`col57` AS `col57`, `test13`.`col69` AS `col69`, `test13`.`col5` AS `col5`, `test13`.`col6` AS `col6`, `test13`.`col73` AS `col73`, `test13`.`col87` AS `col87`, CAST (NULL AS STRING) AS `col11`, `test13`.`col47` AS `col47`, `test13`.`col48` AS `col48`, `test13`.`col52` AS `col52`, `test13`.`col62` AS `col62`, `test13`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test13`.`col3` AS `col3`, `test13`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test13`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test13`.`col7` AS `col7`, `test13`.`col32` AS `col32`, `test13`.`col8` AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, `test13`.`col260` AS `col260`, `test13`.`col261` AS `col261`, CAST (`test13`.`col262` AS INT) AS `col262`, CAST (`test13`.`col263` AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test13`.`ds` FROM `test13` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test14`.`col16` AS `col16`, `test14`.`col100` AS `col100`, `test14`.`col67` AS `col67`, `test14`.`col84` AS `col84`, `test14`.`col85` AS `col85`, `test14`.`col95` AS `col95`, `test14`.`col41` AS `col41`, `test14`.`col53` AS `col53`, `test14`.`col1` AS `col1`, `test14`.`col13` AS `col13`, `test14`.`col71` AS `col71`, `test14`.`col74` AS `col74`, `test14`.`col4` AS `col4`, `test14`.`col57` AS `col57`, `test14`.`col69` AS `col69`, `test14`.`col5` AS `col5`, `test14`.`col6` AS `col6`, `test14`.`col73` AS `col73`, `test14`.`col87` AS `col87`, `test14`.`col11` AS `col11`, `test14`.`col47` AS `col47`, `test14`.`col48` AS `col48`, `test14`.`col52` AS `col52`, `test14`.`col62` AS `col62`, `test14`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, `test14`.`col27` AS `col27`, `test14`.`col28` AS `col28`, `test14`.`col42` AS `col42`, `test14`.`col43` AS `col43`, `test14`.`col44` AS `col44`, `test14`.`col3` AS `col3`, `test14`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test14`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test14`.`col7` AS `col7`, `test14`.`col32` AS `col32`, `test14`.`col8` AS `col8`, `test14`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, `test14`.`col196` AS `col196`, `test14`.`col197` AS `col197`, `test14`.`col198` AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, `test14`.`col214` AS `col214`, `test14`.`col215` AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, `test14`.`col218` AS `col218`, `test14`.`col217` AS `col217`, CAST (NULL AS STRING) AS `col190`, `test14`.`col213` AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, `test14`.`col66` AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, `test14`.`col253` AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, `test14`.`col265` AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, `test14`.`col264` AS `col264`, `test14`.`col266` AS `col266`, `test14`.`col267` AS `col267`, `test14`.`col268` AS `col268`, `test14`.`col269` AS `col269`, `test14`.`col270` AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test14`.`ds` FROM `test14` UNION ALL SELECT CAST ('test' AS STRING) AS `event_type`, `test15`.`col16` AS `col16`, `test15`.`col100` AS `col100`, `test15`.`col67` AS `col67`, `test15`.`col84` AS `col84`, `test15`.`col85` AS `col85`, `test15`.`col95` AS `col95`, CAST (NULL AS STRING) AS `col41`, CAST (NULL AS STRING) AS `col53`, `test15`.`col1` AS `col1`, CAST (NULL AS STRING) AS `col13`, CAST (NULL AS BIGINT) AS `col71`, CAST (NULL AS STRING) AS `col74`, CAST (NULL AS STRING) AS `col4`, CAST (NULL AS BOOLEAN) AS `col57`, CAST (NULL AS STRING) AS `col69`, CAST (NULL AS BIGINT) AS `col5`, CAST (NULL AS BIGINT) AS `col6`, CAST (NULL AS STRING) AS `col73`, CAST (NULL AS BIGINT) AS `col87`, CAST (NULL AS STRING) AS `col11`, CAST (NULL AS STRING) AS `col47`, CAST (NULL AS BOOLEAN) AS `col48`, CAST (NULL AS STRING) AS `col52`, CAST (NULL AS DOUBLE) AS `col62`, CAST (NULL AS DOUBLE) AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, CAST (NULL AS STRING) AS `col3`, CAST (NULL AS STRING) AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, CAST (NULL AS STRING) AS `col29`, CAST (NULL AS STRING) AS `col110`, CAST (NULL AS BOOLEAN) AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, CAST (NULL AS BIGINT) AS `col7`, CAST (NULL AS BIGINT) AS `col32`, CAST (NULL AS BIGINT) AS `col8`, CAST (NULL AS STRING) AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, CAST (NULL AS BIGINT) AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol6`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol31`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, `test15`.`reason` AS `reason`, CAST (NULL AS STRING) AS `col18`, CAST (NULL AS BOOLEAN) AS `col21`, CAST (NULL AS BIGINT) AS `col97`, CAST (NULL AS BIGINT) AS `col98`, CAST (NULL AS BIGINT) AS `col99`, CAST (NULL AS STRING) AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test15`.`ds` FROM `test15` UNION ALL SELECT CAST ('rated_driver' AS STRING) AS `event_type`, `test16`.`col16` AS `col16`, `test16`.`col100` AS `col100`, `test16`.`col67` AS `col67`, `test16`.`col84` AS `col84`, `test16`.`col85` AS `col85`, `test16`.`col95` AS `col95`, `test16`.`col41` AS `col41`, `test16`.`col53` AS `col53`, `test16`.`col1` AS `col1`, `test16`.`col13` AS `col13`, `test16`.`col71` AS `col71`, `test16`.`col74` AS `col74`, `test16`.`col4` AS `col4`, `test16`.`col57` AS `col57`, `test16`.`col69` AS `col69`, `test16`.`col5` AS `col5`, `test16`.`col6` AS `col6`, `test16`.`col73` AS `col73`, `test16`.`col87` AS `col87`, `test16`.`col11` AS `col11`, `test16`.`col47` AS `col47`, `test16`.`col48` AS `col48`, `test16`.`col52` AS `col52`, `test16`.`col62` AS `col62`, `test16`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test16`.`col3` AS `col3`, `test16`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test16`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, `test16`.`col48` AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test16`.`col7` AS `col7`, `test16`.`col32` AS `col32`, `test16`.`col8` AS `col8`, `test16`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, `test16`.`col97` AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol85`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol86`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, `test16`.`col18` AS `col18`, `test16`.`col21` AS `col21`, CAST (NULL AS BIGINT) AS `col97`, `test16`.`col98` AS `col98`, `test16`.`col99` AS `col99`, `test16`.`col66` AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test16`.`ds` FROM `test16` UNION ALL SELECT CAST ('rtestr' AS STRING) AS `event_type`, `test17`.`col16` AS `col16`, `test17`.`col100` AS `col100`, `test17`.`col67` AS `col67`, `test17`.`col84` AS `col84`, `test17`.`col85` AS `col85`, `test17`.`col95` AS `col95`, `test17`.`col41` AS `col41`, `test17`.`col53` AS `col53`, `test17`.`col1` AS `col1`, `test17`.`col13` AS `col13`, `test17`.`col71` AS `col71`, `test17`.`col74` AS `col74`, `test17`.`col4` AS `col4`, `test17`.`col57` AS `col57`, `test17`.`col69` AS `col69`, `test17`.`col5` AS `col5`, `test17`.`col6` AS `col6`, `test17`.`col73` AS `col73`, `test17`.`col87` AS `col87`, `test17`.`col11` AS `col11`, `test17`.`col47` AS `col47`, `test17`.`col48` AS `col48`, `test17`.`col52` AS `col52`, `test17`.`col62` AS `col62`, `test17`.`col64` AS `col64`, CAST (NULL AS INT) AS `col82`, CAST (NULL AS INT) AS `col117`, CAST (NULL AS BOOLEAN) AS `col54`, CAST (NULL AS BOOLEAN) AS `col56`, CAST (NULL AS BOOLEAN) AS `col59`, CAST (NULL AS BOOLEAN) AS `col60`, CAST (NULL AS BOOLEAN) AS `col61`, CAST (NULL AS STRING) AS `col70`, CAST (NULL AS STRING) AS `col77`, CAST (NULL AS STRING) AS `col88`, CAST (NULL AS STRING) AS `col90`, CAST (NULL AS DOUBLE) AS `col72`, CAST (NULL AS DOUBLE) AS `col27`, CAST (NULL AS DOUBLE) AS `col28`, CAST (NULL AS STRING) AS `col42`, CAST (NULL AS BOOLEAN) AS `col43`, CAST (NULL AS STRING) AS `col44`, `test17`.`col3` AS `col3`, `test17`.`col14` AS `col14`, CAST (NULL AS STRING) AS `col17`, CAST (NULL AS INT) AS `col83`, CAST (NULL AS STRING) AS `col81`, CAST (NULL AS INT) AS `col96`, CAST (NULL AS STRING) AS `col80`, CAST (NULL AS INT) AS `col25`, CAST (NULL AS INT) AS `col68`, CAST (NULL AS STRING) AS `col23`, CAST (NULL AS INT) AS `col24`, CAST (NULL AS STRING) AS `col79`, CAST (NULL AS BIGINT) AS `col2`, CAST (NULL AS TIMESTAMP) AS `col91`, CAST (NULL AS INT) AS `col78`, CAST (NULL AS STRING) AS `col93`, CAST (NULL AS INT) AS `col92`, CAST (NULL AS STRING) AS `col22`, CAST (NULL AS STRING) AS `col36`, CAST (NULL AS STRING) AS `col37`, `test17`.`col29` AS `col29`, CAST (NULL AS STRING) AS `col110`, `test17`.`col48` AS `col111`, CAST (NULL AS STRING) AS `col112`, CAST (NULL AS DOUBLE) AS `col118`, CAST (NULL AS DOUBLE) AS `col119`, CAST (NULL AS STRING) AS `col105`, CAST (NULL AS STRING) AS `col106`, CAST (NULL AS INT) AS `col107`, CAST (NULL AS INT) AS `col109`, CAST (NULL AS INT) AS `col114`, CAST (NULL AS INT) AS `col115`, CAST (NULL AS BOOLEAN) AS `col116`, CAST (NULL AS INT) AS `col120`, CAST (NULL AS BOOLEAN) AS `col121`, `test17`.`col7` AS `col7`, `test17`.`col32` AS `col32`, `test17`.`col8` AS `col8`, `test17`.`col12` AS `col12`, CAST (NULL AS DOUBLE) AS `col108`, CAST (NULL AS INT) AS `col30_seconds`, CAST (NULL AS BIGINT) AS `col103`, CAST (NULL AS STRING) AS `col104`, CAST (NULL AS STRING) AS `col102`, CAST (NULL AS DOUBLE) AS `col122`, CAST (NULL AS STRING) AS `col9`, CAST (NULL AS DOUBLE) AS `col123`, CAST (NULL AS BOOLEAN) AS `col126`, CAST (NULL AS STRING) AS `col127`, CAST (NULL AS BOOLEAN) AS `col128`, CAST (NULL AS STRING) AS `col129`, CAST (NULL AS DOUBLE) AS `col132`, CAST (NULL AS DOUBLE) AS `col133`, CAST (NULL AS INT) AS `col124`, CAST (NULL AS INT) AS `col125`, CAST (NULL AS STRING) AS `col130`, CAST (NULL AS TIMESTAMP) AS `col131`, CAST (NULL AS STRING) AS `col139`, CAST (NULL AS BOOLEAN) AS `col163`, CAST (NULL AS STRING) AS `col176`, CAST (NULL AS STRING) AS `col177`, CAST (NULL AS STRING) AS `col134`, CAST (NULL AS BOOLEAN) AS `col136`, CAST (NULL AS BOOLEAN) AS `col137`, CAST (NULL AS INT) AS `col140`, CAST (NULL AS STRING) AS `col141`, CAST (NULL AS BOOLEAN) AS `col172`, CAST (NULL AS STRING) AS `col175`, CAST (NULL AS STRING) AS `col144`, CAST (NULL AS STRING) AS `col143`, CAST (NULL AS BOOLEAN) AS `col145`, CAST (NULL AS DOUBLE) AS `col146`, CAST (NULL AS STRING) AS `col181`, CAST (NULL AS BOOLEAN) AS `col174`, CAST (NULL AS STRING) AS `col142`, CAST (NULL AS STRING) AS `col170`, CAST (NULL AS INT) AS `col182`, CAST (NULL AS DOUBLE) AS `col153`, CAST (NULL AS DOUBLE) AS `col154`, CAST (NULL AS STRING) AS `col167`, CAST (NULL AS BOOLEAN) AS `col168`, CAST (NULL AS STRING) AS `col169`, CAST (NULL AS INT) AS `col185`, CAST (NULL AS STRING) AS `col166`, CAST (NULL AS STRING) AS `col173`, CAST (NULL AS INT) AS `col30`, CAST (NULL AS INT) AS `col151`, CAST (NULL AS STRING) AS `col138`, CAST (NULL AS STRING) AS `col165`, CAST (NULL AS INT) AS `col171`, CAST (NULL AS STRING) AS `col164`, CAST (NULL AS BOOLEAN) AS `col160`, CAST (NULL AS INT) AS `col147`, CAST (NULL AS BOOLEAN) AS `col157`, CAST (NULL AS BOOLEAN) AS `col158`, CAST (NULL AS BOOLEAN) AS `col161`, CAST (NULL AS BOOLEAN) AS `col159`, CAST (NULL AS BOOLEAN) AS `col162`, CAST (NULL AS STRING) AS `col183`, CAST (NULL AS DOUBLE) AS `col208`, CAST (NULL AS DOUBLE) AS `col209`, CAST (NULL AS INT) AS `col219`, CAST (NULL AS TIMESTAMP) AS `col186`, CAST (NULL AS TIMESTAMP) AS `col187`, CAST (NULL AS BOOLEAN) AS `col188`, CAST (NULL AS BOOLEAN) AS `col192`, CAST (NULL AS BOOLEAN) AS `col193`, CAST (NULL AS BOOLEAN) AS `col194`, CAST (NULL AS BOOLEAN) AS `col195`, CAST (NULL AS STRING) AS `col196`, CAST (NULL AS BOOLEAN) AS `col197`, CAST (NULL AS STRING) AS `col198`, CAST (NULL AS TIMESTAMP) AS `col205`, CAST (NULL AS STRING) AS `col206`, CAST (NULL AS INT) AS `col207`, CAST (NULL AS INT) AS `col211`, CAST (NULL AS DOUBLE) AS `col214`, CAST (NULL AS DOUBLE) AS `col215`, CAST (NULL AS INT) AS `col203`, CAST (NULL AS INT) AS `col212`, CAST (NULL AS INT) AS `col201`, CAST (NULL AS INT) AS `col200`, CAST (NULL AS STRING) AS `col202`, CAST (NULL AS STRING) AS `col218`, CAST (NULL AS STRING) AS `col217`, CAST (NULL AS STRING) AS `col190`, CAST (NULL AS STRING) AS `col213`, CAST (NULL AS INT) AS `col178`, CAST (NULL AS STRING) AS `col216`, `test17`.`col97` AS `col210`, CAST (NULL AS STRING) AS `col220`, CAST (NULL AS BOOLEAN) AS `col221`, CAST (NULL AS STRING) AS `col222`, CAST (NULL AS DOUBLE) AS `col223`, CAST (NULL AS DOUBLE) AS `col224`, CAST (NULL AS TIMESTAMP) AS `col225`, CAST (NULL AS BOOLEAN) AS `col226`, CAST (NULL AS BOOLEAN) AS `col227`, CAST (NULL AS BIGINT) AS `bailout_col7`, CAST (NULL AS BIGINT) AS `original_col7`, CAST (NULL AS DOUBLE) AS `col75`, CAST (NULL AS DOUBLE) AS `col76`, CAST (NULL AS STRING) AS `col49`, CAST (NULL AS BOOLEAN) AS `col50`, CAST (NULL AS STRING) AS `col51`, CAST (NULL AS DOUBLE) AS `vcol2`, CAST (NULL AS DOUBLE) AS `vcol3`, CAST (NULL AS STRING) AS `vcol4`, CAST (NULL AS BOOLEAN) AS `vcol5`, CAST (NULL AS STRING) AS `vcol85`, CAST (NULL AS BOOLEAN) AS `vcol7`, CAST (NULL AS DOUBLE) AS `vcol8`, CAST (NULL AS DOUBLE) AS `vcol9`, CAST (NULL AS DOUBLE) AS `vcol10`, CAST (NULL AS DOUBLE) AS `vcol11`, CAST (NULL AS BIGINT) AS `vcol12`, CAST (NULL AS BOOLEAN) AS `vcol13`, CAST (NULL AS INT) AS `vcol14`, CAST (NULL AS INT) AS `vcol15`, CAST (NULL AS DOUBLE) AS `vcol16`, CAST (NULL AS INT) AS `vcol17`, CAST (NULL AS STRING) AS `vcol18`, CAST (NULL AS STRING) AS `vcol19`, CAST (NULL AS BOOLEAN) AS `vcol20`, CAST (NULL AS STRING) AS `vcol21`, CAST (NULL AS INT) AS `vcol22`, CAST (NULL AS DOUBLE) AS `col228`, CAST (NULL AS DOUBLE) AS `col244`, CAST (NULL AS DOUBLE) AS `col248`, CAST (NULL AS DOUBLE) AS `col249`, CAST (NULL AS DOUBLE) AS `vcol23`, CAST (NULL AS BOOLEAN) AS `vcol24`, CAST (NULL AS DOUBLE) AS `vcol25`, CAST (NULL AS DOUBLE) AS `vcol26`, CAST (NULL AS BOOLEAN) AS `vcol27`, CAST (NULL AS STRING) AS `vcol28`, CAST (NULL AS BOOLEAN) AS `vcol29`, CAST (NULL AS DOUBLE) AS `vcol30`, CAST (NULL AS STRING) AS `vcol86`, CAST (NULL AS INT) AS `col246`, CAST (NULL AS INT) AS `col231`, CAST (NULL AS INT) AS `vcol32`, CAST (NULL AS INT) AS `vcol33`, CAST (NULL AS TIMESTAMP) AS `vcol34`, CAST (NULL AS STRING) AS `vcol35`, CAST (NULL AS STRING) AS `vcol36`, CAST (NULL AS STRING) AS `vcol37`, CAST (NULL AS STRING) AS `old_value`, CAST (NULL AS BIGINT) AS `new_col32`, CAST (NULL AS BIGINT) AS `old_col32`, CAST (NULL AS BIGINT) AS `canceling_col32`, CAST (NULL AS BOOLEAN) AS `col236`, CAST (NULL AS BOOLEAN) AS `col239`, CAST (NULL AS BOOLEAN) AS `col242`, CAST (NULL AS BOOLEAN) AS `col238`, CAST (NULL AS BOOLEAN) AS `col241`, CAST (NULL AS BOOLEAN) AS `col240`, CAST (NULL AS BOOLEAN) AS `col243`, CAST (NULL AS BOOLEAN) AS `col237`, CAST (NULL AS DOUBLE) AS `col245`, CAST (NULL AS DOUBLE) AS `col230`, CAST (NULL AS STRING) AS `col234`, CAST (NULL AS STRING) AS `col235`, CAST (NULL AS INT) AS `col247`, CAST (NULL AS STRING) AS `col233`, CAST (NULL AS STRING) AS `col232`, CAST (NULL AS STRING) AS `reason`, `test17`.`col18` AS `col18`, `test17`.`col21` AS `col21`, CAST (NULL AS BIGINT) AS `col97`, `test17`.`col98` AS `col98`, `test17`.`col99` AS `col99`, `test17`.`col66` AS `col66`, CAST (NULL AS STRING) AS `col257`, CAST (NULL AS INT) AS `col255`, CAST (NULL AS STRING) AS `col254`, CAST (NULL AS STRING) AS `col253`, CAST (NULL AS BIGINT) AS `col258`, CAST (NULL AS STRING) AS `col259`, CAST (NULL AS BIGINT) AS `col250`, CAST (NULL AS STRING) AS `col251`, CAST (NULL AS BOOLEAN) AS `is_col62e`, CAST (NULL AS STRING) AS `col252`, CAST (NULL AS STRING) AS `col256`, CAST (NULL AS STRING) AS `col260`, CAST (NULL AS STRING) AS `col261`, CAST (NULL AS INT) AS `col262`, CAST (NULL AS INT) AS `col263`, CAST (NULL AS BOOLEAN) AS `vcol38`, CAST (NULL AS BOOLEAN) AS `vcol39`, CAST (NULL AS BOOLEAN) AS `vcol40`, CAST (NULL AS BOOLEAN) AS `vcol41`, CAST (NULL AS STRING) AS `vcol42`, CAST (NULL AS DOUBLE) AS `vcol43`, CAST (NULL AS DOUBLE) AS `vcol44`, CAST (NULL AS STRING) AS `col265`, CAST (NULL AS STRING) AS `vcol45`, CAST (NULL AS INT) AS `vcol46`, CAST (NULL AS STRING) AS `vcol47`, CAST (NULL AS TIMESTAMP) AS `vcol48`, CAST (NULL AS STRING) AS `vcol49`, CAST (NULL AS STRING) AS `vcol50`, CAST (NULL AS TIMESTAMP) AS `vcol51`, CAST (NULL AS STRING) AS `vcol52`, CAST (NULL AS STRING) AS `name`, CAST (NULL AS BOOLEAN) AS `return`, CAST (NULL AS STRING) AS `vcol53`, CAST (NULL AS STRING) AS `vcol54`, CAST (NULL AS INT) AS `vcol55`, CAST (NULL AS INT) AS `vcol56`, CAST (NULL AS INT) AS `version`, CAST (NULL AS DOUBLE) AS `vcol57`, CAST (NULL AS DOUBLE) AS `vcol58`, CAST (NULL AS DOUBLE) AS `vcol59`, CAST (NULL AS DOUBLE) AS `vcol60`, CAST (NULL AS DOUBLE) AS `vcol61`, CAST (NULL AS DOUBLE) AS `vcol62`, CAST (NULL AS DOUBLE) AS `vcol63`, CAST (NULL AS DOUBLE) AS `vcol64`, CAST (NULL AS BOOLEAN) AS `vcol65`, CAST (NULL AS BOOLEAN) AS `vcol66`, CAST (NULL AS INT) AS `vcol67`, CAST (NULL AS INT) AS `vcol68`, CAST (NULL AS INT) AS `vcol69`, CAST (NULL AS DOUBLE) AS `vcol70`, CAST (NULL AS DOUBLE) AS `vcol71`, CAST (NULL AS INT) AS `vcol72`, CAST (NULL AS DOUBLE) AS `vcol73`, CAST (NULL AS DOUBLE) AS `vcol74`, CAST (NULL AS INT) AS `old_vcol56`, CAST (NULL AS DOUBLE) AS `vcol75`, CAST (NULL AS STRING) AS `vcol76`, CAST (NULL AS STRING) AS `vcol77`, CAST (NULL AS STRING) AS `col184`, CAST (NULL AS BOOLEAN) AS `vcol78`, CAST (NULL AS BOOLEAN) AS `vcol79`, CAST (NULL AS STRING) AS `vcol80`, CAST (NULL AS BOOLEAN) AS `col58`, CAST (NULL AS BOOLEAN) AS `col264`, CAST (NULL AS STRING) AS `col266`, CAST (NULL AS STRING) AS `col267`, CAST (NULL AS BOOLEAN) AS `col268`, CAST (NULL AS BOOLEAN) AS `col269`, CAST (NULL AS STRING) AS `col270`, CAST (NULL AS BOOLEAN) AS `vcol81`, CAST (NULL AS BIGINT) AS `other_col32`, CAST (NULL AS BOOLEAN) AS `vcol82`, CAST (NULL AS BOOLEAN) AS `vcol83`, CAST (NULL AS STRING) AS `vcol84`, CAST (NULL AS BIGINT) AS `col10`, CAST (NULL AS STRING) AS `col191`, `test17`.`ds` FROM `test17`; SELECT a.col1 ,MAX(a.col2) AS col2 ,MAX(b.col67) AS col3 ,MAX(b.col91) AS col91 FROM test1 a JOIN test_view b ON a.col2 = b.col2 WHERE a.col2 IS NOT NULL GROUP BY a.col1;