How to query for certain text in log messages from Google App Engine that are exported to BigQuery?
4
votes
2
answers
1374
views
I have used the 'Create Export' in the Logging section of Google Cloud Platform to export log entries into Big Query for analysis
Here is part of the structure of the table in BigQuery that logs the log entry
I want to search for entries that contains this user id 14994838999176.
In BigQuery, I issue the following query (in standard SQL dialect),
SELECT * FROM gae_log.appengine_googleapis_com_request_log_20180323
where protoPayload.line.logMessage like '%14994838999176%'
LIMIT 1000
It failed with the error message:
Query Failed
Error: Cannot access field logMessage on a value with type
ARRAY> at [3:25]
How can I correct my sql statement?
Here is part of the structure of the table in BigQuery that logs the log entry
I want to search for entries that contains this user id 14994838999176.
In BigQuery, I issue the following query (in standard SQL dialect),
SELECT * FROM gae_log.appengine_googleapis_com_request_log_20180323
where protoPayload.line.logMessage like '%14994838999176%'
LIMIT 1000
It failed with the error message:
Query Failed
Error: Cannot access field logMessage on a value with type
ARRAY> at [3:25]
How can I correct my sql statement?
Asked by Anthony Kong
(141 rep)
Mar 23, 2018, 04:28 AM
Last activity: Sep 3, 2022, 11:27 AM
Last activity: Sep 3, 2022, 11:27 AM