Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Taewoo Kim has submitted this change and it was merged. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation - user model changes: no - storage format changes: no - interface changes: no Details: Update all examples in the fulltext and similarity documentation using SQLPP. Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Reviewed-on: https://asterix-gerrit.ics.uci.edu/2567 Sonar-Qube: Jenkins Tested-by: Jenkins Contrib: Jenkins Integration-Tests: Jenkins Reviewed-by: Ian Maxon --- M asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md M asterixdb/asterix-doc/src/site/markdown/aql/similarity.md 2 files changed, 105 insertions(+), 133 deletions(-) Approvals: Anon. E. Moose #1000171: Jenkins: Verified; No violations found; ; Verified Ian Maxon: Looks good to me, approved diff --git a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md index bc0b398..1328ed9 100644 --- a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md +++ b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md @@ -44,73 +44,61 @@ ftcontains(Expression1, Expression2, {FullTextOption}) ftcontains(Expression1, Expression2) -For example, we can execute the following query to find tweet messages where the `message-text` field includes +For example, we can execute the following query to find Chirp messages where the `messageText` field includes “voice” as a word. Please note that an FTS search is case-insensitive. Thus, "Voice" or "voice" will be evaluated as the same word. -use dataverse TinySocial; - -for $msg in dataset TweetMessages -where ftcontains($msg.message-text, "voice", {"mode":"any"}) -return {"id": $msg.id} - -The DDL and DML of TinySocial can be found in [ADM: Modeling Semistructed Data in AsterixDB](primer.html#ADM:_Modeling_Semistructed_Data_in_AsterixDB). - -The same query can be also expressed in the SQL++. - use TinySocial; -select element {"id":msg.id} -from TweetMessages as msg -where TinySocial.ftcontains(msg.`message-text`, "voice", {"mode":"any"}) +select element {"chirpId": msg.chirpId} +from ChirpMessages msg +where ftcontains(msg.messageText, "voice", {"mode":"any"}); + +The DDL and DML of TinySocial can be found in [ADM: Modeling Semistructed Data in AsterixDB](../sqlpp/primer-sqlpp.html#ADM:_Modeling_Semistructed_Data_in_AsterixDB). The `Expression1` is an expression that should be evaluable as a string at runtime as in the above example -where `$msg.message-text` is a string field. The `Expression2` can be a string, an (un)ordered list +where `msg.messageText` is a string field. The `Expression2` can be a string, an (un)ordered list of string value(s), or an expression. In the last case, the given expression should be evaluable into one of the first two types, i.e., into a string value or an (un)ordered list of string value(s). The following examples are all valid expressions. - ... where ftcontains($msg.message-text, "sound") - ... where ftcontains($msg.message-text, "sound", {"mode":"any"}) - ... where ftcontains($msg.message-text, ["sound", "system"], {"mode":"any"}) - ... where ftcontains($msg.message-text, {{"speed", "stand", "customization"}}, {"mode":"all"}) - ... where ftcontains($msg.message-text, let $keyword_list := ["voice", "system"] return $keyword_list, {"mode":"all"}) - ... where ftcontains($msg.message-text, $keyword_list, {"mode":"any"}) - -In the last example above, `$keyword_list` should evaluate to a string or an (un)ordered list of string value(s). + ... where ftcontains(msg.messageText, "sound") + ... where ftcontains(msg.messageText, "sound", {"mode":"any"}) + ... where ftcontains(msg.messageText, ["sound", "system"], {"mode":"any"}) + ... where ftcontains(msg.messageText, {{"speed", "stand", "customization"}}, {"mode":"all"}) The last `FullTextOption` parameter clarifies the given FTS request. If you omit the `FullTextOption` parameter, then the default value will be set for each possible option. Currently, we only have one option named `mode`. And as we extend the FTS feature, more options will be added. Please note that the format of `FullTextOption` is a record, thus you need to put the option(s) in a record `{}`. The `mode` option indicates whether the given FTS query is a conjunctive (AND) or disjunctive (OR) search request. -This option can be either `“any”` or `“all”`. The default value for `mode` is `“all”`. If one specifies `“any”`, -a disjunctive search will be conducted. For example, the following query will find documents whose `message-text` +This option can be either `“all”` (AND) or `“any”` (OR). The
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Ian Maxon has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Code-Review+2 -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian Maxon Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/6181/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Contrib+1 BAD Compatibility Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/3036/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Contrib+1 Analytics Compatibility Tests Successful https://goo.gl/Kvwodt : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: BAD Compatibility Tests Started https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/3036/ -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Analytics Compatibility Compilation Successful https://goo.gl/mpPpXz : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/6181/ -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-format/3263/ (9/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-assemblies/3519/ (6/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app/4017/ (12/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-sql-execution/3304/ (5/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/8767/ (1/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-asterix-app/3757/ (3/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ensure-ancestor/1311/ (2/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-cancellation-test/3291/ (10/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-storage/3835/ (11/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-sonar/7249/ (8/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/hyracks-gerrit/3216/ (7/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 3: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-no-installer-app/3735/ (4/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 3 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Contrib-2 Analytics Compatibility Tests Failed https://goo.gl/VRwYhp : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Contrib-2 Analytics Compatibility Tests Failed https://goo.gl/9iootx : UNSTABLE -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Integration-Tests+1 Integration Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/6161/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Contrib+1 BAD Compatibility Tests Successful https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/3024/ : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: BAD Compatibility Tests Started https://asterix-jenkins.ics.uci.edu/job/asterixbad-compat/3024/ -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Analytics Compatibility Compilation Successful https://goo.gl/skEd19 : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/6161/ -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Ian2 Maxon Gerrit-Reviewer: Jenkins Gerrit-Reviewer: Michael Carey Gerrit-Reviewer: Till Westmann Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-sql-execution/3282/ (10/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ensure-ancestor/1289/ (2/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-assemblies/3497/ (6/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/hyracks-gerrit/3194/ (5/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/8745/ (11/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app/3994/ (7/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-sonar/7229/ (4/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-no-installer-app/3713/ (3/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-cancellation-test/3268/ (9/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Anon. E. Moose #1000171 has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Analytics Compatibility Compilation Successful https://goo.gl/C9qjTv : SUCCESS -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-storage/3813/ (1/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Taewoo Kim has uploaded a new patch set (#2). Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation - user model changes: no - storage format changes: no - interface changes: no Details: Update all examples in the fulltext and similarity documentation using SQLPP. Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 --- M asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md M asterixdb/asterix-doc/src/site/markdown/aql/similarity.md 2 files changed, 105 insertions(+), 133 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/67/2567/2 -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: newpatchset Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-format/3241/ (8/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 2: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-asterix-app/3735/ (12/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 2 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Integration Tests Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-integration-tests/6160/ -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Taewoo Kim has uploaded a new change for review. https://asterix-gerrit.ics.uci.edu/2567 Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation - user model changes: no - storage format changes: no - interface changes: no Details: Update all examples in the fulltext and similarity documentation using SQLPP. Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 --- M asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md M asterixdb/asterix-doc/src/site/markdown/aql/similarity.md 2 files changed, 104 insertions(+), 132 deletions(-) git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb refs/changes/67/2567/1 diff --git a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md index bc0b398..1328ed9 100644 --- a/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md +++ b/asterixdb/asterix-doc/src/site/markdown/aql/fulltext.md @@ -44,73 +44,61 @@ ftcontains(Expression1, Expression2, {FullTextOption}) ftcontains(Expression1, Expression2) -For example, we can execute the following query to find tweet messages where the `message-text` field includes +For example, we can execute the following query to find Chirp messages where the `messageText` field includes “voice” as a word. Please note that an FTS search is case-insensitive. Thus, "Voice" or "voice" will be evaluated as the same word. -use dataverse TinySocial; - -for $msg in dataset TweetMessages -where ftcontains($msg.message-text, "voice", {"mode":"any"}) -return {"id": $msg.id} - -The DDL and DML of TinySocial can be found in [ADM: Modeling Semistructed Data in AsterixDB](primer.html#ADM:_Modeling_Semistructed_Data_in_AsterixDB). - -The same query can be also expressed in the SQL++. - use TinySocial; -select element {"id":msg.id} -from TweetMessages as msg -where TinySocial.ftcontains(msg.`message-text`, "voice", {"mode":"any"}) +select element {"chirpId": msg.chirpId} +from ChirpMessages msg +where ftcontains(msg.messageText, "voice", {"mode":"any"}); + +The DDL and DML of TinySocial can be found in [ADM: Modeling Semistructed Data in AsterixDB](../sqlpp/primer-sqlpp.html#ADM:_Modeling_Semistructed_Data_in_AsterixDB). The `Expression1` is an expression that should be evaluable as a string at runtime as in the above example -where `$msg.message-text` is a string field. The `Expression2` can be a string, an (un)ordered list +where `msg.messageText` is a string field. The `Expression2` can be a string, an (un)ordered list of string value(s), or an expression. In the last case, the given expression should be evaluable into one of the first two types, i.e., into a string value or an (un)ordered list of string value(s). The following examples are all valid expressions. - ... where ftcontains($msg.message-text, "sound") - ... where ftcontains($msg.message-text, "sound", {"mode":"any"}) - ... where ftcontains($msg.message-text, ["sound", "system"], {"mode":"any"}) - ... where ftcontains($msg.message-text, {{"speed", "stand", "customization"}}, {"mode":"all"}) - ... where ftcontains($msg.message-text, let $keyword_list := ["voice", "system"] return $keyword_list, {"mode":"all"}) - ... where ftcontains($msg.message-text, $keyword_list, {"mode":"any"}) - -In the last example above, `$keyword_list` should evaluate to a string or an (un)ordered list of string value(s). + ... where ftcontains(msg.messageText, "sound") + ... where ftcontains(msg.messageText, "sound", {"mode":"any"}) + ... where ftcontains(msg.messageText, ["sound", "system"], {"mode":"any"}) + ... where ftcontains(msg.messageText, {{"speed", "stand", "customization"}}, {"mode":"all"}) The last `FullTextOption` parameter clarifies the given FTS request. If you omit the `FullTextOption` parameter, then the default value will be set for each possible option. Currently, we only have one option named `mode`. And as we extend the FTS feature, more options will be added. Please note that the format of `FullTextOption` is a record, thus you need to put the option(s) in a record `{}`. The `mode` option indicates whether the given FTS query is a conjunctive (AND) or disjunctive (OR) search request. -This option can be either `“any”` or `“all”`. The default value for `mode` is `“all”`. If one specifies `“any”`, -a disjunctive search will be conducted. For example, the following query will find documents whose `message-text` +This option can be either `“all”` (AND) or `“any”` (OR). The default value for `mode` is `“all”`. If one specifies `“any”`, +a disjunctive search will be conducted. For example, the following query will find documents whose `messageText`
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-assemblies/3496/ (2/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-asterix-app/3734/ (7/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-sonar/7228/ (4/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/hyracks-gerrit/3193/ (6/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-ensure-ancestor/1288/ (10/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-cancellation-test/3267/ (12/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app-sql-execution/3281/ (3/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-verify-no-installer-app/3712/ (5/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-asterix-app/3993/ (8/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-source-format/3240/ (1/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-gerrit-notopic/8744/ (11/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No
Change in asterixdb[master]: [ASTERIXDB-2349][SITE] Revise fulltext and similarity docume...
Jenkins has posted comments on this change. Change subject: [ASTERIXDB-2349][SITE] Revise fulltext and similarity documentation .. Patch Set 1: Build Started https://asterix-jenkins.ics.uci.edu/job/asterix-verify-storage/3812/ (9/12) -- To view, visit https://asterix-gerrit.ics.uci.edu/2567 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: comment Gerrit-Change-Id: Icd9c5bc6249feb03b4297bdc84b5f3aa0efcdc47 Gerrit-PatchSet: 1 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Taewoo Kim Gerrit-Reviewer: Jenkins Gerrit-HasComments: No