notebook.community

Edit and run

Full scan on 10B rows of Wikimedia logs





In [ ]:



    


%%sql
SELECT
  title,
  SUM(views) AS views
FROM
  [bigquery-samples:wikipedia_benchmark.Wiki10B]
WHERE
  REGEXP_MATCH(title, r' Hello ')
GROUP BY
  title
ORDER BY
  views DESC
LIMIT 
  10



    











In [ ]:

Content source: kazunori279/cloudml-demo

Similar notebooks:

notebook.community | gallery | about