hive Table Creation Script with sample data Date and Timestamp types


Example

CREATE TABLE all_datetime_types(
  c_date date, 
  c_timestamp timestamp
);

Minimum and maximum data values:

insert into all_datetime_types values ('0001-01-01','0001-01-01 00:00:00.000000001');
insert into all_datetime_types values ('9999-12-31','9999-12-31 23:59:59.999999999');