Hi Juan, Thank you for reporting this issue.
SP aggregation has only been tested with MySql so far. We have updated that information in SP documentation [1] As explained by you, the reported issue arises in Oracle, due to not specifying attributes starting with underscore (such as _TIMESTAMP) within quotation marks. We have created an issue in github for this [2]. We will work on fixing it. [1] https://docs.wso2.com/display/SP400/Incremental+Analysis [2] https://github.com/wso2-extensions/siddhi-store-rdbms/issues/72 Thank you Charini On Sun, Jan 7, 2018 at 10:01 AM, Juan Pablo Vadell <[email protected]> wrote: > Hi, > > I am trying to test the Siddhi Aggregation feature and found that don't > work with Oracle DB. > > The error I think is because you are trying to use _TIMESTAMP as column > name, and with Oracle you need to use double quotes at the column name like > "_TIMESTAMP", if not you will receive a > > *ORA-00911: invalid character* > > This is the complete error > > > > *[2018-01-07_01-13-51_009] ERROR {org.wso2.siddhi.core.table.Table} - > Error on 'AggProductionHistoryApp'. Failed to initialize store for table > name 'SweetProdAgg_MONTHS': Unable to initialize table > 'SweetProdAgg_MONTHS': ORA-00911: invalid character_ Error while connecting > to Table 'SweetProdAgg_MONTHS', will retry in '5 sec'. > (Encoded)org.wso2.siddhi.core.exception.ConnectionUnavailableException: > Failed to initialize store for table name 'SweetProdAgg_MONTHS': Unable to > initialize table 'SweetProdAgg_MONTHS': ORA-00911: invalid character* > > And other thing is that Oracle don't support long table names... so we > must take care of that. > > Thank you, > > Juan Pablo Vadell | *VATROX* > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Charini Vimansha Nanayakkara* Software Engineer at WSO2 Mobile: 0714126293 E-mail: [email protected] Blog: http://www.charini.me/ <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
