blob: e1231940a243e7d7cec41196f67fc32cc5ce33ad [file] [log] [blame]
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;