I'm using wso2am-analytics-2.0.0 (with wso2am-2.0.0) and I'm trying to deploy new data publisher.
1-In the Data explorer of the API Manager Analytics, I found tables like API_LAST_ACCESS_TIME_SUMMARY,API_REQUEST_SUMMARY... which I suppose contains summary data, but shouldn't the summarized data live only in the external RDBMS (I was expecting to find only event stream tables)
2-For the APIM_LAST_ACCESS_TIME_SCRIPT ,I found this spark script:
<!--create temp table for API Last access time summary table in RDBMS-->
create temporary table APILastAccessSummaryData using CarbonJDBC options (dataSource "WSO2AM_STATS_DB", tableName "API_LAST_ACCESS_TIME_SUMMARY",
schema "tenantDomain STRING ,
apiPublisher STRING ,
api STRING ,
version STRING ,
userId STRING ,
context STRING ,
max_request_time LONG ",
primaryKeys "tenantDomain,apiPublisher,api"
);
<!--create table for API last access time summary in DAL-->
CREATE TEMPORARY TABLE API_LAST_ACCESS_TIME_SUMMARY_FINAL USING CarbonAnalytics OPTIONS (tableName "API_LAST_ACCESS_TIME_SUMMARY",
schema "tenantDomain string -i,
apiPublisher string -i,
api string -i,
version string -i,
userId string -i,
context string -i,
max_request_time long -i",
primaryKeys "tenantDomain,apiPublisher,api"
);
<!-- inserting API last access time summary data in DAL to RDBMS-->
INSERT INTO TABLE APILastAccessSummaryData select tenantDomain, apiPublisher, api, version, userId, context, max_request_time from API_LAST_ACCESS_TIME_SUMMARY_FINAL;
The second query(CREATE TEMPORARY TABLE API_LAST_ACCESS_TIME_SUMMARY_FINAL..) is using the analytics table API_LAST_ACCESS_TIME_SUMMARY,but I didn't get how and whenthis table is being populated by events received?
3-I didn't find any delete/drop query for the summarized shared database and data in this DB is being always overrided (not appended),how this behaviour is impelmented?
