Skip to content

Instantly share code, notes, and snippets.

@ikuwow
Last active January 22, 2017 15:42
Show Gist options
  • Save ikuwow/7d9b32b77843720aa307537136bec540 to your computer and use it in GitHub Desktop.
Save ikuwow/7d9b32b77843720aa307537136bec540 to your computer and use it in GitHub Desktop.
CloudLoggingからBigQueryに流したログ(tsv in json)をみる ref: http://qiita.com/ikuwow/items/28369c4dc31a832a6ca1
-- use regacy sqlはoff
SELECT
REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){0}([^\t]*).*') AS field1,
REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){1}([^\t]*).*') AS field2,
REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){2}([^\t]*).*') AS field3,
...
FROM
`projectname.datasetname.somelogs_*`
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment