Local copy existing extractUse local copy source Close old extract (optional)Edit data source based on local copy
Uncategorized
7 posts
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 location ‘s3://YOUR_NEW_S3_LOCATION’;
To change table name in HIVE use code listed below: ALTER TABLE table_name RENAME TO new_table_name;
select str_to_map(column,’,’,’:’) from table ;
https://www.wikihow.com/Use-Windows-Command-Prompt-to-Run-a-Python-File