HIVE-DDL-retail_db.txt

retail_db tables
================
CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.categories (
  category_id int,
  category_department_id int,
  category_name string
) 
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/categories'


CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.customers (
  customer_id int,
  customer_fname string,
  customer_lname string,
  customer_email string,
  customer_password string,
  customer_street string,
  customer_city string,
  customer_state string,
  customer_zipcode string
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/customers'



CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.departments (
  department_id int,
  department_name string
 )
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/departments'



CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.order_items (
  order_item_id int,
  order_item_order_id int,
  order_item_product_id int,
  order_item_quantity int,
  order_item_subtotal float ,
  order_item_product_price float
 ) 
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/order_items'



CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.orders (
  order_id int,
  order_date date,
  order_customer_id int,
  order_status string
  ) 
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/orders'



CREATE EXTERNAL TABLE IF NOT EXISTS retail_db.products (
  product_id int,
  product_category_id int,
  product_name string,
  product_description string,
  product_price float ,
  product_image string
) 
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/cloudera/ashish/Sqoop/retail_db/products'