small medium large xlarge

The latest version of the book is P1.0, released over 1 year ago. If you've bought a PDF of the book and would like to update it to this version (for free), visit your home page.

By default this page displays the errata for the latest version of the book. If you have a previous version, select it here:

If you've found a new error, please submit it.

  • Typo
  • Tech. error
  • Suggestion
  • Maybe next edition
  • Not a problem
  • Reported in: P1.0 (11-Nov-18)
#83892
PDF page: 0
Section: PostgreSQL 'I'll meet you at the cross tab' (no page numbers in Safaribooksonline docs): Problem: When calling the function 'crosstab', ...more...
  • Reported in: P1.0 (23-Jul-18)
#83396
PDF page: 10
Re: the table to pivot around for crosstab() in Day 2 of postgresql An explicit list of values is no longer required by crosstab() in postgresql. ...more...
  • Reported in: P1.0 (17-Apr-18)
#83014
PDF page: 17
Hi there! The dates in the table containing Fight Club, April Fool's Day, and Christmas appear to have some copy pasta. The "starts" date for Chris...more...
  • Reported in: P1.0 (15-Jan-19)
#84311
PDF page: 17
On this page we are tasked to create a table and enter three dates. I noticed that the third event called 'Christmas Day' has the same start date as t...more...
  • Reported in: P1.0 (25-Aug-19)
#85735
Paper page: 23
The grouping example does not match the content of the events table. Following the previous examples, the table looks like this: event_id | ti...more...
  • Reported in: P1.0 (25-Aug-19)
#85736
Paper page: 23
The HAVING query is missing a count(*) in the SELECT statement. To match the printed result, it should be: SELECT venue_id, count(*) FROM events ...more...
  • Reported in: P1.0 (25-Aug-19)
#85737
Paper page: 25
The results of the query "SELECT title, count(*) OVER (PARTITION BY venue_id) FROM events" does not match the database whatsoever. The result should b...more...
  • Reported in: P1.0 (10-Aug-19)
#85672
Paper page: 32

There is no WHERE clause in the EXPLAIN QUERY and therefore the output contains filters that where not stated.--Emilio Basuald

  • Reported in: P1.0 (17-Jun-18)
#83274
PDF page: 42
Paper page: 42
Replace cat `pg_config --sharedir`/tsearch_data/english.stop with cat `locate english.stop` pg_config is installed only if the developer st...more...
  • Reported in: P1.0 (09-Nov-18)
#83879
PDF page: 43
Paper page: 29
The book suggests using the createlang command $ createlang 7dbs --list In pg 10, this gave an error: Error: pg_wrapper: createlang was not f...more...
  • Reported in: P1.0 (03-Apr-19)
#84818
PDF page: 61
Hello! I feel like there is a mistake in the chapter about HBase database. It is written that the column family is not specified and the colon is r...more...
  • Reported in: P1.0 (28-Aug-19)
#85742
Paper page: 61
Page 61, Inserting, Updating and Retrieving Data, 3rd paragraph: I says that we are no specifying the column ->family<-. It should say column qualifi...more...
  • Reported in: P1.0 (01-Jul-18)
#83313
Paper page: 96

On page 95, party was set to "D", but on page 96 it's listed as "I".

  • Reported in: P1.0 (11-Apr-18)
#82983
Paper page: 185

The vintages on the figure are all 2007, but they should be 2015, 2010 & 2002--Jean-François "Jeff" Héon

  • Reported in: P1.0 (12-Apr-18)
#83001
PDF page: 185
On the figure, we should have a double grape_type relationship between the Prancing wolf ice wine and Riesling. One that was specified exactly on ice ...more...
  • Reported in: P1.0 (12-Apr-18)
#83000
PDF page: 186
This query returns nothing (because no friends relationships starts from Alice) MATCH (p:Person {name: "Alice"})-->(other: Person) RETURN other.na...more...
  • Reported in: P1.0 (21-Oct-18)
#83804
PDF page: 187
MATCH (p1:Person {name: "Kofi"}),(p2:Person {name: "Tom"}); CREATE (p1)-[r:friends]->(p2); MATCH ... ; CREATE ...; Between the MATCH and the CR...more...
  • Reported in: P1.0 (21-Oct-18)
#83806
PDF page: 190
$ curl -i -XPOST ..... \ -H "Content-Type: application/json" \ -d '{ "name": "P.G. Wodehouse" "genre": "British Humour" }' Missing a comma in ...more...
  • Reported in: P1.0 (25-Jul-19)
#85609
PDF page: 198

When counting the number of actors Kevin Bacon played with, in the query result, it is written 304, and in the next paragraph — 313.--German Tebiev

  • Reported in: P1.0 (07-Apr-18)
#82965
PDF page: 234

In Day 2 of DynamoDB
Section: Getting our Keys Right

ReadingId attribute is mentioned but not used in SensorData table.--sydcanem

  • Reported in: P1.0 (23-Apr-18)
#83039
PDF page: 264
Or we can retrieve all hash keys. redis 127.0.0.1:6379> HVALS user:luc 1) "name" 2) "password" instead of redis 127.0.0.1:6379> HKEYS user:lu...more...
  • Reported in: P1.0 (16-Jan-19)
#84314
PDF page: 279

Redis, Day 2
In redis.conf file, it should be:

databases 16

instead of:

database 16--sepanko

  • Reported in: P1.0 (04-Nov-18)
#83856
PDF page: 285
$ ruby data_dump_cluster.rb 10000 100000 items in 6.614907 seconds You have to add a 0 to TOTAL_NUMBER_OF_ENTRIES to insert 100000 keys. --Ariel ...more...
  • Reported in: P1.0 (27-Sep-19)
#85821
PDF page: 317

In the second part of CAP Adventure, the year 2009 is mentioned while 2019 seems to be a fit here.--German Tebiev