supplier.sql 261 B

1234567891011
  1. create database if not exists ${DB};
  2. use ${DB};
  3. drop table if exists supplier;
  4. create table supplier
  5. stored as ${FILE}
  6. TBLPROPERTIES('orc.bloom.filter.columns'='*','orc.compress'='ZLIB')
  7. as select * from ${SOURCE}.supplier
  8. cluster by s_nationkey, s_suppkey
  9. ;