household_demographics.sql 392 B

123456789101112131415
  1. create database if not exists ${DB};
  2. use ${DB};
  3. drop table if exists household_demographics;
  4. create external table household_demographics
  5. (
  6. hd_demo_sk int,
  7. hd_income_band_sk int,
  8. hd_buy_potential string,
  9. hd_dep_count int,
  10. hd_vehicle_count int
  11. )
  12. row format delimited fields terminated by '|'
  13. location '${LOCATION}';