com.starrocks.sql.common.StarRocksPlannerException: Invalid plan:
PhysicalDistributionOperator {distributionSpec=SHUFFLE_AGG[1099(true), 1142(true), 1140(true), 1143(true), 1141(true), 1110(true), 1111(true), 1112(true)] ,globalDict=[1134:com.starrocks.sql.optimizer.statistics.ColumnDict@115ed5bd, 1135:com.starrocks.sql.optimizer.statistics.ColumnDict@47a5f585, 1136:com.starrocks.sql.optimizer.statistics.ColumnDict@75d448d0, 1137:com.starrocks.sql.optimizer.statistics.ColumnDict@65ad8513, 1138:com.starrocks.sql.optimizer.statistics.ColumnDict@2395726, 1139:com.starrocks.sql.optimizer.statistics.ColumnDict@115ed5bd, 1140:com.starrocks.sql.optimizer.statistics.ColumnDict@47a5f585, 1141:com.starrocks.sql.optimizer.statistics.ColumnDict@75d448d0, 1142:com.starrocks.sql.optimizer.statistics.ColumnDict@65ad8513, 1143:com.starrocks.sql.optimizer.statistics.ColumnDict@2395726, 1144:com.starrocks.sql.optimizer.statistics.ColumnDict@115ed5bd, 1145:com.starrocks.sql.optimizer.statistics.ColumnDict@47a5f585, 1146:com.starrocks.sql.optimizer.statistics.ColumnDict@75d448d0, 1147:com.starrocks.sql.optimizer.statistics.ColumnDict@65ad8513, 1148:com.starrocks.sql.optimizer.statistics.ColumnDict@2395726, 1149:com.starrocks.sql.optimizer.statistics.ColumnDict@115ed5bd, 1150:com.starrocks.sql.optimizer.statistics.ColumnDict@47a5f585, 1151:com.starrocks.sql.optimizer.statistics.ColumnDict@75d448d0, 1152:com.starrocks.sql.optimizer.statistics.ColumnDict@65ad8513, 1153:com.starrocks.sql.optimizer.statistics.ColumnDict@2395726]}
-> PhysicalHashAggregate {type=LOCAL, groupBy=[1099: ts, 1152: region_name_cn, 1150: division, 1153: channel, 1151: sub_division_pur, 1110: is_pb, 1111: is_di, 1112: is_pbdi], partitionBy=[1099: ts, 1152: region_name_cn, 1150: division, 1153: channel, 1151: sub_division_pur, 1110: is_pb, 1111: is_di, 1112: is_pbdi] ,aggregations={}}
-> PhysicalOlapScanOperator {table=809444971, selectedPartitionId=[966827078, 966827080, 966827079, 966827075, 966827074, 966827077, 966827076, 966827073, 966827072, 966827071, 966827491, 966827490, 966827493, 966827492, 966827487, 966827486, 966827489, 966827488, 966827485, 966827494, 966827780, 966827786, 966827785, 966827788, 966827787, 966827782, 966827781, 966827784, 966827783, 966827779, 966828158, 966828166, 966828167, 966828164, 966828165, 966828162, 966828163, 966828160, 966828161, 966828159, 966828574, 966828575, 966828572, 966828573, 966828570, 966828571, 966828568, 966828569, 966828566, 966828567, 966828869, 966828876, 966828877, 966828874, 966828875, 966828872, 966828873, 966828870, 966828871, 966828868, 966829340, 966829341, 966829338, 966829339, 966829336, 966829337, 966829334, 966829335, 966829333, 966829332, 966829877, 966829875, 966829876, 966829873, 966829874, 966829871, 966829872, 966829870, 966829878, 966829879, 966830463, 966830464, 966830461, 966830462, 966830459, 966830460, 966830457, 966830458, 966830465, 966830466, 966831813, 966831814, 966831811, 966831812, 966831809, 966831810, 966831807, 966831808, 966831806, 966831805, 966832891, 966832889, 966832890, 966832887, 966832888, 966832885, 966832886, 966832883, 966832884, 966832892, 966833298, 966833299, 966833296, 966833297, 966833294, 966833295, 966833292, 966833293, 966833291, 966833290, 966833478, 966833476, 966833477, 966833474, 966833475, 966833472, 966833473, 966833470, 966833471, 966833469, 966833899, 966833900, 966833897, 966833898, 966833895, 966833896, 966833893, 966833894, 966833892, 966833901, 966834158, 966834156, 966834157, 966834154, 966834155, 966834152, 966834153, 966834150, 966834151, 966834149, 966834372, 966834380, 966834381, 966834378, 966834379, 966834376, 966834377, 966834374, 966834375, 966834373, 966835039, 966835040, 966835037, 966835038, 966835035, 966835036, 966835033, 966835034, 966835031, 966835032, 966835715, 966835713, 966835714, 966835711, 966835712, 966835709, 966835710, 966835707, 966835708, 966835706, 966836668, 966836667, 966836665, 966836666, 966836663, 966836664, 966836661, 966836662, 966836659, 966836660, 966838009, 966838007, 966838008, 966838005, 966838006, 966838003, 966838004, 966838001, 966838002, 966838000, 966841148, 966841149, 966841146, 966841147, 966841144, 966841145, 966841142, 966841143, 966841140, 966841141, 966842383, 966842382, 966842380, 966842381, 966842378, 966842379, 966842376, 966842377, 966842374, 966842375, 966850782, 966850790, 966850791, 966850788, 966850789, 966850786, 966850787, 966850784, 966850785, 966850783, 966851112, 966851121, 966851119, 966851120, 966851117, 966851118, 966851115, 966851116, 966851113, 966851114, 966854421, 966854419, 966854420, 966854418, 966854416, 966854417, 966854414, 966854415, 966854412, 966854413, 966854836, 966854837, 966854845, 966854843, 966854844, 966854841, 966854842, 966854839, 966854840, 966854838, 966856070, 966856071, 966856078, 966856079, 966856076, 966856077, 966856074, 966856075, 966856072, 966856073, 966856784, 966856785, 966856793, 966856786, 966856791, 966856792, 966856789, 966856790, 966856787, 966856788, 966857050, 966857051, 966857054, 966857052, 966857053, 966857058, 966857059, 966857056, 966857057, 966857055, 966893998, 966893997, 966894001, 966894002, 966893999, 966894000, 966894005, 966894006, 966894003, 966894004, 966894129, 966894130, 966894132, 966894131, 966894127, 966894128, 966894125, 966894126, 966894123, 966894124, 967010115, 967010116, 967010114, 967010117, 967010118, 967010122, 967010123, 967010120, 967010121, 967010119, 967124589, 967124587, 967124588, 967124582, 967124580, 967124581, 967124585, 967124586, 967124583, 967124584, 967125334, 967125335, 967125333, 967125336, 967125342, 967125340, 967125341, 967125338, 967125339, 967125337, 967125752, 967125750, 967125751, 967125753, 967125758, 967125759, 967125756, 967125757, 967125754, 967125755, 967126964, 967126965, 967126963, 967126956, 967126957, 967126961, 967126962, 967126959, 967126960, 967126958, 967127178, 967127176, 967127177, 967127180, 967127179, 967127174, 967127175, 967127171, 967127172, 967127173, 967127457, 967127454, 967127455, 967127456, 967127450, 967127451, 967127452, 967127453, 967127448, 967127449, 967127712, 967127713, 967127710, 967127711, 967127719, 967127715, 967127716, 967127717, 967127718, 967127714, 967127877, 967127878, 967127879, 967127876, 967127880, 967127881, 967127885, 967127882, 967127883, 967127884, 967128630, 967128626, 967128627, 967128628, 967128629, 967128623, 967128624, 967128625, 967128621, 967128622, 967129033, 967129034, 967129030, 967129031, 967129032, 967129036, 967129037, 967129038, 967129039, 967129035, 967129818, 967129819, 967129820, 967129816, 967129817, 967129822, 967129823, 967129824, 967129825, 967129821, 967130902, 967130903, 967130904, 967130901, 967130899, 967130900, 967130895, 967130896, 967130897, 967130898, 967131718, 967131719, 967131720, 967131721, 967131725, 967131726, 967131727, 967131722, 967131723, 967131724, 967134202, 967134199, 967134200, 967134201, 967134193, 967134194, 967134196, 967134197, 967134198, 967134195, 967134688, 967134689, 967134690, 967134686, 967134687, 967134695, 967134691, 967134692, 967134693, 967134694, 967135008, 967135009, 967135010, 967135011, 967135007, 967135015, 967135016, 967135012, 967135013, 967135014, 967135124, 967135120, 967135121, 967135122, 967135123, 967135119, 967135117, 967135118, 967135115, 967135116, 967135286, 967135287, 967135283, 967135284, 967135285, 967135279, 967135280, 967135281, 967135282, 967135278, 967135369, 967135370, 967135371, 967135367, 967135368, 967135376, 967135372, 967135373, 967135374, 967135375, 967135467, 967135468, 967135469, 967135470, 967135466, 967135471, 967135472, 967135465, 967135463, 967135464, 967135596, 967135597, 967135592, 967135593, 967135594, 967135595, 967135599, 967135600, 967135601, 967135598, 967135876, 967135877, 967135878, 967135873, 967135874, 967135875, 967135879, 967135880, 967135881, 967135882, 967136063, 967136064, 967136065, 967136066, 967136061, 967136062, 967136060, 967136057, 967136058, 967136059, 967136224, 967136220, 967136221, 967136222, 967136223, 967136219, 967136217, 967136218, 967136215, 967136216, 967136356, 967136357, 967136352, 967136353, 967136354, 967136355, 967136359, 967136360, 967136361, 967136358, 967136523, 967136524, 967136525, 967136520, 967136521, 967136522, 967136518, 967136519, 967136516, 967136517, 967136666, 967136662, 967136663, 967136664, 967136665, 967136670, 967136671, 967136669, 967136667, 967136668, 967136827, 967136828, 967136823, 967136824, 967136825, 967136826, 967136832, 967136830, 967136831, 967136829, 967136951, 967136952, 967136953, 967136947, 967136948, 967136949, 967136950, 967136945, 967136946, 967136944, 967137127, 967137123, 967137124, 967137125, 967137126, 967137120, 967137121, 967137122, 967137118, 967137119, 967137704, 967137705, 967137700, 967137701, 967137702, 967137703, 967137708, 967137709, 967137707, 967137706, 967138047, 967138048, 967138049, 967138043, 967138044, 967138045, 967138046, 967138052, 967138051, 967138050, 967138649, 967138650, 967138651, 967138645, 967138646, 967138647, 967138648, 967138644, 967138652, 967138653, 967139996, 967139997, 967139998, 967139999, 967139992, 967139993, 967139994, 967139995, 967140000, 967140001, 967140551, 967140547, 967140548, 967140549, 967140550, 967140544, 967140545, 967140546, 967140552, 967140553, 967140742, 967140743, 967140744, 967140738, 967140739, 967140740, 967140741, 967140736, 967140737, 967140745, 967142428, 967142429, 967142430, 967142431, 967142424, 967142425, 967142426, 967142427, 967142423, 967142422, 967144318, 967144314, 967144315, 967144316, 967144317, 967144310, 967144311, 967144312, 967144313, 967144319, 967147825, 967147826, 967147821, 967147822, 967147823, 967147824, 967147818, 967147819, 967147820, 967147827, 967148308, 967148309, 967148310, 967148304, 967148305, 967148306, 967148307, 967148302, 967148303, 967148301, 967150054, 967150055, 967150056, 967150057, 967150050, 970934332, 975952559, 978583780, 981179097, 983763157, 987920754, 992072284, 992072287, 992072288, 992072285, 992072286, 992072282, 992072283], selectedIndexId=809444972, outputColumns=[1099: ts, 1110: is_pb, 1111: is_di, 1112: is_pbdi, 1150: division, 1151: sub_division_pur, 1152: region_name_cn, 1153: channel], projection=[1153: channel, 1110: is_pb, 1111: is_di, 1112: is_pbdi, 1099: ts, 1150: division, 1151: sub_division_pur, 1152: region_name_cn], predicate=1099: ts >= 2024-11-18 AND 1099: ts <= 2024-11-23 OR 1099: ts >= 2024-11-25 AND 1099: ts <= 2024-11-30 AND 1113: user_type = 3 AND 1114: is_offline_user = 0 AND DictMapping(1153: channel{1103: channel = APP}) AND DictMapping(1149: channel_sub_type{1104: channel_sub_type != JDDJ}), prunedPartitionPredicates=[], limit=-1}Input dependency cols check failed. The required cols {1140,1141,1142,1143} cannot obtain from input cols {1099,1110,1111,1112,1150,1151,1152,1153}.
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkInputCols(InputDependenciesChecker.java:200) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:134) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkJoinOpt(InputDependenciesChecker.java:139) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:70) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkSetOpt(InputDependenciesChecker.java:168) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:72) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.checkOptExprWithOneChild(InputDependenciesChecker.java:118) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker$Visitor.visit(InputDependenciesChecker.java:68) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.InputDependenciesChecker.validate(InputDependenciesChecker.java:57) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.validate.PlanValidator.validatePlan(PlanValidator.java:55) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.optimizeByCost(Optimizer.java:295) ~[starrocks-fe.jar:?]
at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:184) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:254) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:135) ~[starrocks-fe.jar:?]
at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:97) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:551) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:337) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:531) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:843) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_322]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_322]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_322]
可能是底层出现了问题，
临时方案：set cbo_cte_reuse_rate=0; 解决