hive-testbench/ddl-tpch/bin_partitioned/region.sql

create database if not exists ${DB};
use ${DB};

drop table if exists region;

create table region
stored as ${FILE}
TBLPROPERTIES('orc.bloom.filter.columns'='*','orc.compress'='ZLIB')
as select distinct * from ${SOURCE}.region;