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
