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<STRUCT<time TIMESTAMP, severity STRING, logMessage STRING, ...>> at [3:25]
How can I correct my sql statement?