STEPS TO REPRODUCE:
1. Create a table:
2. Run the query which was working in Hive-1.2: (ORDER clause before WINDOW)
The query fails with an exception you can find above.
The query from Step 2 which works for Hive-2.3 is ( (ORDER clause after WINDOW)):
Hive-2.3 also fails to parse subquery ( (ORDER clause before WINDOW)):
Customer is facing issue regularly this is occurring after upgrade . the workaround given by us need lot of code changes which will get them back to squire one they need to follow process and will cost them a lot.