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 <[email protected]> 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 <[email protected]> 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 >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > _______________________________________________ > Dev mailing list > [email protected] > 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.
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
