hive HIVE – first date in quarter from date by token|Published November 23, 2020-Updated November 23, 2020 How to get first day of quarter in hive? select add_months(trunc('2020-10-01','MM'),-(month('2020-10-01')-1)%3)
Published November 20, 2020 HIVE – return closest Monday before date 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’) […]
Published July 30, 2020 HIVE Collect_Set and Colect_list 1 comment 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 […]
Published February 20, 2020 HIVE – change column order 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