select date_part('year', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')), date_part('month', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')),date_part('day', convert_from(create_timestamp1,'TIMESTAMP_IMPALA')) from hive1_parquet where voter_id=5; |