TreasureDataのSQL処理でループ処理を実行したいのですが可能でしょうか。
下記の様な数字が1ずつ加算される同じ処理を1000回以上実施したいです。
sql
1SELECT conversiondate , path1 as key , totalconversions as value 2FROM 3( 4 SELECT 5 conversiondate, 6 totalconversions, 7 CASE 8 WHEN split_part(basicchannelgroupingpath, ',', 1) LIKE '%Direct%' THEN 'path1_Direct' 9 WHEN split_part(basicchannelgroupingpath, ',', 1) LIKE '%CLICK%' THEN 'path1_CLICK' 10 WHEN split_part(basicchannelgroupingpath, ',', 1) LIKE '%Organic%' THEN 'path1_Organic' 11 WHEN split_part(basicchannelgroupingpath, ',', 1) LIKE '%Social%' THEN 'path1_Social' 12 WHEN split_part(basicchannelgroupingpath, ',', 1) LIKE '%Referral%' THEN 'path1_Referral' 13 END as path1, 14 FROM basicchannelgroupingpath_api 15) as a1 16UNION ALL 17SELECT conversiondate , path2 as key , totalconversions as value 18FROM 19( 20 SELECT 21 conversiondate, 22 totalconversions, 23 CASE 24 WHEN split_part(basicchannelgroupingpath, ',', 2) LIKE '%Direct%' THEN 'path2_Direct' 25 WHEN split_part(basicchannelgroupingpath, ',', 2) LIKE '%CLICK%' THEN 'path2_CLICK' 26 WHEN split_part(basicchannelgroupingpath, ',', 2) LIKE '%Organic%' THEN 'path2_Organic' 27 WHEN split_part(basicchannelgroupingpath, ',', 2) LIKE '%Social%' THEN 'path2_Social' 28 WHEN split_part(basicchannelgroupingpath, ',', 2) LIKE '%Referral%' THEN 'path2_Referral' 29 END as path2 30) as a2 31UNION ALL 32SELECT conversiondate , path3 as key , totalconversions as value 33FROM 34( 35 SELECT 36 conversiondate, 37 totalconversions, 38 CASE 39 WHEN split_part(basicchannelgroupingpath, ',', 3) LIKE '%Direct%' THEN 'path3_Direct' 40 WHEN split_part(basicchannelgroupingpath, ',', 3) LIKE '%CLICK%' THEN 'path3_CLICK' 41 WHEN split_part(basicchannelgroupingpath, ',', 3) LIKE '%Organic%' THEN 'path3_Organic' 42 WHEN split_part(basicchannelgroupingpath, ',', 3) LIKE '%Social%' THEN 'path3_Social' 43 WHEN split_part(basicchannelgroupingpath, ',', 3) LIKE '%Referral%' THEN 'path3_Referral' 44 END as path3 45) as a3 46UNION ALL 47・ 48・ 49・ 50・ 51これが永続的に続きます。
上記をfor文の様に書きたいのですが
Treasure Dataでは可能でしょうか?