How to get first day of quarter in hive? select add_months(trunc(‘2020-10-01′,’MM’),-(month(‘2020-10-01’)-1)%3)
hive
How to return closest Monday date before, when date is given? It is very simple, user next_day and date_add funtions select next_day(date_add(‘YOUR_DATE’,-7),’MONDAY’) Check — first next Monday od selected date select next_day(‘2020-10-21’, ‘MONDAY’); — returns closest Monday date before select next_day(date_add(‘2020-11-15′,-7),’MONDAY’) select next_day(date_add(‘2020-11-16′,-7),’MONDAY’) select next_day(date_add(‘2020-11-17′,-7),’MONDAY’) select next_day(date_add(‘2020-11-18′,-7),’MONDAY’) select next_day(date_add(‘2020-11-19′,-7),’MONDAY’) select […]
select slot, collect_set(size) from (select slot, size, count(d_date_id) as cnt from xxx.table1 where dt >= 20200601 group by slot, size ) x group by slot ;
alter table table_name change column column_name column_name column_name_type after column_name2; https://community.cloudera.com/t5/Support-Questions/How-can-we-change-the-column-order-in-Hive-table-without/td-p/89495