Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Display partition by, order by and frame info for window function #8835

Closed
alivxxx opened this issue Dec 26, 2018 · 0 comments
Closed

Display partition by, order by and frame info for window function #8835

alivxxx opened this issue Dec 26, 2018 · 0 comments
Assignees
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@alivxxx
Copy link
Contributor

alivxxx commented Dec 26, 2018

Feature Request

Is your feature request related to a problem? Please describe:

MySQL [test]> explain select sum(a) over(partition by a order by b) from t; 
+--------------------------+----------+------+------------------------------------------------------------+
| id                       | count    | task | operator info                                              |
+--------------------------+----------+------+------------------------------------------------------------+
| Projection_7             | 10000.00 | root | sum(a) over(partition by a order by b)                     |
| └─Window_8               | 10000.00 | root | sum(test.t.a)                                              |
|   └─Sort_12              | 10000.00 | root | test.t.a:asc, test.t.b:asc                                 |
|     └─TableReader_11     | 10000.00 | root | data:TableScan_10                                          |
|       └─TableScan_10     | 10000.00 | cop  | table:t, range:[-inf,+inf], keep order:false, stats:pseudo |
+--------------------------+----------+------+------------------------------------------------------------+

Describe the feature you'd like:

Now we only display the window function name and it's paremeters in the explain, it is better to also add the partiton by, order by and frame info.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy:

@alivxxx alivxxx added the type/enhancement The issue or PR belongs to an enhancement. label Dec 26, 2018
@alivxxx alivxxx self-assigned this Dec 26, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

No branches or pull requests

1 participant