背景 igcn.hateblo.jp 方法 実行は慎むこと。データ参照は0バイトだが、7000秒たっても(現時点)結果は出ない。こんなおバカなクエリをBQ様に投げて心が痛い。 WITH num_list AS ( SELECT n FROM ( SELECT GENERATE_ARRAY(1,1000) a ) CROSS JOIN UNNEST(a) AS n), n1 as (select n from num_list where n * 1 <= 1000), n2 as (select n from num_list where n * 2 <= 1000), n3 as (select n from num_list where n * 3 <= 1000), n5 as (select n from num_list where n * 5 <= 1000), n10 as