Errata

Google BigQuery: The Definitive Guide

Errata for Google BigQuery: The Definitive Guide

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Mobi
Page Location 7438
Footnote 26

Footnote 26 directly contradicts Google's on-line documentation for ST_GEOGFROMGEOJSON and ST_GEOGFROMTEXT. According to the on-line documentation, it is GeoJSON data that will be tessellated, and not WKT data. The on-line documentation makes sense, as GeoJSON defines lines as being planar, and BigQuery GEOGRAPHY defines lines as spherical geodesics.

This also makes the text that references the foot note incorrect.

Note from the Author or Editor:
Yes, this is correct. I've fixed Atlas.

 Peter Aronson  Aug 26, 2020 
46
Section CROSS JOIN

The code sample following the sentence "You can give each winner the gift corresponding to their event only by doing an INNER JOIN:" does not have a JOIN condition. BigQuery returns error message "INNER JOIN must have an immediately following ON or USING clause at [5:43]" Clearly the intention is to have an inner join on the event column. The code can easily be fixed by adding " using (event)" as a new line following "JOIN gifts" and this was tested in BQ and works.

Note from the Author or Editor:
I've fixed it in Atlas

 Norbert Kremer  Dec 31, 2019  Jun 12, 2020
Printed
Page 103
1st code block

ch04.cloudaudit_googleapis_com_data_access_2019*

should be enclosed within ``, i.e.

`ch04.cloudaudit_googleapis_com_data_access_2019*`

as per https://cloud.google.com/bigquery/docs/reference/auditlogs/

Note from the Author or Editor:
i've fixed it in Atlas

 Michael Shearer  Dec 27, 2019  Jun 12, 2020
Printed
Page 392
Code Sample

Matrix Factorization requires a BigQuery slot reservation assigned to the project.

Note from the Author or Editor:
fixed

 Michael Shearer  Apr 27, 2020  Jun 12, 2020
Printed
Page 421
1st code block

bc not installed by default in cloud shell.

sudo apt install bc

Note from the Author or Editor:
fixed

 Michael Shearer  Apr 10, 2020  Jun 12, 2020