create database test; CREATE TABLE `test.fake_dates`( `ab` date ) stored as ORC; CREATE TABLE `test.fake_dates_parquet`( `ab` date ) stored as PARQUET; ---- CREATE TABLE `test.fake_dates_SequenceFile`( `ab` date ) stored as SequenceFile; ---- CREATE TABLE `test.fake_dates_TextFile`( `ab` date ) stored as TextFile; insert overwrite table test.fake_dates values ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1890-01-01'), ('1901-01-01'), ('1900-01-01'); insert overwrite table test.fake_dates_parquet values ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1890-01-01'), ('1901-01-01'), ('1900-01-01'); insert overwrite table test.fake_dates_SequenceFile values ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1890-01-01'), ('1901-01-01'), ('1900-01-01'); insert overwrite table test.fake_dates_TextFile values ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1900-01-01'), ('1890-01-01'), ('1901-01-01'), ('1900-01-01'); select cast(ab as timestamp) from test.fake_dates; select cast(ab as timestamp) from test.fake_dates_parquet; select cast(ab as timestamp) from test.fake_dates_SequenceFile; select cast(ab as timestamp) from test.fake_dates_TextFile;