WSO2 BAM summary tables for API manager not being populated -

i have installed api manager , bam products view api manager statistics. looking @ bam tables, can see data populated apirequestdata , apiresponsedata none of summary data tables being populated.

the am_stats_analyzer_xxx script scheduled run. have tried running insert script manually.

when ran manually following query, didn't populate apirequestsummarydata table either. however, when executed "select portion" of query, did bring result set.

insert overwrite table apirequestsummarydata select api, api_version,version, apipublisher, consumerkey,userid,context,max(requesttime) max_request_time,sum(request) total_request_count,hostname,  year(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )) year, month(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )) month,day(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )) day,concat(substring(from_unixtime(cast(requesttime/1000 bigint), 'yyyy-mm-dd hh:mm:ss'),0,16),':00') time apirequestdata group api,api_version,version,apipublisher,consumerkey,userid,context,hostname,year(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )), month(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )),day(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )),hour(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )),minute(from_unixtime(cast(requesttime/1000 bigint),'yyyy-mm-dd hh:mm:ss.sss' )),substring(from_unixtime(cast(requesttime/1000 bigint), 'yyyy-mm-dd hh:mm:ss'),0,16); 

apirequestsummarydata table created using

create external table if not exists apirequestsummarydata (api string, api_version string, version string, apipublisher string, consumerkey string,userid string,context string, max_request_time bigint, total_request_count int, hostname string,year smallint,month smallint,day smallint, time string) stored  'org.wso2.carbon.hadoop.hive.jdbc.storage.jdbcstoragehandler' tblproperties ( 'wso2.carbon.datasource.name'='wso2am_stats_db', 'hive.jdbc.update.on.duplicate' = 'true', 'hive.jdbc.primary.key.fields'='api,api_version,version,apipublisher,consumerkey,userid,context,hostname,time', 'hive.jdbc.table.create.query' = 'create table api_request_summary ( api varchar(100), api_version varchar(100), version varchar(100), apipublisher varchar(100),consumerkey varchar(100),userid varchar(100), context varchar(100),max_request_time bigint, total_request_count int, hostname varchar(100), year smallint, month smallint, day smallint, time varchar(30),primary key(api,api_version,apipublisher,consumerkey,userid,context,hostname,time))' );