| create or replace view hive1_parquet_v2 as select voter_id, name, age, registration, contributions, voterzone, convert_from(create_timestamp1, 'TIMESTAMP_IMPALA') create_timestamp1,convert_from(create_timestamp2, 'TIMESTAMP_IMPALA') create_timestamp2,create_date from hive1_parquet; | |
| select date_trunc('month',create_timestamp2), count(*) from hive1_parquet_v2 group by date_trunc('month',create_timestamp2) order by count(*); | |
| drop view hive1_parquet_v2; |