95liu commented on issue #5945:
URL: https://github.com/apache/iceberg/issues/5945#issuecomment-1274169053

       select 
           soqte1.org_no
       from
                (select eid 
           , credit_no 
           , org_no
           , name
           , start_date
           , reg_no
           , province_code
           from ods_t_enterprise_1g
           where province_code = '440000'
           ) soqte1
       join 
                (
           select eid                  as eid
               , ''                    as company_name
               , 1                     as relate_level
               , name                  as name
               , 'εˆ†ζ”―ζœΊζž„'            as relation
               , ''                    as relation_com_name
           from ods_t_branches_1g
           ) ttl
           on ttl.eid = soqte1.eid
       distribute by rand();


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to