How deeply does DuckDB in Action cover float64?

Explains schema inspection, whole-STRUCT casting, and verification, but defers floating-point representation internals.

Float64

A double is a floating-point numeric data type that stores values with approximately twice the precision of a single-precision value.

float64, written as DOUBLE in DuckDB, gives numeric fields the type needed for arithmetic when automatic inference leaves them as strings. A practical workflow is to inspect the inferred STRUCT, cast fields such as X, Y, and xG, then query the flattened data. section 5.3

Correcting shot coordinates and expected goals

Casting the nested shot record changes X, Y, and xG from VARCHAR to DOUBLE. The flattened view can then aggregate xG numerically, producing team totals such as Manchester City at 45.66 for season 2022.

How DuckDB in Action covers it

liveBook manning.com

Read DuckDB in Action on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

Modern C, Third Editiondouble is a C floating-point type providing at least the precision and range required for double-precision real-number calculations.
liveBook manning.com

100 Java Mistakes and How to Avoid Them
liveBook manning.com

Pandas Workout: 200 exercises to make you a stronger data analystfloat64 is a 64-bit floating-point data type commonly used as the default numeric precision for pandas columns.
liveBook manning.com

ScyllaDB in ActionDOUBLE is a ScyllaDB floating-point data type for storing double-precision numeric values.
liveBook manning.com

100 Go Mistakes and How to Avoid Themfloat64 is Go's 64-bit floating-point type with an 11-bit exponent, a 52-bit mantissa, and a sign bit.
liveBook manning.com

Deep Learning with JAXA 64-bit floating-point numeric type used as a higher-precision array data type in numerical computing.

Compare how 7 books explain float64 →

Related concepts

floating-point arithmetickind of · Floating-point arithmetic is computation using finite-precision representations of real numbers, in which rounding and limited range can make results differ from exact real-number arithmetic.
IEEE 754implements · IEEE 754 is an international standard specifying floating-point formats, arithmetic operations, rounding rules, and exceptional values.
FP32alternative to · FP32 is the IEEE 754 binary32 single-precision floating-point format, which represents approximate real numbers using 32 bits.
data conversionproduced by · Data conversion is the transformation of a value or data from one type, format, or representation to another, explicitly or implicitly.
float16alternative to · Float16 is a 16-bit floating-point numeric format that represents values with less precision and storage than single-precision formats such as float32.

This explainer was generated by Manning's knowledge graph from the text of DuckDB in Action. The section links point to the parts of the book it draws on.