Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.3.0
-
None
Description
For Sql:
val sql = "SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable"
The alias `cnt1` The alias did not take effect when we generated the plan string. But we can using the alias in outer layer query, for example:
val sql = "SELECT cnt1 from (SELECT c, count(a) OVER (ORDER BY proctime ROWS BETWEEN 2 preceding AND CURRENT ROW) as cnt1 CURRENT ROW from MyTable)"
So in this JIRA. we just fix the test case for 1.3 release. In another JIRA. will improve the alias.
Attachments
Issue Links
- links to