Uncategorized HIVE – How to rename table by token|Published February 7, 2020 To change table name in HIVE use code listed below: ALTER TABLE table_name RENAME TO new_table_name;
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 April 26, 2021 How to edit Tableau Server extract? Local copy existing extractUse local copy source Close old extract (optional)Edit data source based on local copy
Published January 22, 2020 String to map key-value in HIVE select str_to_map(column,’,’,’:’) from table ;