drop table dim_manual_appid_package; CREATE EXTERNAL TABLE `dim_manual_appid_package`( appid string, package_name string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/dim_manual_appid_package';