czzmmc opened a new issue, #18776: URL: https://github.com/apache/doris/issues/18776
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description Optimizer hint is powerful in many uses. I see doris has the function in query statement. But doris does not support optimizer hint in insert statement. When I try this sql (insert /*+ SET_VAR(parallel_fragment_exec_instance_num=16)*/ into r_1y5000w_c_500_t_32_not_key(ID,f500) SELECT ID,IF(f5='1', '1', '2') FROM r_1y5000w_c_500_t_32_not_key;), I get this error. ``` mysql> insert /*+ SET_VAR(parallel_fragment_exec_instance_num=16)*/ into r_1y5000w_c_500_t_32_not_key(ID,f500) SELECT ID,IF(f5='1', '1', '2') FROM r_1y5000w_c_500_t_32_not_key; ERROR 1105 (HY000): NullPointerException, msg: null ``` ### Use case None ### Related issues None ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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.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
