Hi Juan, Thank you very much for pointing this out.
I have mentioned the concern regarding table name length in the documentation [1] [1] https://docs.wso2.com/display/SP400/Incremental+Analysis Best Regards Charini On Fri, Jan 12, 2018 at 9:35 PM, Juan Pablo Vadell <[email protected]> wrote: > Hi Charini, > > I tried the release version of WSO2 SP 4.0 and works great with Oracle DB > now with the add of AGG_ before the column name. > > One thing that maybe you must add/change in the docs, is the that Oracle > table name size that I pointed out before. > > Your example Tutorial 6: Streaming Data Summarization (Incremental > Aggregation) <https://docs.wso2.com/pages/viewpage.action?pageId=80721826> has > the name *SweetProductionAggregation *and this not work with Oracle > because, for example, the name SweetProductionAggregation_SECONDS has 34 > of length, and the limit is 30. > > Thank you for correct the problem of aggregation with Oracle DB, because > we are doing some POCs and our clients has mainly Oracle. > > Juan Pablo Vadell | *VATROX* > > > On Tue, Jan 9, 2018 at 1:52 AM, Charini Nanayakkara <[email protected]> > wrote: > >> Hi Juan, >> >> Thanks again for reporting this issue. We will look into it. >> >> Best Regards >> Charini >> >> On Tue, Jan 9, 2018 at 10:18 AM, Juan Pablo Vadell <[email protected]> >> wrote: >> >>> Hi Charini, >>> >>> You must take care of Oracle table names Max Length, that is 30 until >>> 12.1 and 128 bytes from 12.2. >>> >>> I created an issue at github before you, but in the wrong place. >>> https://github.com/wso2/siddhi/issues/717 >>> >>> Thank you, >>> >>> Juan Pablo Vadell | *VATROX* >>> >>> On Tue, Jan 9, 2018 at 12:35 AM, Charini Nanayakkara <[email protected]> >>> wrote: >>> >>>> 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> >>>> >>> >>> >> >> >> -- >> *Charini Vimansha Nanayakkara* >> Software Engineer at WSO2 >> >> Mobile: 0714126293 >> E-mail: [email protected] >> Blog: http://www.charini.me/ >> >> <http://wso2.com/signature> >> > > -- *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
