Errata

The paragraph says "let’s say you create catalog properties files etc/cdh-hadoop.properties, etc/sales.properties, etc/web- traffic.properties, and etc/mysql-dev.properties. "

But per previous description, catalog property files should be under etc/catalog/ folder. Thus, those file names should be etc/catalog/cdh-hadoop.properties, etc/catalog/sales.properties, etc/catalog/web- traffic.properties, and etc/catalog/mysql-dev.properties.

Note from the Author or Editor:
Fixed

it says "The server is available as a JAR file."
but I think it should be "the *driver* is available as a JAR file"

Note from the Author or Editor:
Fixed

Direction of the arrows going to and from the CLI to the coordinator are pointing in the wrong directions. The SQL statement should be pointing to the coordinator and the return values should be pointing back to the CLI.

Note from the Author or Editor:
The feedback is correct. I requested an image update for the new revision.

In example 4-4, there is a comment "// then inner join cutkey"

But the "cutkey" is a typo, it should be "custkey"

Note from the Author or Editor:
Fixed

It says "The key is sorted first by the key and the column in ascending lexicographic order"

I think it makes no sense that a "key" is sorted first by "the key". I guess the sentence should be "the key is sorted first by the row ID and the column ..."

Note from the Author or Editor:
Fixed

Another advanced feature of a connector is to provide table statistics, *which* (instead of "that") can be used ... to query plans. (There were two dot in the original version of epub)

Note from the Author or Editor:
I fixed this in the source code now and pushed the change to master.

"hdfs:/user/hive/warehouse/web/page_views/..." -> hdfs://

Double slash should be here.

Note from the Author or Editor:
Fixed

The figures 10.7, 10.8 and 10.9 use the wrong label for the TLS certificate.

It should be changed from

TLS Certification

to

TLS Certificate

for all occurrences in the three images.

You can change the *code* to use SNAPPY or NONE by setting the hive.compression-codec configuration in the catalog properties file.

code->codec

Note from the Author or Editor:
Fixed

By using the Cassandra connector, however, you can allow SQL querying of your data in Cassandra. Minimal configuration is a simple catalog file like etc/catalog/sitedata for a Cassandra cluster tracking all user interaction on a website, for example

etc/catalog/sitedata-> etc/catalog/sitedata.properties

Note from the Author or Editor:
Fixed

The insert SQL missed a closing parenthesis.

INSERT INTO iris (
sepal_length_cm,
sepal_width_cm,
petal_length_cm,
petal_width_cm,
species )
VALUES
( ... ***)****

Note from the Author or Editor:
.. implied that more is coming but sure .. I added the )

The insert SQL missed a closing parenthesis.

INSERT INTO iris (
sepal_length_cm,
sepal_width_cm,
petal_length_cm,
petal_width_cm,
species )
VALUES
( ... ***)****

Note from the Author or Editor:
Fixed

In the Table 9-7, concat function: "Equivalent to the operator."

There is a missing operator ||.

Note from the Author or Editor:
Fixed

There should be an example like "regexp_like(abc, d*)" for "* Zero or more" in table 9-11.

Note from the Author or Editor:
Fixed

There is a duplicated DEALLOCATE in the last section.

DEALLOCATE PREPARE delay_query;
*DEALLOCATE*

Note from the Author or Editor:
Fixed