apache-pinot-table.json

{
  "tableName": "MovieRating",
  "tableType": "REALTIME",
  "segmentsConfig": {
    "replication": 1,
    "timeColumnName": "ratedOn",
    "timeType": "DAYS",
    "retentionTimeUnit": "DAYS",
    "retentionTimeValue": 5,
    "schemaName": "MovieRatingSchema",
    "replicasPerPartition": "1"
  },
  "tenants": {},
  "fieldConfigList":[
    {
      "name":"movie",
      "encodingType":"RAW",
      "indexType":"TEXT"
    },
    {
      "name":"country",
      "encodingType":"RAW",
      "indexType":"TEXT"
    },
    {
      "name":"city",
      "encodingType":"RAW",
      "indexType":"TEXT"
    }
  ],
  "tableIndexConfig": {
    "starTreeIndexConfigs": [{
      "dimensionsSplitOrder" : [
        "country",
        "city",
        "movie"
      ],
      "skipStarNodeCreationForDimensions" : [],
      "functionColumnPairs" : [
        "AVG__rating"
      ],
      "maxLeafRecords": 1
    }
    ],
    "loadMode": "MMAP",
    "invertedIndexColumns": [
      "movie"
    ],
    "rangeIndexColumns": [
      "ratedOn"
    ],
    "streamConfigs": {
      "streamType": "kafka",
      "stream.kafka.consumer.type": "simple",
      "stream.kafka.topic.name": "movie-rating",
      "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": "PLAINTEXT://kafka:29092",
      "realtime.segment.flush.threshold.time": "12h",
      "realtime.segment.flush.threshold.size": "250000",
      "stream.kafka.consumer.prop.auto.offset.reset": "smallest"
    }
  },
  "metadata": {
    "customConfigs": {}
  }
}