Use qualify row_number() ... not support select *

[wmtbnbo]

When I execute the following SQL statement.

select a.* from tablea a qualify row_number() over (partition by a.id order by a.date desc) = 1;

I will receive an exception message.

ERROR 1064 (HY000): Getting syntax error. Detail message: Can't support result other than column..

Adjust the statement to select a.id,a.name from tablea a qualify row_number() over (partition by a.id order by a.date desc) = 1;

The statement can run normally.

[wangsimo0]

good enhancement

[gjjjj0101]

Hi, I'd like to try it. Could you please assign this to me? Thanks! @wangsimo0

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!