为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
no writable spill storage directories
监控显示spill空间比较充足
sql spill只有几百兆, 没有特别大数据量的spill
这种问题之前也出现过, 不是磁盘空间不足的问题
/*"sqlId" = '1731276559880-iszv',"taskType" = 'persistTableTask',"tag" = 'CIKMx8PGgk-1F3LNN',"fabric-jobId" = '18ced0f0-0004-cb65-8044-de0c7caf1b00',"set_var.pipeline_dop" = '2'*/ INSERT /*+ SET_VAR("pipeline_dop"= '2') */ INTO `cubeappdata`.`_tmp_1731276559241__persist_COLLECTION_CIKMx8PGgk` (`nbdh_Hfy`, `crkdh_R4U`, `ddbi_4T0`, `xsdh_s9u`, `wsddh_efh`, `xdsj_Ixe`, `fksj_Wo3`, `yfje_80S`, `sjzfje_yqT`, `ddje_tqC`, `yf_LYj`, `mjyf_YJT`, `yhje_3wh`, `ptddztmc_xmg`, `dpbh_USZ`, `dpmc_cj8`, `mjnc_K50`, `dqgj_ZVw`, `gj_Gbx`, `dqs_Pce`, `ycs_bpr`, `dqs1_OZ8`, `dqq_83y`, `ycq_v5a`, `fhrq_k70`, `mjly_ad3`, `mjbz_y5q`, `ddlx_bLw`, `fcbh_I1U`, `wlgsmc_KWv`, `wldh_b3n`, `yfcb_1k7`, `sczl_4a7`, `fxsbh_PdJ`, `dbq_GUP`, `ddcjsj_q5H`, `xxbz_XvE`, `yb_cvp`, `wldw_Rk1`, `dpqd_fgX`, `xymjdh_J2C`, `ckdh_Lww`, `dcmc_5Ua`, `ckmc_UUK`, `gzrq_dCa`, `gzsj_RZM`, `spslzb_s1E`, `ddlxz_FNg`, `thwlgs_mXd`, `thwldh_6F3`, `wbxsddh_6Oj`, `nbzdh_7hf`, `hpbi_ufV`, `xszdh_k7D`, `ysxsdh_fbO`, `shddh_f5F`, `spsl_xZ3`, `dj_VRM`, `spyfje_Q18`, `zje_T5A`, `hpdh_4qV`, `spmc_jui`, `sfzp_Knh`, `spyzhzbm_dwi`, `tctxm_T6O`, `spbz_YgB`, `tkztmc_Vre`, `tkdh_T4u`, `spzt_USn`, `spztmc_SE4`, `spi_WBJ`, `xsspbm_bhM`, `skuid_a7F`, `rksj_wzh`, `sftc_Qoo`, `tcsl_tJx`, `tcspzs_IbI`, `yhje1_sxe`, `mjyf1_3Jz`, `cjje_aZg`, `ssje_0pn`, `xscb_YZ4`, `lsdj_Gmj`, `zscgj_JCe`, `sjbm_oe0`, `shdh_Q1U`, `ysjbm_bxJ`, `pttctm_91U`, `ddlxc_fAs`, `ycjje_lzg`, `yykhz_7mS`, `cpkhz_IAc`, `mxdpbh_2kr`, `fhrqfy_11B`, `yykhzfy_lLh`, `cpkhzfy_vIG`, `czf1_AIf`, `bcf1_UU5`, `kdf1_Bdz`, `ztc1_IOY`, `tgf1_Tu9`, `ztchxk_Q6C`, `tgfhxk_Myq`, `ptfyl_VWf`, `ptf1_Fs1`, `ptkdbl_qMz`, `ptkd_nrn`, `hxje1_wXk`, `xthpbigs_Tu5`, `ccxtdh_jF1`, `ccftbl_g13`, `djftbl_60g`, `zlftbl_d7v`, `fkrq_Xyb_KWA`, `yxdd_55d_2wd_RwZ_yDv`, `yxddfy_mmu_U2d`) (SELECT `nbdh` AS `nbdh_Hfy`, `crkdh` AS `crkdh_R4U`, `ddbi` AS `ddbi_4T0`, `xsdh` AS `xsdh_s9u`, `wsddh` AS `wsddh_efh`, `xdsj` AS `xdsj_Ixe`, `fksj` AS `fksj_Wo3`, `yfje` AS `yfje_80S`, `sjzfje` AS `sjzfje_yqT`, `ddje` AS `ddje_tqC`, `yf` AS `yf_LYj`, `mjyf` AS `mjyf_YJT`, `yhje` AS `yhje_3wh`, `ptddztmc` AS `ptddztmc_xmg`, `dpbh` AS `dpbh_USZ`, `dpmc` AS `dpmc_cj8`, `mjnc` AS `mjnc_K50`, `dqgj` AS `dqgj_ZVw`, `gj` AS `gj_Gbx`, `dqs` AS `dqs_Pce`, `ycs` AS `ycs_bpr`, `dqs1` AS `dqs1_OZ8`, `dqq` AS `dqq_83y`, `ycq` AS `ycq_v5a`, `fhrq` AS `fhrq_k70`, `mjly` AS `mjly_ad3`, `mjbz` AS `mjbz_y5q`, `ddlx` AS `ddlx_bLw`, `fcbh` AS `fcbh_I1U`, `wlgsmc` AS `wlgsmc_KWv`, `wldh` AS `wldh_b3n`, `yfcb` AS `yfcb_1k7`, `sczl` AS `sczl_4a7`, `fxsbh` AS `fxsbh_PdJ`, `dbq` AS `dbq_GUP`, `ddcjsj` AS `ddcjsj_q5H`, `xxbz` AS `xxbz_XvE`, `yb` AS `yb_cvp`, `wldw` AS `wldw_Rk1`, `dpqd` AS `dpqd_fgX`, `xymjdh` AS `xymjdh_J2C`, `ckdh` AS `ckdh_Lww`, `dcmc` AS `dcmc_5Ua`, `ckmc` AS `ckmc_UUK`, `gzrq` AS `gzrq_dCa`, `gzsj` AS `gzsj_RZM`, `spslzb` AS `spslzb_s1E`, `ddlxz` AS `ddlxz_FNg`, `thwlgs` AS `thwlgs_mXd`, `thwldh` AS `thwldh_6F3`, `wbxsddh` AS `wbxsddh_6Oj`, `nbzdh` AS `nbzdh_7hf`, `hpbi` AS `hpbi_ufV`, `xszdh` AS `xszdh_k7D`, `ysxsdh` AS `ysxsdh_fbO`, `shddh` AS `shddh_f5F`, `spsl` AS `spsl_xZ3`, `dj` AS `dj_VRM`, `spyfje` AS `spyfje_Q18`, `zje` AS `zje_T5A`, `hpdh` AS `hpdh_4qV`, `spmc` AS `spmc_jui`, `sfzp` AS `sfzp_Knh`, `spyzhzbm` AS `spyzhzbm_dwi`, `tctxm` AS `tctxm_T6O`, `spbz` AS `spbz_YgB`, `tkztmc` AS `tkztmc_Vre`, `tkdh` AS `tkdh_T4u`, `spzt` AS `spzt_USn`, `spztmc` AS `spztmc_SE4`, `spi` AS `spi_WBJ`, `xsspbm` AS `xsspbm_bhM`, `skuid` AS `skuid_a7F`, `rksj` AS `rksj_wzh`, `sftc` AS `sftc_Qoo`, `tcsl` AS `tcsl_tJx`, `tcspzs` AS `tcspzs_IbI`, `mxyhje` AS `yhje1_sxe`, `mxmjyf` AS `mjyf1_3Jz`, `cjje` AS `cjje_aZg`, `ssje` AS `ssje_0pn`, `xscb` AS `xscb_YZ4`, `lsdj` AS `lsdj_Gmj`, `zscgj` AS `zscgj_JCe`, `sjbm` AS `sjbm_oe0`, `shdh` AS `shdh_Q1U`, `ysjbm` AS `ysjbm_bxJ`, `pttctm` AS `pttctm_91U`, `ddlxc` AS `ddlxc_fAs`, `ycjje` AS `ycjje_lzg`, `yykhz` AS `yykhz_7mS`, `cpkhz` AS `cpkhz_IAc`, `mxdpbh` AS `mxdpbh_2kr`, `fhrqfy` AS `fhrqfy_11B`, `yykhzfy` AS `yykhzfy_lLh`, `cpkhzfy` AS `cpkhzfy_vIG`, `czf` AS `czf1_AIf`, `bcf` AS `bcf1_UU5`, `kdf` AS `kdf1_Bdz`, `ztc` AS `ztc1_IOY`, `tgf` AS `tgf1_Tu9`, `ztchxk` AS `ztchxk_Q6C`, `tgfhxk` AS `tgfhxk_Myq`, `ptfyl` AS `ptfyl_VWf`, `ptf` AS `ptf1_Fs1`, `ptkdbl` AS `ptkdbl_qMz`, `ptkd` AS `ptkd_nrn`, `hxje` AS `hxje1_wXk`, `xthpbigs` AS `xthpbigs_Tu5`, `ccxtdh` AS `ccxtdh_jF1`, `ccftbl` AS `ccftbl_g13`, `djftbl` AS `djftbl_60g`, `zlftbl` AS `zlftbl_d7v`, `fkrq` AS `fkrq_Xyb_KWA`, `yxdd` AS `yxdd_55d_2wd_RwZ_yDv`, `yxddfy` AS `yxddfy_mmu_U2d` FROM (SELECT `_persist_COLLECTION_T3cB1uU2Ny`.`nbdh_iff` AS `nbdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`crkdh_joI` AS `crkdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`xsdh_eV6` AS `xsdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`wsddh_QVT` AS `wsddh`, `_persist_COLLECTION_T3cB1uU2Ny`.`xdsj_qci` AS `xdsj`, `_persist_COLLECTION_T3cB1uU2Ny`.`fksj_vn0` AS `fksj`, `_persist_COLLECTION_T3cB1uU2Ny`.`yfje_wLX` AS `yfje`, `_persist_COLLECTION_T3cB1uU2Ny`.`sjzfje_Ntb` AS `sjzfje`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddje_XYs` AS `ddje`, `_persist_COLLECTION_T3cB1uU2Ny`.`yf_9CN` AS `yf`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjyf_q57` AS `mjyf`, `_persist_COLLECTION_T3cB1uU2Ny`.`yhje_yXA` AS `yhje`, `_persist_COLLECTION_T3cB1uU2Ny`.`ptddztmc_SEm` AS `ptddztmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpbh_j9N` AS `dpbh`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpmc_r7f` AS `dpmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjnc_6QD` AS `mjnc`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqgj_juU` AS `dqgj`, `_persist_COLLECTION_T3cB1uU2Ny`.`gj_HBy` AS `gj`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqs_VWh` AS `dqs`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycs_DGj` AS `ycs`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqs1_osd` AS `dqs1`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqq_sER` AS `dqq`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycq_Kfe` AS `ycq`, `_persist_COLLECTION_T3cB1uU2Ny`.`fhrq_xcK` AS `fhrq`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjly_61A` AS `mjly`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjbz_thu` AS `mjbz`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlx_Qr9` AS `ddlx`, `_persist_COLLECTION_T3cB1uU2Ny`.`fcbh_mZk` AS `fcbh`, `_persist_COLLECTION_T3cB1uU2Ny`.`wlgsmc_VpR` AS `wlgsmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`wldh_xWI` AS `wldh`, `_persist_COLLECTION_T3cB1uU2Ny`.`yfcb_EUi` AS `yfcb`, `_persist_COLLECTION_T3cB1uU2Ny`.`sczl_iqB` AS `sczl`, `_persist_COLLECTION_T3cB1uU2Ny`.`fxsbh_Mji` AS `fxsbh`, `_persist_COLLECTION_T3cB1uU2Ny`.`dbq_6d5` AS `dbq`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddcjsj_oFo` AS `ddcjsj`, `_persist_COLLECTION_T3cB1uU2Ny`.`xxbz_Mw1` AS `xxbz`, `_persist_COLLECTION_T3cB1uU2Ny`.`yb_Hym` AS `yb`, `_persist_COLLECTION_T3cB1uU2Ny`.`wldw_KqI` AS `wldw`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpqd_26x` AS `dpqd`, `_persist_COLLECTION_T3cB1uU2Ny`.`xymjdh_pSy` AS `xymjdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`ckdh_XaZ` AS `ckdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`dcmc_MxS` AS `dcmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`ckmc_9RB` AS `ckmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`gzrq_stO` AS `gzrq`, `_persist_COLLECTION_T3cB1uU2Ny`.`gzsj_D5w` AS `gzsj`, `_persist_COLLECTION_T3cB1uU2Ny`.`spslzb_5w0` AS `spslzb`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlxz_asj` AS `ddlxz`, `_persist_COLLECTION_T3cB1uU2Ny`.`thwlgs_IyF` AS `thwlgs`, `_persist_COLLECTION_T3cB1uU2Ny`.`thwldh_q7T` AS `thwldh`, `_persist_COLLECTION_T3cB1uU2Ny`.`wbxsddh_Pp1` AS `wbxsddh`, `_persist_COLLECTION_T3cB1uU2Ny`.`nbzdh_5Nx` AS `nbzdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`xszdh_00L` AS `xszdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`ysxsdh_L5l` AS `ysxsdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`shddh_DAA` AS `shddh`, `_persist_COLLECTION_T3cB1uU2Ny`.`spsl_Bts` AS `spsl`, `_persist_COLLECTION_T3cB1uU2Ny`.`dj_QXb` AS `dj`, `_persist_COLLECTION_T3cB1uU2Ny`.`spyfje_fNO` AS `spyfje`, `_persist_COLLECTION_T3cB1uU2Ny`.`zje_gu0` AS `zje`, `_persist_COLLECTION_T3cB1uU2Ny`.`hpdh_vUQ` AS `hpdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`spmc_3A2` AS `spmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`sfzp_mgI` AS `sfzp`, `_persist_COLLECTION_T3cB1uU2Ny`.`spyzhzbm_z9p` AS `spyzhzbm`, `_persist_COLLECTION_T3cB1uU2Ny`.`tctxm_A5C` AS `tctxm`, `_persist_COLLECTION_T3cB1uU2Ny`.`spbz_oTa` AS `spbz`, `_persist_COLLECTION_T3cB1uU2Ny`.`tkztmc_bOz` AS `tkztmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`tkdh_Uo6` AS `tkdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`spzt_smW` AS `spzt`, `_persist_COLLECTION_T3cB1uU2Ny`.`spztmc_wbw` AS `spztmc`, `_persist_COLLECTION_T3cB1uU2Ny`.`spi_ewl` AS `spi`, `_persist_COLLECTION_T3cB1uU2Ny`.`xsspbm_8Vt` AS `xsspbm`, `_persist_COLLECTION_T3cB1uU2Ny`.`skuid_d2u` AS `skuid`, `_persist_COLLECTION_T3cB1uU2Ny`.`rksj_qP2` AS `rksj`, `_persist_COLLECTION_T3cB1uU2Ny`.`sftc_bVP` AS `sftc`, `_persist_COLLECTION_T3cB1uU2Ny`.`tcsl_e1o` AS `tcsl`, `_persist_COLLECTION_T3cB1uU2Ny`.`tcspzs_njR` AS `tcspzs`, `_persist_COLLECTION_T3cB1uU2Ny`.`yhje1_0YU` AS `mxyhje`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjyf1_GQG` AS `mxmjyf`, `_persist_COLLECTION_T3cB1uU2Ny`.`cjje_cjP` AS `cjje`, `_persist_COLLECTION_T3cB1uU2Ny`.`ssje_aZ2` AS `ssje`, `_persist_COLLECTION_T3cB1uU2Ny`.`xscb_YX5` AS `xscb`, `_persist_COLLECTION_T3cB1uU2Ny`.`lsdj_bau` AS `lsdj`, `_persist_COLLECTION_T3cB1uU2Ny`.`zscgj_0gN` AS `zscgj`, `_persist_COLLECTION_T3cB1uU2Ny`.`sjbm_DCI` AS `sjbm`, `_persist_COLLECTION_T3cB1uU2Ny`.`shdh_CNm` AS `shdh`, `_persist_COLLECTION_T3cB1uU2Ny`.`ysjbm_a2t` AS `ysjbm`, `_persist_COLLECTION_T3cB1uU2Ny`.`pttctm_Mzu` AS `pttctm`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlxc_7lP` AS `ddlxc`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycjje_cbf` AS `ycjje`, `_persist_COLLECTION_T3cB1uU2Ny`.`yykhz_2QY` AS `yykhz`, `_persist_COLLECTION_T3cB1uU2Ny`.`cpkhz_4eq` AS `cpkhz`, `_persist_COLLECTION_T3cB1uU2Ny`.`mxdpbh_VIB` AS `mxdpbh`, CASE WHEN `_persist_COLLECTION_T3cB1uU2Ny`.`ddbi_iWs` IS NOT NULL THEN `_persist_COLLECTION_T3cB1uU2Ny`.`ddbi_iWs` ELSE `Table_DingDanFeiYongMingXi`.`ddbi_9et` END AS `ddbi`, CASE WHEN `_persist_COLLECTION_T3cB1uU2Ny`.`hpbi_C3s` IS NOT NULL THEN `_persist_COLLECTION_T3cB1uU2Ny`.`hpbi_C3s` ELSE `Table_DingDanFeiYongMingXi`.`hpbi_B3X` END AS `hpbi`, `_persist_COLLECTION_T3cB1uU2Ny`.`yxdd_55d_2wd_RwZ` AS `yxdd`, `Table_DingDanFeiYongMingXi`.`fhrqfy_Tsb` AS `fhrqfy`, `Table_DingDanFeiYongMingXi`.`fkrq_mMZ` AS `fkrq`, `Table_DingDanFeiYongMingXi`.`yykhzfy_Iyw` AS `yykhzfy`, `Table_DingDanFeiYongMingXi`.`cpkhzfy_7pM` AS `cpkhzfy`, `Table_DingDanFeiYongMingXi`.`czf_bBp` AS `czf`, `Table_DingDanFeiYongMingXi`.`bcf_x4I` AS `bcf`, `Table_DingDanFeiYongMingXi`.`kdf_uQa` AS `kdf`, `Table_DingDanFeiYongMingXi`.`ztc_o8m` AS `ztc`, `Table_DingDanFeiYongMingXi`.`tgf_AMo` AS `tgf`, `Table_DingDanFeiYongMingXi`.`ztchxk_dnY` AS `ztchxk`, `Table_DingDanFeiYongMingXi`.`tgfhxk_gKT` AS `tgfhxk`, `Table_DingDanFeiYongMingXi`.`ptfyl_swq` AS `ptfyl`, `Table_DingDanFeiYongMingXi`.`ptf_44s` AS `ptf`, `Table_DingDanFeiYongMingXi`.`ptkdbl_z1O` AS `ptkdbl`, `Table_DingDanFeiYongMingXi`.`ptkd_loW` AS `ptkd`, `Table_DingDanFeiYongMingXi`.`hxje_AdP` AS `hxje`, `Table_DingDanFeiYongMingXi`.`xthpbigs_yBH` AS `xthpbigs`, `Table_DingDanFeiYongMingXi`.`yxdd_z2Q` AS `yxddfy`, `Table_DingDanFeiYongMingXi`.`ccxtdh_aT3` AS `ccxtdh`, `Table_DingDanFeiYongMingXi`.`ccftbl_xA5` AS `ccftbl`, `Table_DingDanFeiYongMingXi`.`djftbl_2cu` AS `djftbl`, `Table_DingDanFeiYongMingXi`.`zlftbl_un6` AS `zlftbl` FROM ((SELECT `nbdh_iff` AS `nbdh_iff`, `crkdh_joI` AS `crkdh_joI`, `ddbi_iWs` AS `ddbi_iWs`, `xsdh_eV6` AS `xsdh_eV6`, `wsddh_QVT` AS `wsddh_QVT`, `xdsj_qci` AS `xdsj_qci`, `fksj_vn0` AS `fksj_vn0`, `yfje_wLX` AS `yfje_wLX`, `sjzfje_Ntb` AS `sjzfje_Ntb`, `ddje_XYs` AS `ddje_XYs`, `yf_9CN` AS `yf_9CN`, `mjyf_q57` AS `mjyf_q57`, `yhje_yXA` AS `yhje_yXA`, `ptddztmc_SEm` AS `ptddztmc_SEm`, `dpbh_j9N` AS `dpbh_j9N`, `dpmc_r7f` AS `dpmc_r7f`, `mjnc_6QD` AS `mjnc_6QD`, `dqgj_juU` AS `dqgj_juU`, `gj_HBy` AS `gj_HBy`, `dqs_VWh` AS `dqs_VWh`, `ycs_DGj` AS `ycs_DGj`, `dqs1_osd` AS `dqs1_osd`, `dqq_sER` AS `dqq_sER`, `ycq_Kfe` AS `ycq_Kfe`, `fhrq_xcK` AS `fhrq_xcK`, `mjly_61A` AS `mjly_61A`, `mjbz_thu` AS `mjbz_thu`, `ddlx_Qr9` AS `ddlx_Qr9`, `fcbh_mZk` AS `fcbh_mZk`, `wlgsmc_VpR` AS `wlgsmc_VpR`, `wldh_xWI` AS `wldh_xWI`, `yfcb_EUi` AS `yfcb_EUi`, `sczl_iqB` AS `sczl_iqB`, `fxsbh_Mji` AS `fxsbh_Mji`, `dbq_6d5` AS `dbq_6d5`, `ddcjsj_oFo` AS `ddcjsj_oFo`, `xxbz_Mw1` AS `xxbz_Mw1`, `yb_Hym` AS `yb_Hym`, `wldw_KqI` AS `wldw_KqI`, `dpqd_26x` AS `dpqd_26x`, `xymjdh_pSy` AS `xymjdh_pSy`, `ckdh_XaZ` AS `ckdh_XaZ`, `dcmc_MxS` AS `dcmc_MxS`, `ckmc_9RB` AS `ckmc_9RB`, `gzrq_stO` AS `gzrq_stO`, `gzsj_D5w` AS `gzsj_D5w`, `spslzb_5w0` AS `spslzb_5w0`, `ddlxz_asj` AS `ddlxz_asj`, `thwlgs_IyF` AS `thwlgs_IyF`, `thwldh_q7T` AS `thwldh_q7T`, `wbxsddh_Pp1` AS `wbxsddh_Pp1`, `nbzdh_5Nx` AS `nbzdh_5Nx`, `hpbi_C3s` AS `hpbi_C3s`, `xszdh_00L` AS `xszdh_00L`, `ysxsdh_L5l` AS `ysxsdh_L5l`, `shddh_DAA` AS `shddh_DAA`, `spsl_Bts` AS `spsl_Bts`, `dj_QXb` AS `dj_QXb`, `spyfje_fNO` AS `spyfje_fNO`, `zje_gu0` AS `zje_gu0`, `hpdh_vUQ` AS `hpdh_vUQ`, `spmc_3A2` AS `spmc_3A2`, `sfzp_mgI` AS `sfzp_mgI`, `spyzhzbm_z9p` AS `spyzhzbm_z9p`, `tctxm_A5C` AS `tctxm_A5C`, `spbz_oTa` AS `spbz_oTa`, `tkztmc_bOz` AS `tkztmc_bOz`, `tkdh_Uo6` AS `tkdh_Uo6`, `spzt_smW` AS `spzt_smW`, `spztmc_wbw` AS `spztmc_wbw`, `spi_ewl` AS `spi_ewl`, `xsspbm_8Vt` AS `xsspbm_8Vt`, `skuid_d2u` AS `skuid_d2u`, `rksj_qP2` AS `rksj_qP2`, `sftc_bVP` AS `sftc_bVP`, `tcsl_e1o` AS `tcsl_e1o`, `tcspzs_njR` AS `tcspzs_njR`, `yhje1_0YU` AS `yhje1_0YU`, `mjyf1_GQG` AS `mjyf1_GQG`, `cjje_cjP` AS `cjje_cjP`, `ssje_aZ2` AS `ssje_aZ2`, `xscb_YX5` AS `xscb_YX5`, `lsdj_bau` AS `lsdj_bau`, `zscgj_0gN` AS `zscgj_0gN`, `sjbm_DCI` AS `sjbm_DCI`, `shdh_CNm` AS `shdh_CNm`, `ysjbm_a2t` AS `ysjbm_a2t`, `pttctm_Mzu` AS `pttctm_Mzu`, `ddlxc_7lP` AS `ddlxc_7lP`, `ycjje_cbf` AS `ycjje_cbf`, `yykhz_2QY` AS `yykhz_2QY`, `cpkhz_4eq` AS `cpkhz_4eq`, `mxdpbh_VIB` AS `mxdpbh_VIB`, `yxdd_55d_2wd_RwZ` AS `yxdd_55d_2wd_RwZ`, `$f101` FROM (SELECT `_persist_COLLECTION_T3cB1uU2Ny`.`nbdh_iff`, `_persist_COLLECTION_T3cB1uU2Ny`.`crkdh_joI`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddbi_iWs`, `_persist_COLLECTION_T3cB1uU2Ny`.`xsdh_eV6`, `_persist_COLLECTION_T3cB1uU2Ny`.`wsddh_QVT`, `_persist_COLLECTION_T3cB1uU2Ny`.`xdsj_qci`, `_persist_COLLECTION_T3cB1uU2Ny`.`fksj_vn0`, `_persist_COLLECTION_T3cB1uU2Ny`.`yfje_wLX`, `_persist_COLLECTION_T3cB1uU2Ny`.`sjzfje_Ntb`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddje_XYs`, `_persist_COLLECTION_T3cB1uU2Ny`.`yf_9CN`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjyf_q57`, `_persist_COLLECTION_T3cB1uU2Ny`.`yhje_yXA`, `_persist_COLLECTION_T3cB1uU2Ny`.`ptddztmc_SEm`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpbh_j9N`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpmc_r7f`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjnc_6QD`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqgj_juU`, `_persist_COLLECTION_T3cB1uU2Ny`.`gj_HBy`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqs_VWh`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycs_DGj`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqs1_osd`, `_persist_COLLECTION_T3cB1uU2Ny`.`dqq_sER`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycq_Kfe`, `_persist_COLLECTION_T3cB1uU2Ny`.`fhrq_xcK`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjly_61A`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjbz_thu`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlx_Qr9`, `_persist_COLLECTION_T3cB1uU2Ny`.`fcbh_mZk`, `_persist_COLLECTION_T3cB1uU2Ny`.`wlgsmc_VpR`, `_persist_COLLECTION_T3cB1uU2Ny`.`wldh_xWI`, `_persist_COLLECTION_T3cB1uU2Ny`.`yfcb_EUi`, `_persist_COLLECTION_T3cB1uU2Ny`.`sczl_iqB`, `_persist_COLLECTION_T3cB1uU2Ny`.`fxsbh_Mji`, `_persist_COLLECTION_T3cB1uU2Ny`.`dbq_6d5`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddcjsj_oFo`, `_persist_COLLECTION_T3cB1uU2Ny`.`xxbz_Mw1`, `_persist_COLLECTION_T3cB1uU2Ny`.`yb_Hym`, `_persist_COLLECTION_T3cB1uU2Ny`.`wldw_KqI`, `_persist_COLLECTION_T3cB1uU2Ny`.`dpqd_26x`, `_persist_COLLECTION_T3cB1uU2Ny`.`xymjdh_pSy`, `_persist_COLLECTION_T3cB1uU2Ny`.`ckdh_XaZ`, `_persist_COLLECTION_T3cB1uU2Ny`.`dcmc_MxS`, `_persist_COLLECTION_T3cB1uU2Ny`.`ckmc_9RB`, `_persist_COLLECTION_T3cB1uU2Ny`.`gzrq_stO`, `_persist_COLLECTION_T3cB1uU2Ny`.`gzsj_D5w`, `_persist_COLLECTION_T3cB1uU2Ny`.`spslzb_5w0`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlxz_asj`, `_persist_COLLECTION_T3cB1uU2Ny`.`thwlgs_IyF`, `_persist_COLLECTION_T3cB1uU2Ny`.`thwldh_q7T`, `_persist_COLLECTION_T3cB1uU2Ny`.`wbxsddh_Pp1`, `_persist_COLLECTION_T3cB1uU2Ny`.`nbzdh_5Nx`, `_persist_COLLECTION_T3cB1uU2Ny`.`hpbi_C3s`, `_persist_COLLECTION_T3cB1uU2Ny`.`xszdh_00L`, `_persist_COLLECTION_T3cB1uU2Ny`.`ysxsdh_L5l`, `_persist_COLLECTION_T3cB1uU2Ny`.`shddh_DAA`, `_persist_COLLECTION_T3cB1uU2Ny`.`spsl_Bts`, `_persist_COLLECTION_T3cB1uU2Ny`.`dj_QXb`, `_persist_COLLECTION_T3cB1uU2Ny`.`spyfje_fNO`, `_persist_COLLECTION_T3cB1uU2Ny`.`zje_gu0`, `_persist_COLLECTION_T3cB1uU2Ny`.`hpdh_vUQ`, `_persist_COLLECTION_T3cB1uU2Ny`.`spmc_3A2`, `_persist_COLLECTION_T3cB1uU2Ny`.`sfzp_mgI`, `_persist_COLLECTION_T3cB1uU2Ny`.`spyzhzbm_z9p`, `_persist_COLLECTION_T3cB1uU2Ny`.`tctxm_A5C`, `_persist_COLLECTION_T3cB1uU2Ny`.`spbz_oTa`, `_persist_COLLECTION_T3cB1uU2Ny`.`tkztmc_bOz`, `_persist_COLLECTION_T3cB1uU2Ny`.`tkdh_Uo6`, `_persist_COLLECTION_T3cB1uU2Ny`.`spzt_smW`, `_persist_COLLECTION_T3cB1uU2Ny`.`spztmc_wbw`, `_persist_COLLECTION_T3cB1uU2Ny`.`spi_ewl`, `_persist_COLLECTION_T3cB1uU2Ny`.`xsspbm_8Vt`, `_persist_COLLECTION_T3cB1uU2Ny`.`skuid_d2u`, `_persist_COLLECTION_T3cB1uU2Ny`.`rksj_qP2`, `_persist_COLLECTION_T3cB1uU2Ny`.`sftc_bVP`, `_persist_COLLECTION_T3cB1uU2Ny`.`tcsl_e1o`, `_persist_COLLECTION_T3cB1uU2Ny`.`tcspzs_njR`, `_persist_COLLECTION_T3cB1uU2Ny`.`yhje1_0YU`, `_persist_COLLECTION_T3cB1uU2Ny`.`mjyf1_GQG`, `_persist_COLLECTION_T3cB1uU2Ny`.`cjje_cjP`, `_persist_COLLECTION_T3cB1uU2Ny`.`ssje_aZ2`, `_persist_COLLECTION_T3cB1uU2Ny`.`xscb_YX5`, `_persist_COLLECTION_T3cB1uU2Ny`.`lsdj_bau`, `_persist_COLLECTION_T3cB1uU2Ny`.`zscgj_0gN`, `_persist_COLLECTION_T3cB1uU2Ny`.`sjbm_DCI`, `_persist_COLLECTION_T3cB1uU2Ny`.`shdh_CNm`, `_persist_COLLECTION_T3cB1uU2Ny`.`ysjbm_a2t`, `_persist_COLLECTION_T3cB1uU2Ny`.`pttctm_Mzu`, `_persist_COLLECTION_T3cB1uU2Ny`.`ddlxc_7lP`, `_persist_COLLECTION_T3cB1uU2Ny`.`ycjje_cbf`, `_persist_COLLECTION_T3cB1uU2Ny`.`yykhz_2QY`, `_persist_COLLECTION_T3cB1uU2Ny`.`cpkhz_4eq`, `_persist_COLLECTION_T3cB1uU2Ny`.`mxdpbh_VIB`, `_persist_COLLECTION_T3cB1uU2Ny`.`yxdd_55d_2wd_RwZ`, CONCAT(CONCAT(CASE WHEN `_persist_COLLECTION_T3cB1uU2Ny`.`hpbi_C3s` IS NOT NULL THEN `_persist_COLLECTION_T3cB1uU2Ny`.`hpbi_C3s` ELSE '' END, '--'), CASE WHEN `_persist_COLLECTION_T3cB1uU2Ny`.`ddbi_iWs` IS NOT NULL THEN `_persist_COLLECTION_T3cB1uU2Ny`.`ddbi_iWs` ELSE '' END) AS `$f101` FROM `cubeappdata`.`_persist_COLLECTION_T3cB1uU2Ny`) AS `_persist_COLLECTION_T3cB1uU2Ny`) AS `_persist_COLLECTION_T3cB1uU2Ny` LEFT JOIN (SELECT `ddbi_9et`, `hpbi_B3X`, `fhrqfy_Tsb`, `fkrq_mMZ`, `yykhzfy_Iyw`, `cpkhzfy_7pM`, `czf_bBp`, `bcf_x4I`, `kdf_uQa`, `ztc_o8m`, `tgf_AMo`, `ztchxk_dnY`, `tgfhxk_gKT`, `ptfyl_swq`, `ptf_44s`, `ptkdbl_z1O`, `ptkd_loW`, `hxje_AdP`, `xthpbigs_yBH`, `yxdd_z2Q`, `ccxtdh_aT3`, `ccftbl_xA5`, `djftbl_2cu`, `zlftbl_un6`, `$f45` FROM (SELECT `订单表ID_Wv6` AS `ddbi_9et`, `货品表ID_LEw` AS `hpbi_B3X`, `Y_fhrqfy_6G_hVW` AS `fhrqfy_Tsb`, `付款日期_1MF` AS `fkrq_mMZ`, `Y_yykhzfy_QN_f7R` AS `yykhzfy_Iyw`, `Y_cpkhzfy_FR_pqt` AS `cpkhzfy_7pM`, `操作费_Zvy` AS `czf_bBp`, `包材费_Ju3` AS `bcf_x4I`, `快递费_syC` AS `kdf_uQa`, `直通车_VQh` AS `ztc_o8m`, `推广费_OTD` AS `tgf_AMo`, `直通车核销款_qx7` AS `ztchxk_dnY`, `推广费核销款_90B` AS `tgfhxk_gKT`, `平台费用率_a2q` AS `ptfyl_swq`, `平台费_Q8U` AS `ptf_44s`, `平台扣点比例_O6g` AS `ptkdbl_z1O`, `平台扣点_si7` AS `ptkd_loW`, `核销金额_Eo0` AS `hxje_AdP`, `相同货品表ID个数_jBV` AS `xthpbigs_yBH`, CAST(NULL AS DOUBLE) AS `yxdd_z2Q`, `仓储系统单号_kpN` AS `ccxtdh_aT3`, `仓储分摊比例_a1x` AS `ccftbl_xA5`, `单据分摊比例_ZnP` AS `djftbl_2cu`, `重量分摊比例_qr7` AS `zlftbl_un6`, CONCAT(CONCAT(CASE WHEN `货品表ID_LEw` IS NOT NULL THEN `货品表ID_LEw` ELSE '' END, '--'), CASE WHEN `订单表ID_Wv6` IS NOT NULL THEN `订单表ID_Wv6` ELSE '' END) AS `$f45` FROM (SELECT `Table_DingDanFeiYongMingXi`.`订单表ID` AS `订单表ID_Wv6`, `Table_DingDanFeiYongMingXi`.`货品表ID` AS `货品表ID_LEw`, CAST(CAST(DATE_FORMAT(CAST(`Table_DingDanFeiYongMingXi`.`发货日期` AS DATETIME), '%Y-%m-%d') AS DATE) AS DATETIME) AS `Y_fhrqfy_6G_hVW`, CAST(`Table_DingDanFeiYongMingXi`.`付款日期` AS DATETIME) AS `付款日期_1MF`, CASE WHEN `Table_DingDanFeiYongMingXi`.`运营考核组` IS NOT NULL THEN `Table_DingDanFeiYongMingXi`.`运营考核组` ELSE '' END AS `Y_yykhzfy_QN_f7R`, CASE WHEN `Table_DingDanFeiYongMingXi`.`产品考核组` IS NOT NULL THEN `Table_DingDanFeiYongMingXi`.`产品考核组` ELSE '' END AS `Y_cpkhzfy_FR_pqt`, `Table_DingDanFeiYongMingXi`.`操作费` AS `操作费_Zvy`, `Table_DingDanFeiYongMingXi`.`包材费` AS `包材费_Ju3`, `Table_DingDanFeiYongMingXi`.`快递费` AS `快递费_syC`, `Table_DingDanFeiYongMingXi`.`直通车` AS `直通车_VQh`, `Table_DingDanFeiYongMingXi`.`推广费` AS `推广费_OTD`, `Table_DingDanFeiYongMingXi`.`直通车核销款` AS `直通车核销款_qx7`, `Table_DingDanFeiYongMingXi`.`推广费核销款` AS `推广费核销款_90B`, `Table_DingDanFeiYongMingXi`.`平台费用率` AS `平台费用率_a2q`, `Table_DingDanFeiYongMingXi`.`平台费` AS `平台费_Q8U`, `Table_DingDanFeiYongMingXi`.`平台扣点比例` AS `平台扣点比例_O6g`, `Table_DingDanFeiYongMingXi`.`平台扣点` AS `平台扣点_si7`, `Table_DingDanFeiYongMingXi`.`核销金额` AS `核销金额_Eo0`, CAST(`Table_DingDanFeiYongMingXi`.`相同货品表ID个数` AS DOUBLE) AS `相同货品表ID个数_jBV`, `Table_DingDanFeiYongMingXi`.`仓储系统单号` AS `仓储系统单号_kpN`, `Table_DingDanFeiYongMingXi`.`仓储分摊比>例` AS `仓储分摊比例_a1x`, `Table_DingDanFeiYongMingXi`.`单据分摊比例` AS `单据分摊比例_ZnP`, `Table_DingDanFeiYongMingXi`.`重量分摊比例` AS `重量分摊比例_qr7` FROM `cubeappdata`.`Table_DingDanFeiYongMingXi`) AS `Table_DingDanFeiYongMingXi`) AS `Table_DingDanFeiYongMingXi`) AS `Table_DingDanFeiYongMingXi` ON `_persist_COLLECTION_T3cB1uU2Ny`.`$f101` = `Table_DingDanFeiYongMingXi`.`$f45`)) AS `t0`)
【背景】做过哪些操作？
并行度调为2了
【业务影响】
etl任务经常跑失败
【是否存算分离】否
【StarRocks版本】例如：3.2.11
【集群规模】例如：3fe（3follower）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群16-可乐鸡
【附件】
- fe.log/beINFO/相应截图
- 慢查询：
- Profile信息，获取Profile，通过Profile分析查询瓶颈
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，
query_dump.txt (19.2 KB)
- query_dump，
- be crash
- be.out
- coredump，如何获取coredump
- 外表查询报错
- be.out和fe.warn.log