建表的时候明明建 分区了
在 ACCT_ITEM_MONTH 字段上建立的
MON01 '01'
MON02 '02'
MON03 '03'
MON04 '04'
MON05 '05'
MON06 '06'
MON07 '07'
MON08 '08'
MON09 '09'
MON10 '10'
MON11 '11'
MON12 '12'
INSERT INTO DA.TAUA_MPOP_STOCK_MON PARTITION(MON03)
(TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE,
USE_NUM,
CDR_INCOME,
ETL_CYCLE_ID,
ETL_TIME)
SELECT TIME_CD, --ê±??±à??
ACCT_ITEM_MONTH, --?ê????·Y
STD_AREA_ID, --±ê×?μ???±êê?
STD_BRAND_CD, --?·??±êê?
CT_CUST_TYPE_CD, --±ê×??ˉí??í?§ààDí±à??
STD_SP_CORP_CD, --±ê×?SP1???CD′ú??
BUSINESS_TYPE, --òμ??ààDí
SUM(USE_NUM), --ê1ó?ó??§êy
SUM(CDR_INCOME), --??·??êμ¥ê?è?
200903,
SYSDATE
FROM TMPTAB.TMP_TAUA_C_023_200903_27_B
GROUP BY TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE
在 ACCT_ITEM_MONTH 字段上建立的
MON01 '01'
MON02 '02'
MON03 '03'
MON04 '04'
MON05 '05'
MON06 '06'
MON07 '07'
MON08 '08'
MON09 '09'
MON10 '10'
MON11 '11'
MON12 '12'
INSERT INTO DA.TAUA_MPOP_STOCK_MON PARTITION(MON03)
(TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE,
USE_NUM,
CDR_INCOME,
ETL_CYCLE_ID,
ETL_TIME)
SELECT TIME_CD, --ê±??±à??
ACCT_ITEM_MONTH, --?ê????·Y
STD_AREA_ID, --±ê×?μ???±êê?
STD_BRAND_CD, --?·??±êê?
CT_CUST_TYPE_CD, --±ê×??ˉí??í?§ààDí±à??
STD_SP_CORP_CD, --±ê×?SP1???CD′ú??
BUSINESS_TYPE, --òμ??ààDí
SUM(USE_NUM), --ê1ó?ó??§êy
SUM(CDR_INCOME), --??·??êμ¥ê?è?
200903,
SYSDATE
FROM TMPTAB.TMP_TAUA_C_023_200903_27_B
GROUP BY TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE
改成下面的语句试一下:
INSERT INTO DA.TAUA_MPOP_STOCK_MON
(TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE,
USE_NUM,
CDR_INCOME,
ETL_CYCLE_ID,
ETL_TIME,
ACCT_ITEM_MONTH)
SELECT TIME_CD, --ê±??±à??
ACCT_ITEM_MONTH, --?ê????·Y
STD_AREA_ID, --±ê×?μ???±êê?
STD_BRAND_CD, --?·??±êê?
CT_CUST_TYPE_CD, --±ê×??ˉí??í?§ààDí±à??
STD_SP_CORP_CD, --±ê×?SP1???CD′ú??
BUSINESS_TYPE, --òμ??ààDí
SUM(USE_NUM), --ê1ó?ó??§êy
SUM(CDR_INCOME), --??·??êμ¥ê?è?
200903,
SYSDATE,
to_char(sysdate,'dd')
FROM TMPTAB.TMP_TAUA_C_023_200903_27_B
GROUP BY TIME_CD,
ACCT_ITEM_MONTH,
STD_AREA_ID,
STD_BRAND_CD,
CT_CUST_TYPE_CD,
STD_SP_CORP_CD,
BUSINESS_TYPE