#!/usr/sh

sqoop export --connect "jdbc:mysql://dataplatform-app-tag.c5yzcdreb1xr.us-east-1.rds.amazonaws.com:3306/app_tag?useUnicode=true&characterEncoding=utf-8" \
  --username apptag_rw --password 7gyLEVtkER3u8c9 --table tag_list --columns "package_name,app_name,platform,url,category,install" \
  --export-dir s3://mob-emr-test/dataplatform/DataWareHouse/dwh.db/package_list --input-fields-terminated-by '\001' --update-mode allowinsert --update-key package_name

hive -e "USE dwh;DROP TABLE IF EXISTS package_num;"

hive -e "USE dwh;DROP TABLE IF EXISTS package_info;"

hive -e "USE dwh;DROP TABLE IF EXISTS package_list;"