Hi Thusitha, You have to create another temporary table in spark for the BAM_MEDIATION_STATS_DATA_PUBLISHER table as well.
ex: create temporary table BAM_MEDIATION_STATS_DATA_PUBLISHER using CarbonAnalytics options (tableName "BAM_MEDIATION_STATS_DATA_PUBLISHER") And then execute the Insert into query. Cheers, Sachith On Thu, Feb 11, 2016 at 2:56 PM, Thusitha Thilina Dayaratne < [email protected]> wrote: > Hi, > > I've setup ESB 4.8.1 along with DAS 3.0.1 and published some proxy > invoking stats to the DAS according to the [1] > I can see the data on the data explorer window for > the BAM_MEDIATION_STATS_DATA_PUBLISHER > > Then I executed following query to create a new table through the batch > analytic console in DAS > >> CREATE TEMPORARY TABLE tmpTable >> USING CarbonAnalytics >> OPTIONS (TABLENAME "TMP_DATA", schema "timestamp LONG, >> resource_id STRING, >> stats_type STRING, >> max_processing_time LONG, >> avg_processing_time LONG"); > > > Now I'm trying to insert the already published data to the newly created > table as with below query > > INSERT INTO TABLE tmpTable select timestamp, resource_id, stats_type, >> max_processing_time, avg_processing_time from >> BAM_MEDIATION_STATS_DATA_PUBLISHER; > > > But when I execute this query I'm getting below exception > > It says BAM_MEDIATION_STATS_DATA_PUBLISHER table doesn't exist. > > Did I missed anything? Or how should I insert the persisted stream data to > a separate table? > > [1] - > https://docs.wso2.com/display/BAM250/Setting+up+Mediation+Stat+Data+Agent > > Thanks > -- > Thusitha Dayaratne > Software Engineer > WSO2 Inc. - lean . enterprise . middleware | wso2.com > > Mobile +94712756809 > Blog alokayasoya.blogspot.com > About http://about.me/thusithathilina > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Sachith Withana Software Engineer; WSO2 Inc.; http://wso2.com E-mail: sachith AT wso2.com M: +94715518127 Linked-In: <http://goog_416592669>https://lk.linkedin.com/in/sachithwithana
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
