`Hive` dialect does not support `distribute by` or `sort by` in window specs

In Hive 3.1.x, we found that the following query executes successfully:
```sql
select row_number() over(distribute by id sort by update_time desc) as row_num
from (select 1 as id, current_timestamp as update_time) t
```

However, when generating the AST using **the latest code from the main branch**, the following error occurs:

Reference documentation:

https://github.com/apache/hive/blob/master/parser/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g#L293-L297
https://github.com/apache/hive/blob/master/parser/src/java/org/apache/hadoop/hive/ql/parse/SelectClauseParser.g#L135-L139
https://github.com/apache/hive/blob/master/parser/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g#L271-L27

Reproduce the query in the Hive dialect and trace how its window specification is parsed. Compare the relevant grammar in Hive's IdentifiersParser.g, SelectClauseParser.g, and FromClauseParser.g, then add regression coverage showing that distribute by and sort by are accepted and the AST is generated successfully.

Written by the indexing model from the issue text.