Moredespicablethananyoneelse commented on issue #30860:
URL: https://github.com/apache/doris/issues/30860#issuecomment-1951543399
> seems old planner have thrown error. you could session variables : set
experimental_enable_nereids_planner = true;
it seems nereids planner also throw an exception. it fall bact to old
planner.
mysql> show variables like '%nereids%';
+-------------------------------------+-------+---------------+---------+
| Variable_name | Value | Default_Value | Changed |
+-------------------------------------+-------+---------------+---------+
| disable_nereids_rules | | | 0 |
| dump_nereids_memo | false | false | 0 |
| enable_nereids_dml | false | false | 0 |
| enable_nereids_timeout | true | true | 0 |
| enable_nereids_trace | false | false | 0 |
| experimental_enable_nereids_planner | true | - | - |
| nereids_cbo_penalty_factor | 0.7 | 0.7 | 0 |
| nereids_star_schema_support | true | true | 0 |
| nereids_trace_event_mode | all | all | 0 |
| plan_nereids_dump | false | false | 0 |
| trace_nereids | false | false | 0 |
+-------------------------------------+-------+---------------+---------+
11 rows in set (0.00 sec)
mysql> SELECT b.re_number1 cc1,b.re_number2 cc2
-> from RECURSIVE_DIM_BAI_02_number b INNER join
RECURSIVE_FACT_BAI_01_number c on d_number=k_number
-> group by b.re_number1,b.re_number2
-> HAVING b.re_number1 is not null and b.re_number2 is not null
-> and (max(b.re_number1))not in(SELECT ext_number1
-> from extreme_table_number inner join RECURSIVE_DIM_BAI_01_number on
ord_id=a_number
-> where not exists(SELECT min(re_number1)
-> from RECURSIVE_FACT_BAI_01_number
-> WHERE re_number2=ext_number2
-> group by re_number1,re_number2
-> HAVING count(re_number1)>9 )
-> and year(K_DATE)>4990
-> );
ERROR 1105 (HY000): IllegalStateException, msg:
java.lang.IllegalStateException: null
mysql>
--
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.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
