01 2014 档案
摘要:#coding:utf-8#!/usr/bin/pythonimport cx_Oracleimport sysimport os m=sys.argv[1]sql="select a.mobile,b.city_name from (select mobile,city_id from dw_cmmb_user_"+m+" where show_flag=1 group by mobile,city_id) a, (select * from dim_areacode where province_id=551) b where a.city_id=b.city
阅读全文
摘要:hadoop 19252 19251 0 05:00 ? 00:00:00 /bin/sh -c (sh /home/hadoop/src/renow_hive_second.sh >> /home/hadoop/src/log/renow_hive_second.log )hadoop 19253 19252 0 05:00 ? 00:00:01 sh /home/hadoop/src/renow_hive_second.shhadoop 20510 19253 0 05:09 ? 00:00:58 /apps/usr/java/jdk1.6/bin/java -Dproc_ja
阅读全文
摘要:#!/usr/bin/env python #coding: utf-8 import smtplib from email.mime.multipart import MIMEMultipart from email.mime.text import MIMEText #import stmp_mail sender = 'hadoop520@126.com' receiver ='hello@126.com'subject = '数据测试' smtpserver = 'smtp.126.com' username = '
阅读全文