CREATE EXTERNAL TABLE IF NOT EXISTS APIRequestData (key STRING,api STRING, api_version STRING,userId STRING, context STRING,version STRING,trackingCode STRING,referer STRING, responseTime BIGINT,request INT, requestTime BIGINT, resource STRING, method STRING, hostName STRING, apiPublisher STRING) STORED BY 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler' WITH SERDEPROPERTIES ( 'wso2.carbon.datasource.name'='WSO2BAM_CASSANDRA_DATASOURCE', "cassandra.cf.name" = "org_wso2_apimgt_statistics_request", "cassandra.columns.mapping" = ":key,payload_api, payload_api_version,payload_userId,payload_context,payload_version, payload_trackingCode, payload_referer, payload_responseTime,payload_request, payload_requestTime, payload_resource, payload_method,payload_hostName,payload_apiPublisher" ); select api,api_version,apiPublisher,context, hostName,referer,responseTime from APIRequestData group by api,ap