Larborator commented on issue #20725: URL: https://github.com/apache/doris/issues/20725#issuecomment-1597319048
> and I have the same problem run the same sql twice return different result;the first return one row, the second return none row; > > the follow is query profile [FIRST.txt](https://github.com/apache/doris/files/11767821/FIRST.txt) [SECOND.txt](https://github.com/apache/doris/files/11767824/SECOND.txt) There may be some bugs in BE's low cardinality optimizing when the fieldType is STRING. You can try adding ```enable_low_cardinality_optimize = false``` to BE's conf file and restart BE. -- 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