राशि की गणना के समय की एक शब्द में प्रकट होता है BigQuery स्तंभ

कोशिश नीचे दिए गए सरल दृष्टिकोण

with blacklist as (
  select 'with' word union all 
  select 'that' union all
  select 'add more as you see needed'
)
select lower(word) word, count(*) frequency
from data, unnest(regexp_extract_all(col, r'[\w]*')) word
where length(word) > 3  
and word not in (select word from blacklist)
group by word
order by frequency desc