Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-15197

Support temporal graph queries with DAY and WEEKDAY windows

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Resolved
    • None
    • 9.0
    • None
    • None

    Description

      The initial implementation of temporal graph queries supported ten second time windows which is useful for log analytics use cases. This ticket will allow for event correlation across daily windows, which is useful for many different fields, including event correlation in the stock market

      This ticket will add the support for daily windows and add the syntax to support other time windows as well. Follow-on tickets will add more time windows.

      Below is the sample syntax for a temporal graph query with a window of 1 DAY.

      nodes(daily_stock_returns,
            search(daily_stock_returns, 
                   q="ticker_s:jpm AND change_d:[2 TO *]", 
                   fl="day_s", 
                   sort="change_d desc",
                   rows="50"),
            walk="day_s->day_s",
            gather="ticker_s",
            fq="change_d:[1 TO *]",
            window="1DAY",
            lag="2",      
            count(*))
      

      This query counts all tickers that are up by atleast 1, in a one day window, 2 days prior to a rise in the ticker jpm by atleast 2. This surfaces tickers that most frequently rise two days before jpm rises.

      This demonstrates event correlation in stock market data.

      Attachments

        1. SOLR-15197.patch
          5 kB
          Joel Bernstein
        2. SOLR-15197.patch
          10 kB
          Joel Bernstein
        3. SOLR-15197.patch
          12 kB
          Joel Bernstein

        Activity

          Commit 4c76bcc65017a1ff20dd64eedd63d4976a38a554 in solr's branch refs/heads/main from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=4c76bcc ]

          SOLR-15197: Support temporal graph queries with daily windows

          jira-bot ASF subversion and git services added a comment - Commit 4c76bcc65017a1ff20dd64eedd63d4976a38a554 in solr's branch refs/heads/main from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=4c76bcc ] SOLR-15197 : Support temporal graph queries with daily windows

          Commit 73963cafe452ed571b43a9d4bd9524d9b53d5421 in solr's branch refs/heads/main from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=73963ca ]

          SOLR-15197: Add WEEKDAY windows and forward and backword looking windows.

          jira-bot ASF subversion and git services added a comment - Commit 73963cafe452ed571b43a9d4bd9524d9b53d5421 in solr's branch refs/heads/main from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=73963ca ] SOLR-15197 : Add WEEKDAY windows and forward and backword looking windows.

          Commit 0f54d9616d240ca4749ea86a7e73e00fd562d766 in solr's branch refs/heads/main from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=0f54d96 ]

          SOLR-15197: Update CHANGES.txt

          jira-bot ASF subversion and git services added a comment - Commit 0f54d9616d240ca4749ea86a7e73e00fd562d766 in solr's branch refs/heads/main from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=0f54d96 ] SOLR-15197 : Update CHANGES.txt

          Commit 3e83d79d67a3d3aa71b547595a2893228041fc41 in solr's branch refs/heads/branch_9x from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=3e83d79 ]

          SOLR-15197: Update CHANGES.txt

          jira-bot ASF subversion and git services added a comment - Commit 3e83d79d67a3d3aa71b547595a2893228041fc41 in solr's branch refs/heads/branch_9x from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=3e83d79 ] SOLR-15197 : Update CHANGES.txt

          Commit 1b2b3970a2f893aeeea8f6e145b923377101f72c in solr's branch refs/heads/branch_9_0 from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=1b2b397 ]

          SOLR-15197: Update CHANGES.txt

          jira-bot ASF subversion and git services added a comment - Commit 1b2b3970a2f893aeeea8f6e145b923377101f72c in solr's branch refs/heads/branch_9_0 from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=1b2b397 ] SOLR-15197 : Update CHANGES.txt

          Commit 20f9583e8fb37461c6bf0ae783d1ab4e9f99401a in solr's branch refs/heads/main from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=20f9583 ]

          SOLR-15197: Update docs

          jira-bot ASF subversion and git services added a comment - Commit 20f9583e8fb37461c6bf0ae783d1ab4e9f99401a in solr's branch refs/heads/main from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=20f9583 ] SOLR-15197 : Update docs

          Commit 3e835fc953c37e07e22a47ec6be2e031fa560cfd in solr's branch refs/heads/branch_9x from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=3e835fc ]

          SOLR-15197: Update docs

          jira-bot ASF subversion and git services added a comment - Commit 3e835fc953c37e07e22a47ec6be2e031fa560cfd in solr's branch refs/heads/branch_9x from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=3e835fc ] SOLR-15197 : Update docs

          Commit 2051a485dd09aa5fadba7fd0d754da7674c04fb0 in solr's branch refs/heads/branch_9_0 from Joel Bernstein
          [ https://gitbox.apache.org/repos/asf?p=solr.git;h=2051a48 ]

          SOLR-15197: Update docs

          jira-bot ASF subversion and git services added a comment - Commit 2051a485dd09aa5fadba7fd0d754da7674c04fb0 in solr's branch refs/heads/branch_9_0 from Joel Bernstein [ https://gitbox.apache.org/repos/asf?p=solr.git;h=2051a48 ] SOLR-15197 : Update docs
          janhoy Jan Høydahl added a comment -

          Closing after the 9.0.0 release

          janhoy Jan Høydahl added a comment - Closing after the 9.0.0 release

          People

            jbernste Joel Bernstein
            jbernste Joel Bernstein
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: