blob: 3487a64e76cd475d9f897ab679cd970984db1bfe [file] [log] [blame]
select date_trunc('year', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')), date_trunc('month', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')),date_trunc('day', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')) from hive1_parquet where voter_id=5;