Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Dmitry Lychagin has submitted this change and it was merged. (
https://asterix-gerrit.ics.uci.edu/3452 )
Change subject: [NO ISSUE] Correct markup for window function documentation
..
[NO ISSUE] Correct markup for window function documentation
Correct indentation for code and follow-on paragraphs in bullets.
More descriptive aliases in LEAD and LAG examples.
Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3452
Sonar-Qube: Jenkins
Contrib: Jenkins
Tested-by: Jenkins
Integration-Tests: Jenkins
Reviewed-by: Dmitry Lychagin
---
M asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
1 file changed, 681 insertions(+), 681 deletions(-)
Approvals:
Jenkins: Verified; No violations found; ; Verified
Dmitry Lychagin: Looks good to me, approved
diff --git a/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
b/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
index e661064..64bcf17 100644
--- a/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
+++ b/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
@@ -39,7 +39,7 @@
* Syntax:
- CUME_DIST() OVER ([window-partition-clause] window-order-clause)
+CUME_DIST() OVER ([window-partition-clause] window-order-clause)
* Returns the percentile rank of the current tuple as part of the cumulative
distribution – that is, the number of tuples ranked lower than or equal to
@@ -63,60 +63,60 @@
* Example:
- For each author, find the cumulative distribution of all messages
- in order of message ID.
+For each author, find the cumulative distribution of all messages
+in order of message ID.
- SELECT m.messageId, m.authorId, CUME_DIST() OVER (
-PARTITION BY m.authorId
-ORDER BY m.messageId
- ) AS `rank`
- FROM GleambookMessages AS m;
+SELECT m.messageId, m.authorId, CUME_DIST() OVER (
+ PARTITION BY m.authorId
+ ORDER BY m.messageId
+) AS `rank`
+FROM GleambookMessages AS m;
* The expected result is:
- [
-{
- "rank": 0.2,
- "messageId": 2,
- "authorId": 1
-},
-{
- "rank": 0.4,
- "messageId": 4,
- "authorId": 1
-},
-{
- "rank": 0.6,
- "messageId": 8,
- "authorId": 1
-},
-{
- "rank": 0.8,
- "messageId": 10,
- "authorId": 1
-},
-{
- "rank": 1,
- "messageId": 11,
- "authorId": 1
-},
-{
- "rank": 0.5,
- "messageId": 3,
- "authorId": 2
-},
-{
- "rank": 1,
- "messageId": 6,
- "authorId": 2
-}
- ]
+[
+ {
+"rank": 0.2,
+"messageId": 2,
+"authorId": 1
+ },
+ {
+"rank": 0.4,
+"messageId": 4,
+"authorId": 1
+ },
+ {
+"rank": 0.6,
+"messageId": 8,
+"authorId": 1
+ },
+ {
+"rank": 0.8,
+"messageId": 10,
+"authorId": 1
+ },
+ {
+"rank": 1,
+"messageId": 11,
+"authorId": 1
+ },
+ {
+"rank": 0.5,
+"messageId": 3,
+"authorId": 2
+ },
+ {
+"rank": 1,
+"messageId": 6,
+"authorId": 2
+ }
+]
### dense_rank ###
* Syntax:
- DENSE_RANK() OVER ([window-partition-clause] window-order-clause)
+DENSE_RANK() OVER ([window-partition-clause] window-order-clause)
* Returns the dense rank of the current tuple – that is, the number of
distinct tuples preceding this tuple in the current window partition, plus
@@ -146,67 +146,67 @@
* Example:
- For each author, find the dense rank of all messages in order of location.
+For each author, find the dense rank of all messages in order of location.
- SELECT m.authorId, m.messageId, m.senderLocation[1] as longitude,
- DENSE_RANK() OVER (
-PARTITION BY m.authorId
-ORDER BY m.senderLocation[1]
- ) AS `rank`
- FROM GleambookMessages AS m;
+SELECT m.authorId, m.messageId, m.senderLocation[1] as longitude,
+DENSE_RANK() OVER (
+ PARTITION BY m.authorId
+ ORDER BY m.senderLocation[1]
+) AS `rank`
+FROM GleambookMessages AS m;
* The expected result is:
- [
-{
- "rank": 1,
- "authorId": 1,
- "messageId": 10,
- "longitude": 70.01
-},
-{
- "rank": 2,
- "authorId": 1,
- "messageId": 11,
- "longitude": 77.49
-},
-{
- "rank": 3,
- "authorId": 1,
-
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Dmitry Lychagin has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Code-Review+2 -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Anon. E. Moose (1000171) Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 18:19:04 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/8755/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Anon. E. Moose (1000171) Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 18:12:14 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Contrib+1 BAD Compatibility Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/4581/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Anon. E. Moose (1000171) Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 17:12:14 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Anon. E. Moose (1000171) has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Analytics Compatibility Compilation Successful https://cbjenkins.page.link/S8ziQQ2BFBbjwUbj7 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Anon. E. Moose (1000171) Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 16:55:57 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: BAD Compatibility Tests Started https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/4581/ -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 16:54:26 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-spidersilk-tests/916/ (12/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:09 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/8755/ -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Dmitry Lychagin Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Simon Dew Gerrit-Reviewer: Till Westmann Gerrit-Comment-Date: Fri, 21 Jun 2019 16:52:56 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-cancellation-test/6002/ (13/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:11 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ssl-compression/756/ (14/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:13 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-stabilization-f69489-compat/1250/ (6/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:59 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-openjdk11/1346/ (4/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:58 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-format/5962/ (15/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:14 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-asterix-app/6350/ (8/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:02 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-txnlog/1157/ (7/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:00 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-no-installer-app/6139/ (10/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:06 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/11470/ (16/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:16 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-assemblies/6200/ (2/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:58 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-sonar/9942/ (3/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:58 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-storage/6561/ (5/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:58 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-sql-execution/5979/ (9/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:03 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ensure-ancestor/3984/ (11/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:51:07 + Gerrit-HasComments: No
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Simon Dew has uploaded this change for review. (
https://asterix-gerrit.ics.uci.edu/3452
Change subject: [NO ISSUE] Correct markup for window function documentation
..
[NO ISSUE] Correct markup for window function documentation
Correct indentation for code and follow-on paragraphs in bullets.
More descriptive aliases in LEAD and LAG examples.
Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730
---
M asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
1 file changed, 681 insertions(+), 681 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb
refs/changes/52/3452/1
diff --git a/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
b/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
index e661064..64bcf17 100644
--- a/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
+++ b/asterixdb/asterix-doc/src/main/markdown/builtins/14_window.md
@@ -39,7 +39,7 @@
* Syntax:
- CUME_DIST() OVER ([window-partition-clause] window-order-clause)
+CUME_DIST() OVER ([window-partition-clause] window-order-clause)
* Returns the percentile rank of the current tuple as part of the cumulative
distribution – that is, the number of tuples ranked lower than or equal to
@@ -63,60 +63,60 @@
* Example:
- For each author, find the cumulative distribution of all messages
- in order of message ID.
+For each author, find the cumulative distribution of all messages
+in order of message ID.
- SELECT m.messageId, m.authorId, CUME_DIST() OVER (
-PARTITION BY m.authorId
-ORDER BY m.messageId
- ) AS `rank`
- FROM GleambookMessages AS m;
+SELECT m.messageId, m.authorId, CUME_DIST() OVER (
+ PARTITION BY m.authorId
+ ORDER BY m.messageId
+) AS `rank`
+FROM GleambookMessages AS m;
* The expected result is:
- [
-{
- "rank": 0.2,
- "messageId": 2,
- "authorId": 1
-},
-{
- "rank": 0.4,
- "messageId": 4,
- "authorId": 1
-},
-{
- "rank": 0.6,
- "messageId": 8,
- "authorId": 1
-},
-{
- "rank": 0.8,
- "messageId": 10,
- "authorId": 1
-},
-{
- "rank": 1,
- "messageId": 11,
- "authorId": 1
-},
-{
- "rank": 0.5,
- "messageId": 3,
- "authorId": 2
-},
-{
- "rank": 1,
- "messageId": 6,
- "authorId": 2
-}
- ]
+[
+ {
+"rank": 0.2,
+"messageId": 2,
+"authorId": 1
+ },
+ {
+"rank": 0.4,
+"messageId": 4,
+"authorId": 1
+ },
+ {
+"rank": 0.6,
+"messageId": 8,
+"authorId": 1
+ },
+ {
+"rank": 0.8,
+"messageId": 10,
+"authorId": 1
+ },
+ {
+"rank": 1,
+"messageId": 11,
+"authorId": 1
+ },
+ {
+"rank": 0.5,
+"messageId": 3,
+"authorId": 2
+ },
+ {
+"rank": 1,
+"messageId": 6,
+"authorId": 2
+ }
+]
### dense_rank ###
* Syntax:
- DENSE_RANK() OVER ([window-partition-clause] window-order-clause)
+DENSE_RANK() OVER ([window-partition-clause] window-order-clause)
* Returns the dense rank of the current tuple – that is, the number of
distinct tuples preceding this tuple in the current window partition, plus
@@ -146,67 +146,67 @@
* Example:
- For each author, find the dense rank of all messages in order of location.
+For each author, find the dense rank of all messages in order of location.
- SELECT m.authorId, m.messageId, m.senderLocation[1] as longitude,
- DENSE_RANK() OVER (
-PARTITION BY m.authorId
-ORDER BY m.senderLocation[1]
- ) AS `rank`
- FROM GleambookMessages AS m;
+SELECT m.authorId, m.messageId, m.senderLocation[1] as longitude,
+DENSE_RANK() OVER (
+ PARTITION BY m.authorId
+ ORDER BY m.senderLocation[1]
+) AS `rank`
+FROM GleambookMessages AS m;
* The expected result is:
- [
-{
- "rank": 1,
- "authorId": 1,
- "messageId": 10,
- "longitude": 70.01
-},
-{
- "rank": 2,
- "authorId": 1,
- "messageId": 11,
- "longitude": 77.49
-},
-{
- "rank": 3,
- "authorId": 1,
- "messageId": 2,
- "longitude": 80.87
-},
-{
- "rank": 3,
- "authorId": 1,
- "messageId": 8,
- "longitude": 80.87
-},
-{
-
Change in asterixdb[master]: [NO ISSUE] Correct markup for window function documentation
Jenkins has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/3452 ) Change subject: [NO ISSUE] Correct markup for window function documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/hyracks-gerrit/5897/ (1/16) -- To view, visit https://asterix-gerrit.ics.uci.edu/3452 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I34627d2b50b18d4e429e43807161b85eeab9e730 Gerrit-Change-Number: 3452 Gerrit-PatchSet: 1 Gerrit-Owner: Simon Dew Gerrit-Reviewer: Jenkins Gerrit-Comment-Date: Fri, 21 Jun 2019 16:50:57 + Gerrit-HasComments: No
