hive-testbench/ddl-tpcds/text/inventory.sql

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

drop table if exists inventory;

create external table inventory
(
    inv_date_sk			int,
    inv_item_sk			int,
    inv_warehouse_sk		int,
    inv_quantity_on_hand	int
)
row format delimited fields terminated by '|' 
location '${LOCATION}';