Mysql to Impala tpc.org 1gb test dataset

_ create db _

create database if not exists edw_tpcds 
comment "This is TPC ds 1GB for benchmark" 
location '/user/hive/warehouse/edw_tpcds.db' ;

_ all tables that don't need column type remapping _

 sqoop import-all-tables -connect jdbc:mysql://aly1.50easy.com:3306/edw_tpcds?useSSL=false      --driver com.mysql.jdbc.Driver --username edw_tpcds --password edw_tpcds      --hive-import --hive-overwrite --as-parquetfile --num-mappers 1       --hive-database edw_tpcds      --exclude-tables           call_center,catalog_returns,catalog_sales,customer_address,date_dim,item,promotion,store,store_returns,store_sales,warehouse,web_returns,web_sales,web_site