[hive-dialect] row_number() over (distribute by fund_account sort by bus_date desc) as sort_id ; not support

[zhengtingxue]

bad_sql:
insert into table a select
row_number() over (distribute by a sort by b desc) as sort_id
from b;

[delphisharp]

1. I hope the questions can be filled in in detail according to the template.
2. From hive official documentation https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics, I don’t see support for similar syntax.
3. If hive does support it, I think the correct solution path is:
   a: hive docment is supplemented first.
   b. https://github.com/sqlfluff follow-up support
   c. https://github.com/reata/sqllineage follow-up support