hive Table Creation Script with sample data Floating Point Numeric Types
Example
CREATE TABLE all_floating_numeric_types(
c_float float,
c_double double
);
Minimum and maximum data values:
insert into all_floating_numeric_types values (-3.4028235E38,-1.7976931348623157E308);
insert into all_floating_numeric_types values (-1.4E-45,-4.9E-324);
insert into all_floating_numeric_types values (1.4E-45,4.9E-324);
insert into all_floating_numeric_types values (3.4028235E38,1.7976931348623157E308);
