Re:question about doris catalog

[Mingyu Chen]

What is your Doris version, and how many node in your cluster?







--

Best Regards
Mingyu Chen

Email:
morning...@apache.org





At 2024-02-22 10:57:49, "柠檬" <545857...@qq.com.INVALID> wrote:
>dear techer&nbsp;
>&nbsp; &nbsp; i'm a doris beginner, when i use doris catalog to query&nbsp; 
>the difference data between the extenal database table&nbsp; and doris 
>database table , it always be the out of memeory problem , this is the sql
>&nbsp; &nbsp;select m.*
>&nbsp; &nbsp;from jdbc_oracle.bddj_etl.a_prpcitemcar&nbsp; &nbsp;m&nbsp;
>left join&nbsp; ods_ahic.temp_prpcitemcar&nbsp; n&nbsp;
>on&nbsp; m.policyno=n.policyno
>and&nbsp; m.itemno=n.ITEMNO&nbsp;
>where n.policyno is null ,
>&nbsp;
>here table m is an oracle database,I accessed the oracle database via catalog 
>, table n is a doris table .
>
>
>I wonder if there's a way to optimize this sql? Or whether the doris catalog 
>is not suitable for this large data comparison scenary?
>&nbsp; &nbsp;&nbsp;
>Looking forward to your reply
>
>
>
>
>
>柠檬
>545857...@qq.com
>
>
>
>&nbsp;