愿意的在下面留言，本帖禁水

。。

,,,,,

,,,,,

麻烦楼主说下图片小编要求，以及福利

水

啦啦啦

啦啦啦

啦啦啦

吧啦

这里

关注9晨9吧，更多精彩等着你

呵多多关注我请点http://shop114014436.taobao.com

楼主还在吗

with temp_1 as(select TRUNC(CREATED_AT) DA,
SUM(case when RECHARGE_CHANNEL = 'TENPAY_REALTIME1' then AMOUNT else 0 end) AMT1,
SUM(case when RECHARGE_CHANNEL = 'TENPAY_REALTIME' then AMOUNT else 0 end) AMT4,
SUM(case when RECHARGE_CHANNEL = 'ALLINPAY_REALTIME' then AMOUNT else 0 end) AMT7,
SUM(case when RECHARGE_CHANNEL = 'PAF' then AMOUNT else 0 end) AMT8,
SUM(case when RECHARGE_CHANNEL = 'PAF_REALTIME' then AMOUNT else 0 end) AMT9,
SUM(case when RECHARGE_CHANNEL = 'CCBDR_REALTIME' then AMOUNT else 0 end) AMT10,
SUM(case when RECHARGE_CHANNEL = 'CCB' then AMOUNT else 0 end) AMT11,
SUM(case when RECHARGE_CHANNEL = 'ICBC_REALTIME' then AMOUNT else 0 end) AMT12,
SUM(case when RECHARGE_CHANNEL = 'UMBPAY_REALTIME' then AMOUNT else 0 end) AMT13
from ODL.CMN_RECHARGE_RECORDS
where TRUNC(CREATED_AT) >= date '2014-9-1'
and RECHARGE_TYPE <> 'VERIFICATION_FEE'
and STATUS = 'SUCCESS'
group by TRUNC(CREATED_AT)
),
TEMP_2 as(select TRUNC(CREATED_AT) DA,
SUM(case when WITHDRAW_CHANNEL = 'TENPAY_PAYING_2' then AMOUNT else 0 end) AMT2,
SUM(case when WITHDRAW_CHANNEL = 'TENPAY' then AMOUNT else 0 end) AMT3,
SUM(case when WITHDRAW_CHANNEL = 'ALLINPAY_REALTIME_PAYING' then AMOUNT else 0 end) AMT5,
SUM(case when WITHDRAW_CHANNEL = 'ALLINPAY' then AMOUNT else 0 end) AMT6,
SUM(case when WITHDRAW_CHANNEL = 'PAF' then AMOUNT else 0 end) AMT8,
SUM(case when WITHDRAW_CHANNEL = 'PAF_REALTIME' then AMOUNT else 0 end) AMT9,
SUM(case when WITHDRAW_CHANNEL = 'CCBDR_REALTIME' then AMOUNT else 0 end) AMT10,
SUM(case when WITHDRAW_CHANNEL = 'ICBC_REALTIME' then AMOUNT else 0 end) AMT12,
SUM(case when WITHDRAW_CHANNEL = 'UMBPAY_REALTIME' then AMOUNT else 0 end) AMT13
from ODL.CMN_WITHDRAW_RECORDS
where TRUNC(CREATED_AT) >= date '2014-9-1'
-- and RECHARGE_TYPE <> 'VERIFICATION_FEE'
and STATUS = 'SUCCESS'
group by TRUNC(CREATED_AT)
)select T1.DA,
T1.AMT1,
T2.AMT2,
T2.AMT3,
T1.AMT4,
T2.AMT5,
T2.AMT6,
T1.AMT7,
NVL(T1.AMT8,0) + NVL(T2.AMT8,0) AMT8,
NVL(T1.AMT9,0) + NVL(T2.AMT9,0) AMT9,
NVL(T1.AMT10,0) + NVL(T2.AMT10,0) AMT10,
t1.amt11,
NVL(T1.AMT12,0) + NVL(T2.AMT12,0) AMT12,
NVL(T1.AMT13,0) + NVL(T2.AMT13,0) AMT13
from TEMP_1 T1
left join TEMP_2 t2 on (t1.da = t2.da)

rdldata/ddl/table/R_USER_MODEL_RESULT.sql
idl/ddl/table/CRM_BEHAVIORS_20150419_DATAHOUSE-434.sql
idl/ddl/table/CRM_CAPITALS_20150419_DATAHOUSE-434.sql
adl/ddl/table/CRM_USER_PROFILE_20150417_DATAHOUSE-434.sql
adl/ddl/table/CRM_USER_PROFILE_EX_20150417_DATAHOUSE-434.sql
etl/ddl/procudere/P_CRM_BEHAVIORS_JOB.sql
etl/ddl/procudere/P_CRM_CAPITALS_JOB.sql
etl/ddl/procudere/P_ADL_CRM_USER_PROFILE_JOB.sql
adl/ddl/materialized_view/CRM_USER_PROFILE_VIEW_20150419_DATAHOUSER-434.sql
adl/ddl/view/CRM_USER_PROFILE_VIEW.sql

select 'select count(1) from '||to_table_name||' where trunc('||refresh_column||') <= date ''2015-4-21'''||
'minus select count(1) from '||from_table_name||' where trunc('||refresh_column||') <= date ''2015-4-21'';'
from etl_pdi_driver_table
where import_direction = 'O2O'

grant select,update,delete on rdldata.R_USER_MODEL_RESULT to etl,rdlopr;
grant select on rdldata.R_USER_MODEL_RESULT to adl;
comment on column R_USER_MODEL_RESULT.STAT_DATE is '统计时间';
comment on column R_USER_MODEL_RESULT.USER_ID is '用户ID';
comment on column R_USER_MODEL_RESULT.SCORE is '模型分数';
comment on column R_USER_MODEL_RESULT.MODEL_NAME is '模型名称';
comment on column R_USER_MODEL_RESULT.DW_CREATED_AT is '创建人';
comment on column R_USER_MODEL_RESULT.DW_CREATED_BY is '创建时间';
comment on column R_USER_MODEL_RESULT.DW_UPDATED_AT is '修改人';
comment on column r_user_model_result.dw_updated_by is '修改时间';

h