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
