duzhanfei commented on issue #7940: URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-717768269
hi, there are same datas ECIF_CUST_NO = 10000 in ds_0.pscst_prdt_cvr0, but we can't find it At 2020-10-28 15:09:00, "邱鹿 Lucas" <[email protected]> wrote: @duzhanfei Hi ,you can execute under sql in ds_0.pscst_prdt_cvr0 directly. I guess you can't find anything. SELECT BIZ_DT, ECIF_CUST_NO, DEP_FLG, DBTCD_FLG, PLM_PY_FLG, PY_GTWY_FLG, SFSRV_EQP_SGNG_FLG, ATMBL_MRTG_FLG, HS_MRTG_FLG, HLPFM_ETMN_FLG, PSNL_MANG_LN_FLG, PSNL_CNSM_LN_FLG, ETC_FLG, CSCRD_FLG, MBLBNK_FLG, EBP_SGNG_FLG FROM pscst_prdt_cvr0 WHERE ECIF_CUST_NO =10000 Please make sure your data is match your shardingRule. If there are same datas ECIF_CUST_NO = 10000 but not in ds_0.pscst_prdt_cvr0, we can't find it. (we called it dirty data.) Because if a sql include shardingKey, we will calcuate and execute in matched table directly and ignore other sharding tables. By the way, your shardingRule is unreasonable. Only ds0.pscst_prdt_cvr0 and ds1.pscst_prdt_cvr1 include datas by the same database and table strategy. databaseStrategy: inline: shardingColumn: ecif_cust_noalgorithmExpression: ds_${ecif_cust_no % 2}tableStrategy: inline: shardingColumn: ecif_cust_noalgorithmExpression: pscst_prdt_cvr${ecif_cust_no % 2} — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or unsubscribe. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
