dim_category_mv_new.sql 426 Bytes
Newer Older
wang-jinfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13
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';