blob: e330eb39ee94dcac33431e16f501598a10be6089 [file] [log] [blame]
alter session set `store.parquet.reader.int96_as_timestamp`=true;
create or replace view hive1_parquet_v3 as select voter_id, name, age, registration, contributions, voterzone, create_timestamp1,create_timestamp2,create_date from hive1_parquet;
select voter_id, date_part('month',create_timestamp1), date_part('month',create_timestamp2) from hive1_parquet_v3 order by voter_id limit 5;
drop view hive1_parquet_v3;
alter session set `store.parquet.reader.int96_as_timestamp`=false;