xzj7019 opened a new pull request, #24099: URL: https://github.com/apache/doris/pull/24099
## Proposed changes avoid throw analysis ex for unsupported type to make ext table goes nereids. this will improve the nereids' availability for external table if unsupported type is in the basic table schema but not referenced in the real sql. Consider the following case: select pu.pk_ct_pu as id from fms_rd_nc65_zb.NC65P.CT_PU pu left join fms_rd_nc65_zb.NC65P.PUB_WF_INSTANCE pwi on pu.pk_ct_pu = pwi.billid and pu.vtrantypecode=pwi.billtype left join fms_rd_nc65_zb.NC65P.SM_USER su on pu.creator = su.cuserid where pu.pk_ct_pu='1001A110000000K8XPVN'; PUB_WF_INSTANCE table has a BLOB type column and currently it will throw analysis exception and fallback to old optimizer, although this column is not referenced in the real sql. The old optimizer doesn't have the outer join -> inner join rule and the "pu.pk_ct_pu='1001A110000000K8XPVN'; " is not pushed down and the performance will drop down. After the pr, we add the unsupported type instead of throw exception directly, it will decide the unused case and can continue goes nereids and use all advanced optimization for the sql. tested in external table env. <!--Describe your changes.--> ## Further comments If this is a relatively large or complex change, kick off the discussion at [d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc... -- 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
