hf200012 commented on issue #9545:
URL:
https://github.com/apache/incubator-doris/issues/9545#issuecomment-1125790882
upgrade 1.0
```
mysql> insert into test.rownumber_test_00
-> select
-> t0.id,
-> t1.name
-> from
-> test.rownumber_test_01 t0
-> left join
-> (select
-> t.client_actor_id,
-> t.name
-> from
-> (select
-> t1.client_actor_id,
-> t2.name,
-> row_number()OVER(PARTITION BY
t1.client_actor_id,t1.service_actor_id,t1.service_application,t2.name ORDER BY
t1.refresh_token_expiration desc) AS rn
-> from test.rownumber_test_02 t1
-> left join test.rownumber_test_03 t2
-> on t1.id = t2.token_id and t2.is_deleted_flg=0
-> where t1.is_deleted_flg=0) t
-> where t.rn = 1
-> ) t1
-> on t0.id= t1.client_actor_id
-> ;
Query OK, 0 rows affected (0.04 sec)
{'label':'insert_4e331671d65a4303-834e7fea963d08cc', 'status':'VISIBLE',
'txnId':'17042'}
```
--
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]
