part.sql 234 B

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