Mayank
webConferenceId
?Charles
03/31/2021, 12:31 AMMayank
Charles
03/31/2021, 12:32 AMMayank
Charles
03/31/2021, 12:33 AMMayank
webSiteId
?Charles
03/31/2021, 12:34 AMJackie
03/31/2021, 12:34 AMCharles
03/31/2021, 12:35 AM{
“schemaName”:“realtime_sjc_wmequality_report”,
“dimensionFieldSpecs”:[
{
“name”:“webexSiteName”,
“dataType”:“STRING”
},
{
“name”:“webexConferenceId”,
“dataType”:“LONG”
},
{
“name”:“webexSiteId”,
“dataType”:“LONG”
},
{
“name”:“correlationId”,
“dataType”:“STRING”
},
{
“name”:“metadataOsType”,
“dataType”:“STRING”
},
{
“name”:“metadataOsVersion”,
“dataType”:“STRING”
},
{
“name”:“metadataBrowserType”,
“dataType”:“STRING”
},
{
“name”:“metadataClientType”,
“dataType”:“STRING”
},
{
“name”:“metadataClientVersion”,
“dataType”:“STRING”
},
{
“name”:“metadataHardwareType”,
“dataType”:“STRING”
},
{
“name”:“metadataNetworkType”,
“dataType”:“STRING”
},
{
“name”:“audioMainReportTransportType”,
“dataType”:“STRING”
},
{
“name”:“videoMainReportTransportType”,
“dataType”:“STRING”
},
{
“name”:“day”,
“dataType”:“STRING”
}
],
“metricFieldSpecs”:[
{
“name”:“systemAverageCPU”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“processAverageCPU”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“osBitWidth”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“cpuBitWidth”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportRxE2eLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportRxE2eJitter”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportTxHbhLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportTxHbhJitter”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportRxHbhLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“audioMainReportRoundTripTime”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportRxE2eLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportRxE2eJitter”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportTxHbhLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportTxHbhJitter”,
“dataType”:“LONG”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportRxHbhLostPercent”,
“dataType”:“FLOAT”,
“defaultNullValue”:0
},
{
“name”:“videoMainReportRoundTripTime”,
“dataType”:“LONG”,
“defaultNullValue”:0
}
],
“dateTimeFieldSpecs”:[
{
“name”:“timestamp”,
“dataType”:“STRING”,
“format”“1MILLISECONDSSIMPLE DATE FORMATyyyy-MM-dd’T’HHmmss.SSS’Z’“,
“granularity”“1MILLISECONDS”
}
]
}{
“tableName”:“realtime_sjc_wmequality_report”,
“tableType”:“REALTIME”,
“segmentsConfig”:{
“timeColumnName”:“timestamp”,
“timeType”:“DAYS”,
“retentionTimeUnit”:“DAYS”,
“retentionTimeValue”:“90”,
“segmentPushType”:“APPEND”,
“segmentAssignmentStrategy”:“BalanceNumSegmentAssignmentStrategy”,
“schemaName”:“realtime_sjc_wmequality_report”,
“replication”:“2”,
“replicasPerPartition”:“2”
},
“tenants”:{},
“tableIndexConfig”:{
“loadMode”:“MMAP”,
“streamConfigs”:{
“streamType”:“kafka”,
“stream.kafka.consumer.type”:“LowLevel”,
“stream.kafka.topic.name”:“sj1_mqa_telemetry_wmequality_report”,
“stream.kafka.decoder.class.name”:“org.apache.pinot.plugin.stream.kafka.KafkaJSONMessageDecoder”,
“stream.kafka.consumer.factory.class.name”:“org.apache.pinot.plugin.stream.kafka20.KafkaConsumerFactory”,
“stream.kafka.broker.list”“10.241.89.1309092",
“realtime.segment.flush.threshold.time”: “24h”,
“realtime.segment.flush.threshold.size”: “300M”,
“stream.kafka.consumer.prop.auto.offset.reset”: “largest”
},
“invertedIndexColumns”:[
“webexSiteName”, “webexConferenceId”, “webexSiteId”, “correlationId”, “metadataOsType”, “metadataBrowserType”, “metadataClientType”,
“metadataHardwareType”, “metadataNetworkType”,“audioMainReportTransportType”,“videoMainReportTransportType”,“day”
],
“sortedColumn”:[“audioMainReportRxE2eLostPercent”,“audioMainReportRxE2eJitter”]
},
“metadata”{“customConfigs”{}}
}Jackie
03/31/2021, 12:38 AMCharles
03/31/2021, 12:39 AMJackie
03/31/2021, 12:45 AMselect * from table where websiteId = 8049967 limit 1000
? Want to see if the missing conferenceId is returned hereCharles
03/31/2021, 12:45 AMMayank
Charles
03/31/2021, 12:46 AMJackie
03/31/2021, 12:52 AMwebexSiteId = 8049967
Charles
03/31/2021, 12:53 AMJackie
03/31/2021, 12:55 AMselect * from realtime_sjc_wmequality_report where webexConferenceId = '189852985506937900' limit 1000
first to rule out the possibility of compilation problemCharles
03/31/2021, 12:56 AMJackie
03/31/2021, 1:08 AMCharles
03/31/2021, 1:11 AM