Hi , I made the change, but still the same 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 >> >> > -- *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
