hive='/usr/bin/hive'
hive_database='xxxxx'
field_segmentation=' 01'
external_storage_path='/user/hive/warehouse/xxx/odsxxx'
source_database='xxx'
source_username='xxx'
source_pwd='xxxx'
source_ip='xxx'
source_port='1521'
if [ -n "$1" ] ;then
do_day=$1
else
do_day=`date -d "-1 day" +%F`
fi
/usr/bin/sqoop import
--connect "jdbc:oracle:thin:@//$source_ip:$source_port/$source_database"
--username $source_username
--password $source_pwd
--query "select * from xxxx where $ConDITIONS "
--hive-delims-replacement '
'
--num-mappers 1
--fields-terminated-by $field_segmentation
--target-dir $external_storage_path/xxxxxxxx_tmp
--delete-target-dir
--null-string '\N'
--null-non-string '\N'
--hive-import
--hive-database $hive_database
--hive-table xxxxxx
--hive-overwrite
--hive-partition-key dt
--hive-partition-value $do_day
