Create external Impala table partitioned by a certain column and recover old partitions of the same table

create-external-table-with-partitions.sh

# The following example is for a job that produces daily, parquets partitioned by 'day' column
DB="database"
BASE_DIR="/output/parquets"
TBL="${DB}.table"       # name of the impala table
PQT="${BASE_DIR}/day"   # name of the parent directory containing output-subdirectories (in the format 'day=ddMMyyy')

# create/mount impala table
impala-shell -q "drop table if exists $TBL;
create external table $TBL (
account_id string,
vehicle_id string,
start_time string)
partitioned by (day int)
stored as parquet
location '$PQT';" ${impala_args}
impala-shell -q "ALTER TABLE $TBL RECOVER PARTITIONS;" ${impala_args}
impala-shell -q "Invalidate Metadata $TBL;" ${impala_args}