hive Table Creation Script with sample data Numeric Types
Example
CREATE TABLE all_numeric_types(
c_tinyint tinyint,
c_smallint smallint,
c_int int,
c_bigint bigint,
c_decimal decimal(38,3)
);
Minimum and maximum data values:
insert into all_numeric_types values (-128,-32768,-2147483648,-9223372036854775808,-99999999999999999999999999999999999.999);
insert into all_numeric_types values (127,32767,2147483647,9223372036854775807,99999999999999999999999999999999999.999);
