Big Query统计最常用php函数

phpfunctions.sql

#standardSQL
CREATE TEMPORARY FUNCTION parseFunction(src STRING)
RETURNS ARRAY<STRING>
LANGUAGE js AS """
  var result = [];
  var regex = /([:\\w]+?)(?:\\()/g;
  var match;
  while (match = regex.exec(src)) {
    result.push(match[1]);
  }
  return result;
""";

SELECT
  function_name,
  COUNT(function_name) AS count
FROM (
  SELECT
    parseFunction(c.content) AS function_name
  FROM
    `bigquery-public-data.github_repos.contents` c
  JOIN (
    SELECT
      id
    FROM
      `bigquery-public-data.github_repos.sample_files`
      where path like '%.php'
  ) f
  ON f.id = c.id) f2,
  UNNEST(function_name) AS function_name
WHERE
  function_name IS NOT NULL
GROUP BY
  function_name
ORDER BY
  count DESC
LIMIT
  1000

result.csv