loadDataHiveTables.sql

LOAD DATA LOCAL INPATH ‘/retail_demo/orders/orders.tsv.gz’ OVERWRITE INTO TABLE retail_demo.orders_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/products_dim/products_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.products_dim_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/categories_dim/categories_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.categories_dim_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/email_addresses_dim/email_addresses_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.email_addresses_dim_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/date_dim/date_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.date_dim_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/customers_dim/customers_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.customers_dim_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/payment_methods/payment_methods.tsv.gz’ OVERWRITE INTO TABLE retail_demo.payment_methods_hive;
LOAD DATA LOCAL INPATH ‘/retail_demo/customer_addresses_dim/customer_addresses_dim.tsv.gz’ OVERWRITE INTO TABLE retail_demo.customer_addresses_dim_hive;