!#/bin/bash


sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table employees --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table salaries --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table titles --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table dept_manager --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table dept_emp --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table dept_emp_latest_date --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table departments --fields-terminated-by ',' -username=root -password=cloudera;
sqoop create-hive-table --connect jdbc:mysql://quickstart:3306/employees --table current_dept_emp --fields-terminated-by ',' -username=root -password=cloudera;