Dan Halperin dhalperi

## beam_merge_pr.sh
#!/bin/bash

# This is a utility script to merge pull requests into Apache Beam
# repositories. It supports both repositories, source and website.
#
# Usage:
#    merge_pr.sh [repository] [branch] pull_request_number
#
# Where:
#    repository: { beam | beam-site }

## Top Apache Repositories by PRs Opened since Apache Beam started incubation.sql
WITH since_incubation AS (
   SELECT * FROM `githubarchive.day.201*`
   WHERE _TABLE_SUFFIX > '60131' -- after 2016-01-31 since Beam started incubating on 2016-02-01
),
pull_requests AS (
  SELECT
    -- map a podling to its final name
    replace(e.repo.name, "incubator-", "") AS repo,
    COUNT(*) AS pr_count
  FROM since_incubation AS e
	#!/bin/bash

	# This is a utility script to merge pull requests into Apache Beam
	# repositories. It supports both repositories, source and website.
	#
	# Usage:
	# merge_pr.sh [repository] [branch] pull_request_number
	#
	# Where:
	# repository: { beam \| beam-site }
	WITH since_incubation AS (
	SELECT * FROM `githubarchive.day.201*`
	WHERE _TABLE_SUFFIX > '60131' -- after 2016-01-31 since Beam started incubating on 2016-02-01
	),
	pull_requests AS (
	SELECT
	-- map a podling to its final name
	replace(e.repo.name, "incubator-", "") AS repo,
	COUNT(*) AS pr_count
	FROM since_incubation AS e