Hi kylin: When I ran sql "select sum(HBD_OPR.PAY_AMT) amt, HBD_OPR.MZ_EXPENSE_CATEGORIES, HBD_OPR.DEPARTMENT dept from HBD_OPR where HBD_OPR.CHARGE_DATE>='2015-01-01' and HBD_OPR.CHARGE_DATE<'2016-01-11' and 1=2 group by HBD_OPR.MZ_EXPENSE_CATEGORIES, HBD_OPR.DEPARTMENT union all select sum(HBD_OPC_DIAG.TOTAL_AMT) amt, HBD_OPC_DIAG.MZ_EXPENSE_CATEGORIES, HBD_OPC_DIAG.ORDER_DEPT dept from HBD_OPC_DIAG where HBD_OPC_DIAG.CHARGE_DATE >='2015-01-01' and HBD_OPC_DIAG.CHARGE_DATE <'2016-01-11' and 1=2 group by HBD_OPC_DIAG.MZ_EXPENSE_CATEGORIES, HBD_OPC_DIAG.ORDER_DEPT union all select sum(HBD_OPC_DRUG_FEE.TOTAL_AMT) amt, HBD_OPC_DRUG_FEE.MZ_EXPENSE_CATEGORIES, HBD_OPC_DRUG_FEE.ORDER_DEPT dept from HBD_OPC_DRUG_FEE where HBD_OPC_DRUG_FEE.CHARGE_DATE >='2015-01-01' and HBD_OPC_DRUG_FEE.CHARGE_DATE <'2016-01-11' and 1=1 group by HBD_OPC_DRUG_FEE.MZ_EXPENSE_CATEGORIES, HBD_OPC_DRUG_FEE.ORDER_DEPT" on my cube, I got only a Excuting status on kylin web page ,a timeout in my java code, and kylin log : 2019-01-24 15:26:09,289 INFO [BadQueryDetector] service.BadQueryDetector:203 : Slow query has been running 159.581 seconds (project:hbd_warehouse, thread: 0xdc4e, user:ADMIN, query id:989de4e4-3451-e89b-96e5-4e686017dcd5) -- select * from ( select sum(HBD_OPR.PAY_AMT) amt, HBD_OPR.MZ_EXPENSE_CATEGORIES, HBD_OPR.DEPARTMENT dept from HBD_OPR where HBD_OPR.CHARGE_DATE>='2015-01-01' and HBD_OPR.CHARGE_DATE<'2016-01-11' and 1=2 group by HBD_OPR.MZ_EXPENSE_CATEGORIES, HBD_OPR.DEPARTMENT union all select sum(HBD_OPC_DIAG.TOTAL_AMT) amt, HBD_OPC_DIAG.MZ_EXPENSE_CATEGORIES, HBD_OPC_DIAG.ORDER_DEPT dept from HBD_OPC_DIAG where HBD_OPC_DIAG.CHARGE_DATE >='2015-01-01' and HBD_OPC_DIAG.CHARGE_DATE <'2016-01-11' and 1=2 group by HBD_OPC_DIAG.MZ_EXPENSE_CATEGORIES, HBD_OPC_DIAG.ORDER_DEPT union all select sum(HBD_OPC_DRUG_FEE.TOTAL_AMT) amt, HBD_OPC_DRUG_FEE.MZ_EXPENSE_CATEGORIES, HBD_OPC_DRUG_FEE.ORDER_DEPT dept from HBD_OPC_DRUG_FEE where HBD_OPC_DRUG_FEE.CHARGE_DATE >='2015-01-01' and HBD_OPC_DRUG_FEE.CHARGE_DATE <'2016-01-11' and 1=1 group by HBD_OPC_DRUG_FEE.MZ_EXPENSE_CATEGORIES, HBD_OPC_DRUG_FEE.ORDER_DEPT )a 2019-01-24 15:26:09,327 DEBUG [BadQueryDetector] badquery.BadQueryHistoryManager:65 : Loaded 13 Bad Query(s) 2019-01-24 15:26:09,388 INFO [BadQueryDetector] service.BadQueryDetector:191 : Problematic thread 0xdc4e Query 989de4e4-3451-e89b-96e5-4e686017dcd5-56398, query id: 989de4e4-3451-e89b-96e5-4e686017dcd5 at org.apache.calcite.plan.volcano.RelSubset.getParentSubsets(RelSubset.java:222) at org.apache.calcite.plan.volcano.RuleQueue.computeImportance(RuleQueue.java:396) at org.apache.calcite.plan.volcano.RuleQueue.recompute(RuleQueue.java:193) at org.apache.calcite.plan.volcano.RuleQueue.recompute(RuleQueue.java:206) at org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1615) at org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:863) at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:883) at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:1766) at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:135) at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:234) The SQL works when I split it up into subqueries and got the right result, so I am curious about that why this error could happen?希望能得到你们的帮助,感激不尽。
rolltion.zh...@foxmail.com