Ravikumar Maddi
03/17/2021, 9:29 AM{
"tableName": "mytable",
"tableType": "REALTIME",
"segmentsConfig": {
"timeColumnName": "_source.sDate",
"timeType": "MILLISECONDS",
"schemaName": "myschema",
"replicasPerPartition": "1"
},
"tenants": {},
"tableIndexConfig": {
"loadMode": "MMAP",
"streamConfigs": {
"streamType": "kafka",
"stream.kafka.consumer.type": "lowlevel",
"stream.kafka.topic.name": "mytopic",
"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": "localhost:9876",
"realtime.segment.flush.threshold.time": "3600000",
"realtime.segment.flush.threshold.size": "50000",
"stream.kafka.consumer.prop.auto.offset.reset": "smallest"
}
},
"metadata": {
"customConfigs": {}
}
}
And
Schema Config:
{
"schemaName": "myschema",
"eventflow": [
{
"name": "_index",
"dataType": "INT"
},
{
"name": "_type",
"dataType": "STRING"
},
{
"name": "id",
"dataType": "INT"
},
{
"name": "_source.madids",
"datatype": "INT",
"singleValueField": false
},
],
"dateTimeFieldSpecs": [
{
"name": "_source.sDate",
"dataType": "STRING",
"format": "1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss",
"granularity": "1:DAYS"
}
]
}
Ken Krugler
03/17/2021, 2:51 PMeventflow
field? Shouldn’t that be named dimensionFieldSpecs
? And without a metricFieldSpecs
array of fields for doing aggregations, I’m not sure how you’re going to effectively use Pinot :)Chinmay Soman
03/17/2021, 6:00 PM