google-bigquery - 如何为正则表达式中命名的每个实体生成单独的输出文件？

Question

我运行了这段代码：

SELECT theme, COUNT(*) as count
FROM (
select UNIQUE(REGEXP_REPLACE(SPLIT(V2locations,';'), r',.*', '')) theme
  from [gdelt-bq:gdeltv2.gkg]
where DATE>20150302000000 and DATE < 20200609000000 and REGEXP_MATCH(V2locations, 
r'Burundi|Djibouti|Egypt|Equatorial Guinea|Eritrea|Mauritania|Sierra Leone|South Sudan|PR Congo|DR 
Congo|Guinea Bissau|Sao Tome and Principe')   
AND V2themes like '%WB_133_INFORMATION_AND_COMMUNICATION_TECHNOLOGIES%'
)
group by theme
ORDER BY 2 DESC
LIMIT 300

我想生成单独的输出文件，列出每个国家的主题。我怎样才能做到这一点？

标签： google-bigquery