Re: [Dev] WSO2 SP Aggregation problem

Hi Juan, Just to keep you informed that any issues we get to know about in future, would be fixed through our update process (https://wso2.com/updates/wum) Thank you Charini On Sat, Jan 13, 2018 at 8:26 AM, Charini Nanayakkara <chari...@wso2.com> wrote: > Hi Juan, > > Than

Re: [Dev] WSO2 SP Aggregation problem

_SECONDS has 34 > of length, and the limit is 30. > > Thank you for correct the problem of aggregation with Oracle DB, because > we are doing some POCs and our clients has mainly Oracle. > > Juan Pablo Vadell | *VATROX* > > > On Tue, Jan 9, 2018 at 1:52 AM, Charin

Re: [Dev] WSO2 SP Aggregation problem

28 bytes from 12.2. > > I created an issue at github before you, but in the wrong place. > https://github.com/wso2/siddhi/issues/717 > > Thank you, > > Juan Pablo Vadell | *VATROX* > > On Tue, Jan 9, 2018 at 12:35 AM, Charini Nanayakkara <chari...@wso2.com> > wrote:

Re: [Dev] WSO2 SP Aggregation problem

Hi Juan, Thank you for reporting this issue. SP aggregation has only been tested with MySql so far. We have updated that information in SP documentation [1] As explained by you, the reported issue arises in Oracle, due to not specifying attributes starting with underscore (such as _TIMESTAMP)

Re: [Dev] [SP]Incremental processing not working with SP + RDBMS

;go...@wso2.com> wrote: > Hi Charini, > > Are you sure that this worked with the RDBMS store before? It has not > supported function namespaces from the start. > > Thanks, > > On 2 November 2017 at 11:40, Charini Nanayakkara <chari...@wso2.com> > wrote: >

Re: [Dev] [SP]Incremental processing not working with SP + RDBMS

Hi Suho, Incremental processing is not working with RDBMS due to a new change introduced at RDBMS extension level which rejects function namespaces. I will discuss this with Gokul as well and find a solution. Thank you Charini On Thu, Nov 2, 2017 at 3:10 AM, Sriskandarajah Suhothayan

Re: [Dev] WSO2 ESB Broker Re-Connection in case of Broker Failure

Hi Junior, I tried this scenario with a topic subscription but couldn't reproduce the issue. The exact same jndi properties were used whereas the axis configurations were same except for the fact that I tried with a topic. Not sure whether it's specific to queues. Will test that scenario and

Re: [Dev] Siddhi CEP

Hi Hasara, You can use any IDE such as Intellij, Eclipse, etc. No such plugins are needed to build the source code. Just checkout the code and play around with the test cases to get a basic idea. Best Regards Charini On Sun, Sep 10, 2017 at 9:18 PM, Hasara Maithree <

Re: [Dev] About the Siddhi expression

Hi, Sorry for the delayed response. As per the existing implementation, we cannot achieve your requirement with sort window due to two reasons. 1) We cannot alter the value of an event which has already been consumed by a stream. Therefore, we can't change the value of event (id: 3, score: 30)

Re: [Dev] About the Siddhi expression

Hi, Just to clarify your requirement. Do you want to get the topK (highest frequency values) [1] and then sort the result [2] in ascending or descending order? [1] https://docs.wso2.com/display/SIDDHIEXTENSIONS/Extrema+Extension#ExtremaExtension-topK [2]

Re: [Dev] [C5] Obtaining hostname in carbon kernel 5

m the kernel in C5. We have to see how to expose > these kind of information from the relevant transport implementation level. > > On Thu, Jan 26, 2017 at 5:10 PM, Charini Nanayakkara <chari...@wso2.com> > wrote: > >> Hi, >> >> We are in the process of movi

[Dev] [C5] Obtaining hostname in carbon kernel 5

Hi, We are in the process of moving carbon analytics common to C5. When migrating, it was noted that C5 disallows us to obtain the hostname (or the server url) unlike in C4. Since the hostname is required in many instances, is it going to be supported in a latter version of C5? Or is there an

Re: [Dev] WSO2 Committers += Malintha Fernando

Congratz Malintha!!! :) On Tue, Nov 8, 2016 at 8:29 PM, Menaka Jayawardena wrote: > Congratz Malintha.! > > On Tue, Nov 8, 2016 at 2:46 PM, Irunika Weeraratne > wrote: > >> Congratulations Malintha!!! >> >> Best Regards, >> Irunika >> >> *Irunika Weeraratne*

Re: [Dev] WSO2 Committers += Kasun Thennakoon

Congrats Kasun!!! :) On Fri, Oct 21, 2016 at 8:02 PM, Sameera Gunarathne wrote: > Congrats Kasun !!!  > On Oct 21, 2016 1:18 PM, "Kasun Thennakoon" wrote: > >> Thanks everyone. >> >> On Fri, Oct 21, 2016 at 12:22 PM, Prakhash Sivakumar

Re: [Dev] WSO2 Committers += Ashen Weerathunga

Congrats Ashen! :) On Tue, Oct 4, 2016 at 3:56 PM, Mushthaq Rumy wrote: > Congrats Ashen! > > Thanks & Regards, > Mushthaq > > On Tue, Oct 4, 2016 at 2:39 PM, Sameera Ramasinghe > wrote: > >> Congratz Ashen!! >> >> On Tue, Oct 4, 2016 at 1:56 PM, Grainier

Re: [Dev] View Contents of In-Memory table

Hi Aneela, You can use RDBMS tables for this requirement. Please refer to [1]. You may use WSO2_CARBON_DB as the datasource. Follow the steps in [2] to access your tables [1] https://docs.wso2.com/display/CEP410/SiddhiQL+Guide+3.0#SiddhiQLGuide3.0-RDBMSEventTable [2]

Re: [Dev] sub query in siddhi QL

Hi Aneela, If you need to count all the records (without grouping by employee_id) you will have to do something similar to the following. (This is just one way of addressing your requirement) (define an in-memory table to store count) define table CountTable (count long); from

[Dev] [CEP] Publishing Binary/Thrift Data using Java Client: Non-blocking Publisher vs Blocking Publisher

Hi, In a recent implementation where a stream needed to be simulated with 10 million events using a Java client, using publish method (blocking publisher) was a better option than using tryPublish (non-blocking publisher). The 10 million events were successfully sent to the stream with publish

Re: [Dev] Siddhi Query : group by results

Hi Aneela, The siddhi query you have specified processes each and every incoming event. Since processing is done in real time, when the first event for ts= 2016-05-08 09:00 arrives it gives count = 1 (due to no events with ts = 2016-05-08 09:00 having arrived earlier). When second event with ts =

Re: [Dev] [CEP] wso2 cep java.lang.OutOfMemoryError: GC overhead limit exceeded

mit >> check can be disabled by adding the option -XX:-UseGCOverheadLimit to >> the command line. >> >> More information can be found here [1] >> >> >> [1] : >> http://www.oracle.com/technetwork/java/javase/gc-tuning-6-140523.html#par_gc.oom >>

[Dev] [CEP] wso2 cep java.lang.OutOfMemoryError: GC overhead limit exceeded

Hi, I get $subject when attempting to execute Max aggregate function when a 3 min duration is considered on an external time stamp. The overhead limit is likely to have exceeded due to 9 000 000 events arriving within this 3 min duration. Any suggestions on resolving this issue are appreciated.

Re: [Dev] no viable alternative at input @import

Hi, Apart from what Yashothara pointed out, change how you have used dateFormat extension in the query. time:dateFormat (ts,'-MM-dd HH:mm') is the proper way of using the function Thanks Charini On Fri, Jun 17, 2016 at 12:34 PM, Yashothara Shanmugarajah < yashoth...@wso2.com> wrote: > Hi,

Re: [Dev] [wso2/siddhi] Has problems with Siddhi group by with a time window (#154)

Hi Liangfei.Su, This is the expected behavior of external time window. Since it's a moving time window, you get an output for each incoming event. Due to the presence of the group by keyword, it would give an aggregate output by considering the events with the same uuid and similarityId, which

Re: [Dev] [DAS][LA] Add multiple events to a single event

Hi, Can we not use WSO2 ESB as a mediator in achieving this task. To my knowledge we can do some processing with ESB prior to sending received information as mail. http://sparkletechthoughts.blogspot.com/2012/08/how-to-send-mails-using-wso2-esb.html

Re: [Dev] WSO2 DAS: SPARK SQL query with UNION producing errors

i Charini, > In addition, if you could get the same resultset using sql joins (instead > of unions) you can increase the performance when querying. > When using union's, it takes a considerable effort when combining the > distinct results. > > On Tue, Mar 8, 2016 at 1:23 PM, Charini Nan

Re: [Dev] WSO2 DAS: SPARK SQL query with UNION producing errors

> > SparkSQL parser only takes one single select element in the insert > queries, and at the end of a select query it expects a limit (if > available). therefore, you need to wrap the subsequent select statements > into one select element. > > Hope this resolves your issue > > Best

[Dev] WSO2 DAS: SPARK SQL query with UNION producing errors

Hi, The following query was attempted to be executed when performing batch analytics with WSO2 DAS using Spark SQL. Tables 'First', 'Middle' and 'Third' are required to be combined and written to table 'All_three'. INSERT OVERWRITE TABLE All_three SELECT SYMBOL, VOLUME FROM First UNION SELECT