pinot设置多值存储、默认值

pinot可以支持多值存储，默认值存储

多值主要是配置schema，要在相关的字段中设置  "singleValueField": 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": {}

  }

}