Adding Ruk. Thanks & Regards Shavindri Dissanayake Technical Writer
WSO2 Inc. lean.enterprise.middleware On Wed, Jan 25, 2017 at 5:03 PM, Shazni Nazeer <sha...@wso2.com> wrote: > There's also a change in the second param of the incrementalParams as DAY, > HOUR instead of number of seconds as mentioned in the documentation. > > @Documentation - could this page be corrected? > > On Wed, Jan 25, 2017 at 4:52 PM, Shazni Nazeer <sha...@wso2.com> wrote: > >> Thanks Fazlan. >> >> That'll be useful. Only difference I see is primary key comes prior to >> incrementalParams. I'll try this out. >> >> On Wed, Jan 25, 2017 at 4:44 PM, Fazlan Nazeem <fazl...@wso2.com> wrote: >> >>> Hi Shazni, >>> >>> Please check [1] for how we use incrementalParams in APIM-Analytics >>> scripts. >>> >>> [1] https://git.io/vMxJq >>> >>> On Wed, Jan 25, 2017 at 1:29 PM, Shazni Nazeer <sha...@wso2.com> wrote: >>> >>>> Hi, >>>> >>>> I have a spark table as shown below. >>>> >>>> CREATE TEMPORARY TABLE APIHourlyTrafficSummary using CarbonAnalytics >>>> options (tableName "org_wso2telco_analytics_hub_s >>>> tream_traffic_summary_per_hour", >>>> schema " >>>> year INT -i, >>>> month INT -i, >>>> day INT -i, >>>> hour INT -i, >>>> eventTimeStamp STRING -i, >>>> api STRING -i, >>>> serviceProvider STRING -i, >>>> apiPublisher STRING -i, >>>> applicationName STRING -i, >>>> operatorId STRING -i, >>>> isSuccess BOOLEAN -i, >>>> msisdn STRING -i, >>>> direction STRING -i, >>>> totalCount INTEGER -i, >>>> serviceProviderId STRING -i, >>>> operatorName STRING -i, >>>> apiPublisherID STRING -i, >>>> apiID STRING -i, >>>> department STRING -i, >>>> applicationId STRING -i", >>>> primaryKeys "year,month,day,hour,eventTime >>>> Stamp,api,serviceProvider,apiPublisher,applicationName,opera >>>> torId,isSuccess,msisdn,direction" >>>> ); >>>> >>>> I want to add incrementalParams as mentioned in the following [1]. >>>> >>>> [1] https://docs.wso2.com/display/DAS310/Incremental+Processing >>>> >>>> Therefore I have added the line as below. >>>> >>>> CREATE TEMPORARY TABLE APIHourlyTrafficSummary using >>>> CarbonAnalytics options (tableName "org_wso2telco_analytics_hub_s >>>> tream_traffic_summary_per_hour", >>>> schema " >>>> year INT -i, >>>> month INT -i, >>>> day INT -i, >>>> hour INT -i, >>>> eventTimeStamp STRING -i, >>>> api STRING -i, >>>> serviceProvider STRING -i, >>>> apiPublisher STRING -i, >>>> applicationName STRING -i, >>>> operatorId STRING -i, >>>> isSuccess BOOLEAN -i, >>>> msisdn STRING -i, >>>> direction STRING -i, >>>> totalCount INTEGER -i, >>>> serviceProviderId STRING -i, >>>> operatorName STRING -i, >>>> apiPublisherID STRING -i, >>>> apiID STRING -i, >>>> department STRING -i, >>>> applicationId STRING -i", >>>> * incrementalParams "APIHourlyTrafficSummary, 0",* >>>> primaryKeys "year,month,day,hour,eventTime >>>> Stamp,api,serviceProvider,apiPublisher,applicationName,opera >>>> torId,isSuccess,msisdn,direction" >>>> ); >>>> >>>> But executing the script throws an error. looks like a syntax error. >>>> What am I doing wrong here? >>>> >>>> -- >>>> Shazni Nazeer >>>> Associate Technical Lead | WSO2 >>>> >>>> Mob : +94 777737331 >>>> LinkedIn : http://lk.linkedin.com/in/shazninazeer >>>> Blog : http://shazninazeer.blogspot.com >>>> >>>> <http://wso2.com/signature> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> Dev@wso2.org >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> Thanks & Regards, >>> >>> Fazlan Nazeem >>> >>> *Software Engineer* >>> >>> *WSO2 Inc* >>> Mobile : +94772338839 >>> <%2B94%20%280%29%20773%20451194> >>> fazl...@wso2.com >>> >> >> >> >> -- >> Shazni Nazeer >> Associate Technical Lead | WSO2 >> >> Mob : +94 777737331 >> LinkedIn : http://lk.linkedin.com/in/shazninazeer >> Blog : http://shazninazeer.blogspot.com >> >> <http://wso2.com/signature> >> > > > > -- > Shazni Nazeer > Associate Technical Lead | WSO2 > > Mob : +94 777737331 > LinkedIn : http://lk.linkedin.com/in/shazninazeer > Blog : http://shazninazeer.blogspot.com > > <http://wso2.com/signature> > > -- > You received this message because you are subscribed to the Google Groups > "WSO2 Documentation Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to documentation+unsubscr...@wso2.com. > For more options, visit https://groups.google.com/a/wso2.com/d/optout. >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
