pinot設定多値記憶、デフォルト値

pinotは多値ストレージ、デフォルトストレージをサポートします
多値は主にschemaを構成し、関連するフィールドにsingleValueFiledを設定するにはfalse
デフォルトでは、schemaの関連フィールドに「defaultNullValue」を設定します.99

{

  "dimensionFieldSpecs": [

    {

      "dataType": "STRING",

      "name": "FA0010000000"

    },

    {

      "dataType": "DOUBLE",

      "name": "FA0050000000",

      "defaultNullValue": 99

    },

      {

      "dataType": "STRING",

      "name": "FA0070180000",

      "singleValueField": false

    }

  ],

  "timeFieldSpec": {

    "incomingGranularitySpec": {

      "timeType": "DAYS",

      "dataType": "INT",

      "name": "time_day"

    }

  },

  "schemaName": "BASIC_0800"

}

テーブルの構成関連

{

  "tableName": "BASIC_08001",

  "tableType": "REALTIME",

  "segmentsConfig": {

    "timeColumnName": "time",

    "timeType": "MILLISECONDS",

    "segmentPushType": "APPEND",

    "segmentAssignmentStrategy": "BalanceNumSegmentAssignmentStrategy",

    "schemaName": "BASIC_0800",

    "replicasPerPartition": "2"

  },

  "tenants": {},

  "tableIndexConfig": {

"invertedIndexColumns": ["FA0010000000","FA0010010000"],

    "loadMode": "MMAP",

    "streamConfigs": {

      "streamType": "kafka",

      "stream.kafka.consumer.type": "LowLevel",

      "stream.kafka.topic.name": "true2",

      "stream.kafka.decoder.class.name": "org.apache.pinot.plugin.stream.kafka.KafkaJSONMessageDecoder",

      "stream.kafka.hlc.zk.connect.string": "192.168.12.22:2181",

      "stream.kafka.consumer.factory.class.name": "org.apache.pinot.plugin.stream.kafka20.KafkaConsumerFactory",

    

       "stream.kafka.broker.list": "192.168.12.21:6667"

    }

  },

  "metadata": {

    "customConfigs": {}

  }

}