摘要： #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 阅读全文