income_band.sql 338 B

123456789101112
  1. create database if not exists ${DB};
  2. use ${DB};
  3. drop table if exists income_band;
  4. create external table income_band(
  5. ib_income_band_sk int
  6. , ib_lower_bound int
  7. , ib_upper_bound int
  8. )
  9. row format delimited fields terminated by '|'
  10. location '${LOCATION}';