[Dev] How to insert persisted stream data to a separate table

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

Re: [Dev] How to insert persisted stream data to a separate table

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