issue lifetime

issue_lifetime.sql

SELECT
  created_at,
  closed_at,
  CONCAT(title, ' ', REGEXP_REPLACE(body, '(\r|\n|\r\n)',' ')) AS text
FROM (
  SELECT
    JSON_EXTRACT_SCALAR(payload, '$.issue.created_at') AS created_at,
    JSON_EXTRACT_SCALAR(payload, '$.issue.closed_at') AS closed_at,
    JSON_EXTRACT_SCALAR(payload, '$.action') AS action,
    JSON_EXTRACT_SCALAR(payload, '$.issue.title') AS title,
    JSON_EXTRACT_SCALAR(payload, '$.issue.body') AS body
  FROM
--     [githubarchive:day.20180201],
--     [githubarchive:day.20180202],
--     [githubarchive:day.20180203],
--     [githubarchive:day.20180204],
    [githubarchive:day.20180205]
  WHERE
    type = 'IssuesEvent'
  )
WHERE 
  body != 'null'
  AND action = 'closed'
LIMIT 10000;