0

More than 3 years have passed since last update.

株式会社Sprocket

BigQuery の TIMESTAMP 型のある Schema にて時間・分・秒単位での行数を知る方法

BigQuery

Last updated at 2020-09-07Posted at 2017-03-15

時間単位

SELECT
  SUBSTR(STRING(TIMESTAMP_COLUMN_NAME), 1, length('yyyy-mm-dd hh')) AS duration, count(TIMESTAMP_COLUMN_NAME) as cnt
FROM
  `DATASET.TABLENAME`
GROUP BY
  duration
ORDER BY
  duration ASC

分単位・秒単位

length('yyyy-mm-dd hh') を length('yyyy-mm-dd hh:mm') や length('yyyy-mm-dd hh:mm:ss') に変える

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0