>From Janhavi Tripurwar <[email protected]>: Janhavi Tripurwar has submitted this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20286?usp=email )
Change subject: [ASTERIXDB-3642][DOC]: Fix interval join condition in docs ...................................................................... [ASTERIXDB-3642][DOC]: Fix interval join condition in docs Change-Id: Ica17e0f40ee87fc4270bc823f256add3f1febc4a Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20286 Integration-Tests: Jenkins <[email protected]> Tested-by: Jenkins <[email protected]> Reviewed-by: Janhavi Tripurwar <[email protected]> Reviewed-by: Ali Alsuliman <[email protected]> --- M asterixdb/asterix-doc/src/main/interval_join/interval_join.md 1 file changed, 9 insertions(+), 9 deletions(-) Approvals: Jenkins: Verified; Verified Ali Alsuliman: Looks good to me, approved Janhavi Tripurwar: Looks good to me, but someone else must approve Anon. E. Moose #1000171: diff --git a/asterixdb/asterix-doc/src/main/interval_join/interval_join.md b/asterixdb/asterix-doc/src/main/interval_join/interval_join.md index bde7869..a8dc3db 100644 --- a/asterixdb/asterix-doc/src/main/interval_join/interval_join.md +++ b/asterixdb/asterix-doc/src/main/interval_join/interval_join.md @@ -42,15 +42,15 @@ Here is what each of the functions represent if A represents the first interval parameter, and B represents the second set interval parameter: -| Function | Condition | -|-------------------------|-------------------------| -| Before(A, B) and After(B, A) | A.end < B.start | -| Covers(A, B) and Covered_by(B, A) | A.start <= B.start and A.end >= B.end | -| Ends(A, B) and Ended_by(B, A) | A.end = B.end and A.start >= B.start | -| Meets(A, B) and Met_by(B, A) | A.end = B.start | -| Overlaps(A, B) and Overlapped_by(B, A) | A.start < B.start and B.start > A.end and A.end > B.start | -| Overlapping(A, B)| (A.start >= B.start and B.start < A.end) or (B.end <= A.end and B.end < A.start)| -| Starts(A, B) and Started_by(B, A) | A.start = B.start and A.end <= B.end | +| Function | Condition | +|-------------------------|----------------------------------------------------------------------------------| +| Before(A, B) and After(B, A) | A.end < B.start | +| Covers(A, B) and Covered_by(B, A) | A.start <= B.start and A.end >= B.end | +| Ends(A, B) and Ended_by(B, A) | A.end = B.end and A.start >= B.start | +| Meets(A, B) and Met_by(B, A) | A.end = B.start | +| Overlaps(A, B) and Overlapped_by(B, A) | A.start < B.start AND A.end > B.start AND A.end < B.end | +| Overlapping(A, B)| A.start < B.end and A.end > B.start | +| Starts(A, B) and Started_by(B, A) | A.start = B.start and A.end <= B.end | ### <a id="Range_hint"> Using a Range Hint </a> -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20286?usp=email To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings?usp=email Gerrit-MessageType: merged Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: Ica17e0f40ee87fc4270bc823f256add3f1febc4a Gerrit-Change-Number: 20286 Gerrit-PatchSet: 4 Gerrit-Owner: Janhavi Tripurwar <[email protected]> Gerrit-Reviewer: Ali Alsuliman <[email protected]> Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian Maxon <[email protected]> Gerrit-Reviewer: Janhavi Tripurwar <[email protected]> Gerrit-Reviewer: Jenkins <[email protected]>
