Create managed hive tables for retail-db tables

hive-retail_db.scala

//Data can be found at https://github.com/mannharleen/data/blob/master/retail_db.zip

hiveContext.sql("create database retail_db")
hiveContext.sql("use retail_db")

hiveContext.sql("create table categories (category_id Int,category_department_id Int, category_name String) row format delimited fields terminated by ',' ")
hiveContext.sql("create table departments (department_id Int, department_name String) row format delimited fields terminated by ',' ")
hiveContext.sql("create table products (product_id Int, product_category_id Int, product_name String, product_description String, product_price Double, product_image String) row format delimited fields terminated by ',' ")
hiveContext.sql("create table order_items (order_item_id Int, order_item_order_id Int, order_item_product_id Int, order_item_quantity Int, order_item_subtotal Double, order_item_product_price Double) row format delimited fields terminated by ',' ")
hiveContext.sql("create table orders (order_id Int, order_date String, order_customer_id Int, order_status String) row format delimited fields terminated by ',' ")

hiveContext.sql("load data local inpath 'D:\\OneDrive - Parkway Pantai\\BIG DATA\\data\\retail_db\\categories' into table categories")
hiveContext.sql("load data local inpath 'D:\\OneDrive - Parkway Pantai\\BIG DATA\\data\\retail_db\\departments' into table departments")
hiveContext.sql("load data local inpath 'D:\\OneDrive - Parkway Pantai\\BIG DATA\\data\\retail_db\\products' into table products")
hiveContext.sql("load data local inpath 'D:\\OneDrive - Parkway Pantai\\BIG DATA\\data\\retail_db\\order_items' into table order_items")
hiveContext.sql("load data local inpath 'D:\\OneDrive - Parkway Pantai\\BIG DATA\\data\\retail_db\\orders' into table orders")