hive work flow

List up status for all the 400 tables in CATS project.

• table name
• location (s3 path)
• Store type (TXT / ORC)
• partition used
• partition number
• if or not in the list of (Tables with too many Paritions)
• if or not managed table
• count(*)

Goal: improve count(*) / aggreation functions' performance

CREATE TABLE source_table_1_managed
AS select * from source_table_1 

CREATE TABLE source_table_1_orc
    STORED AS ORC
AS select * from source_table_1 

CREATE EXTERNAL TABLE source_table_1_orc
    STORED AS ORC
AS select * from source_table_1 

TBD