[jira] [Resolved] (SOLR-15197) Support temporal graph queries with DAY and WEEKDAY windows

["Joel Bernstein (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-15197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joel Bernstein resolved SOLR-15197.
-----------------------------------
    Resolution: Resolved

> Support temporal graph queries with DAY and WEEKDAY windows
> -----------------------------------------------------------
>
>                 Key: SOLR-15197
>                 URL: https://issues.apache.org/jira/browse/SOLR-15197
>             Project: Solr
>          Issue Type: Improvement
>            Reporter: Joel Bernstein
>            Assignee: Joel Bernstein
>            Priority: Major
>             Fix For: 9.0
>
>         Attachments: SOLR-15197.patch, SOLR-15197.patch, SOLR-15197.patch
>
>
> 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.
> {code:java}
> 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(*))
> {code}
> 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.
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org