catalog_page.sql 688 B

123456789101112131415161718
  1. create database if not exists ${DB};
  2. use ${DB};
  3. drop table if exists catalog_page;
  4. create external table catalog_page(
  5. cp_catalog_page_sk int
  6. , cp_catalog_page_id string
  7. , cp_start_date_sk int
  8. , cp_end_date_sk int
  9. , cp_department string
  10. , cp_catalog_number int
  11. , cp_catalog_page_number int
  12. , cp_description string
  13. , cp_type string
  14. )
  15. row format delimited fields terminated by '|'
  16. location '${LOCATION}';