Uncategorized String to map key-value in HIVE by token|Published January 22, 2020-Updated January 22, 2020 select str_to_map(column,’,’,’:’) from table ;
Published April 21, 2021 [AWS Athena] Set new data location on S3 How to set other data location on s3? Just use ALTER TABLE. The example code is losted here: alter table d_ppo_category_pc_mapping set […]
Published February 7, 2020 HIVE – How to rename table To change table name in HIVE use code listed below: ALTER TABLE table_name RENAME TO new_table_name;