Hi Tishan, Your answer solved the issue. Thanks heaps.
On Wed, Nov 5, 2014 at 6:18 PM, Tishan Dahanayakage <tis...@wso2.com> wrote: > Hi Chamin, > Adding to Sheshika you need to change your Siddhi query as follows too. > You can't rename inside a condition. Changes made at line 2. Please refer > [1] for Siddhi language specification. > > from transactionInStream join avgTable > on transactionInStream.pan == avgTable.pan and transactionInStream.amount > <= ((avgTable.avg_amount)*4/3) > select transactionInStream.pan , transactionInStream.amount, > avgTable.avg_amount > insert into lowAmountStream > > [1] https://docs.wso2.com/display/CEP310/Siddhi+Language+Specification > > On Wed, Nov 5, 2014 at 6:11 PM, Seshika Fernando <sesh...@wso2.com> wrote: > >> Could it be that you have used av*a*Table.avg_amount instead of >> av*g*Table.avg_amount >> ? >> >> On Wed, Nov 5, 2014 at 6:01 PM, Chamin Nalinda <cha...@wso2.com> wrote: >> >>> Hi >>> >>> Appreciate your help to solve the following issue. >>> >>> *Error Message* >>> >>> *line 4:67 no viable alternative at input '.'* >>> >>> *Siddhi query* >>> >>> // *Imported from transactionInStream:1.0.0* >>> define stream *transactionInStream* ( >>> *transaction_id* string, *pan* string, *ticket_type* string, *amount* >>> double, *date_time* long) >>> >>> >>> define table avgTable ( pan string, avg_amount double ) from (' >>> datasource.name'='transactionInfoDBSource', >>> 'database.name'='transactionInfoDB', >>> 'table.name'='avgTable' ); >>> >>> from transactionInStream join avgTable >>> on transactionInStream.pan == avgTable.pan and >>> transactionInStream.amount as transactionInStream.avg_amount <= >>> ((avaTable.avg_amount)*4/3) >>> select transactionInStream.pan , transactionInStream.amount, >>> avgTable.avg_amount >>> insert into lowAmountStream >>> >>> -- >>> *Chamin Nalinda* >>> >>> Intern - Engineering >>> WSO2 Inc. http://www.wso2.com >>> lean.enterprise.middleware >>> >>> Mobile: (+94) 77 241 66 04 >>> Linkedin: https://www.linkedin.com/in/chaminnalinda >>> Web: http://www.ckreativity.com >>> Blog: http://techspiro.blogspot.com/ >>> >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Tishan Dahanayakage > Software Engineer > WSO2, Inc. > Mobile:+94 716481328 > > Disclaimer: This communication may contain privileged or other > confidential information and is intended exclusively for the addressee/s. > If you are not the intended recipient/s, or believe that you may have > received this communication in error, please reply to the sender indicating > that fact and delete the copy you received and in addition, you should not > print, copy, re-transmit, disseminate, or otherwise use the information > contained in this communication. Internet communications cannot be > guaranteed to be timely, secure, error or virus-free. The sender does not > accept liability for any errors or omissions. > -- *Chamin Nalinda* Intern - Engineering WSO2 Inc. http://www.wso2.com lean.enterprise.middleware Mobile: (+94) 77 241 66 04 Linkedin: https://www.linkedin.com/in/chaminnalinda Web: http://www.ckreativity.com Blog: http://techspiro.blogspot.com/
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
