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
