python
#取本月
today = datetime.datetime.now()
today = today.strftime("%Y%m")
#取上个月
today = datetime.date.today()
first = today.replace(day=1)
last_month = first - datetime.timedelta(days=1)
last_month = last_month.strftime("%Y%m"))
使用:字符串拼接使用 t_data_szlc_"""+today+"""
shell
#!/bin/bash
if [ $1 == '70001' ];
then xxx
fi
sqoop 从mysql同步数据到hive
sqoop import -D mapred.job.queue.name=root.hive4 --connect jdbc:mysql://ip:3306/db_v8source?tinyInt1isBit=false\&zeroDateTimeBehavior=convertToNull\&autoReconnect=true\&useUnicode=true\&characterEncoding=utf8 --username xx --password xx --columns "id,supplier_id,real_supplier_id,supplier_name,file_prefix,old_file,new_file,file_time,file_size,record_num,csv_num,hive_num,created_time,sys_auto_update_time" --where "1=1" --table 't_op_log' --hive-overwrite -m 1 --fields-terminated-by '\t' --hive-import --hive-table db_product_hive_monitor.t_op_log --hive-drop-import-delims --delete-target-dir