dim_category_mv_new.sql

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';