Hi all,
I have a use case where I need to retrieve data from an aggregation using
regex.
The exact scenario is that I have a comma separated string, where I need to
retrieve data if one of the comma separated value is matching a string.
I used String tokenizer to tokenize the comma separated val
Can you share your Siddhi code block here?
I feel like what you have request here is similar to the functionality of
SQL IN operator, rather than a regex.
Also, have you tried to use the regexp function [1]?
[1]
https://wso2-extensions.github.io/siddhi-execution-string/api/4.0.19/#regexp-functio
Here's my Siddhi Code:
@App:name("IsAnalytics_Authentication_Aggregations")
@App:description("Handle Event from IS and save data in a table for Overall
Authentication")
@source(type='inMemory',
topic='IsAnalytics.Authentication.Common.OutputSinkFromProcessedAuthenticationDataStream',
@map(type='p
Hi Sajith,
The use case is when retrieving data from aggregations,
from StockStream as S join TradeAggregation as T
on S.symbol == T.symbol
within "2014-02-15 00:00:00 +05:30", "2014-03-16 00:00:00 +05:30"
per "days" select S.symbol, T.total, T.avgPrice insert into
AggregateStockStream;
H
Hi,
Let me explain how we evaluate the on condition with respect to the RDBMS
store. in the find() method location[1], all the condition expressions are
converted the RDBMS queries with SQL WHERE Clauses. But as per your
requirement instead of converted to WHERE Clause, it should be converted
to R