A 4-byte (single precision) floating-point data type used in CREATE TABLE and ALTER TABLE statements.

Range: 1.40129846432481707e-45 .. 3.40282346638528860e+38, positive or negative

Conversions: Impala automatically converts FLOAT to more precise DOUBLE values, but not the other way around. You can use CAST() to convert FLOAT values to TINYINT, SMALLINT, INT, BIGINT, STRING, TIMESTAMP, or BOOLEAN. You can use exponential notation in FLOAT literals or when casting from STRING, for example 1.0e6 to represent one million.

Examples:

CREATE TABLE t1 (x FLOAT);
SELECT CAST(1000.5 AS FLOAT);

Related information: Literals, Mathematical Functions