Google Interview Report
- -1of 1 vote
AnswersBIG DAT AND MACHINE LEARNING
- prasad.hybris April 03, 2018 in United States
Hi Cloud Support,
I have records like this in BigQuery:
logs.datetime: ''2017-07-01T13:51:03"
logs.type: "worker"
logs.message: "Starting pipeline"
apps.name: "reader_af45c9"
apps.log_type: "worker"
And I'm trying to run this query:
select logs.datetime, logs.type, logs.message, apps.name
from logs inner join apps on logs.type = apps.log_type
where logs.datetime > "2017-07-01T00:00:00" and logs.datetime < "2017-07-02T00:00:00"
group by apps.name;
But it's not working. Can you help me?| Report Duplicate | Flag | PURGE
Google Cloud Support Associate Database - -1of 1 vote
AnswersA sample state of ‘a’:
- prasad.hybris April 03, 2018 in United States
[[2, NULL, 2, NULL],
[2, NULL, 2, NULL],
[NULL, NULL, NULL, NULL],
[NULL, NULL, NULL, NULL]]
FUNCTION foo()
FOR y = 0 to 3
FOR x = 0 to 3
IF a[x+1][y] != NULL
IF a[x+1][y] = a[x][y]:
a[x][y] := a[x][y]*2
a[x+1][y] := NULL
END IF
IF a[x][y] = NULL
a[x][y] := a[x+1][y]
a[x+1][y] := NULL
END IF
END IF
END FOR
END FOR
END FUNCTION| Report Duplicate | Flag | PURGE
Google Cloud Support Associate Algorithm - -2of 2 votes
AnswersUsing Google BigQuery documentation, provide at least three (3) possible failure modes that could cause following customer problem:
- prasad.hybris April 03, 2018 in United States
""" I am ingesting data regularly in streaming mode into my mobile-events table, querying the data back however shows timestamps six hours behind. Please help. """
You can use public BigQuery documentation for the client side and make assumptions about the serving side based on your experience with other similar products, provided the serving stack spreads across multiple machines and microservices.| Report Duplicate | Flag | PURGE
Google Cloud Support Associate Database