Uncategorized
8 posts
Local copy existing extractUse local copy source Close old extract (optional)Edit data source based on local copy
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