CREATE EXTERNAL TABLE `dim_category_mv_new`( `id` string , `store` string, `mv_first_tag` string , `mv_second_tag` string , `tag_url` string , `tag_code` string , `new_first_tag_1` string , `new_second_tag_1` string , `new_first_tag_2` string , `new_second_tag_2` string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' location 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/dim_category_mv_new';