Null pointer exception while creating table

[chintan789]

{
"schemaName": "test",
"dimensionFieldSpecs": [
{"name": "kpi_name", "dataType": "STRING"},
{"name": "kpi_type", "dataType": "STRING"},
{"name": "entity_id", "dataType": "STRING"},
{"name": "source", "dataType": "STRING"},
{"name": "value_str", "dataType": "STRING"}
],
"metricFieldSpecs": [
{"name": "value_num", "dataType": "DOUBLE"}
],
"timeFieldSpec": {
"name": "timestampInEpoch",
"dataType": "LONG",
"timeType": "MILLISECONDS"
}
}

{
"tableName": "test",
"tableType": "REALTIME",
"segmentsConfig": {
"schemaName": "test",
"timeColumnName": "timestampInEpoch",
"timeType": "MILLISECONDS",
"replicasPerPartition": "1"
},
"tenants": {},
"tableIndexConfig": {
"loadMode": "MMAP",
"streamConfigs": {
"streamType": "kafka",
"stream.kafka.topic.name": "chalja-topic",
"stream.kafka.decoder.class.name": "org.apache.pinot.plugin.inputformat.json.JSONMessageDecoder",
"stream.kafka.consumer.factory.class.name": "org.apache.pinot.plugin.stream.kafka20.KafkaConsumerFactory",
"stream.kafka.broker.list": "pinot-kafka:9092",
"stream.kafka.consumer.prop.auto.offset.reset": "earliest",
"realtime.segment.flush.threshold.rows": "1",
"realtime.segment.flush.threshold.time": "1h",
"realtime.segment.flush.threshold.segment.size": "50M"
}
},
"metadata": {
"customConfigs": {}
}
}

docker exec -it pinot-controller /opt/pinot/bin/pinot-admin.sh AddTable
-tableConfigFile /opt/pinot/test_table.json
-schemaFile /opt/pinot/test_schema.json
-controllerHost pinot-controller
-controllerPort 9000
-exec

rg.apache.pinot.shaded.com.fasterxml.jackson.databind.JsonMappingException: N/A
at [Source: REDACTED (StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION disabled); line: 17, column: 3] (through reference chain: org.apache.pinot.spi.data.Schema["timeFieldSpec"])
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:275)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:659)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:647)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:143)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:302)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:169)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.DefaultDeserializationContext.readRootValue(DefaultDeserializationContext.java:342)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReader.java:2146)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:1676)
at org.apache.pinot.spi.utils.JsonUtils.fileToObject(JsonUtils.java:172)
at org.apache.pinot.tools.admin.command.AddTableCommand.lambda$execute$3(AddTableCommand.java:198)
at org.apache.pinot.tools.admin.command.AddTableCommand.attempt(AddTableCommand.java:211)
at org.apache.pinot.tools.admin.command.AddTableCommand.execute(AddTableCommand.java:198)
at org.apache.pinot.tools.Command.call(Command.java:33)
at org.apache.pinot.tools.Command.call(Command.java:29)
at picocli.CommandLine.executeUserObject(CommandLine.java:2031)
at picocli.CommandLine.access$1500(CommandLine.java:148)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2469)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2461)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2423)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2425)
at picocli.CommandLine.execute(CommandLine.java:2174)
at org.apache.pinot.tools.admin.PinotAdministrator.execute(PinotAdministrator.java:174)
at org.apache.pinot.tools.admin.PinotAdministrator.main(PinotAdministrator.java:210)
Caused by: java.lang.NullPointerException
at org.apache.pinot.shaded.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:904)
at org.apache.pinot.spi.data.Schema.addField(Schema.java:276)
at org.apache.pinot.spi.data.Schema.setTimeFieldSpec(Schema.java:252)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:141)
... 21 more
java.lang.IllegalStateException: org.apache.pinot.shaded.com.fasterxml.jackson.databind.JsonMappingException: N/A
at [Source: REDACTED (StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION disabled); line: 17, column: 3] (through reference chain: org.apache.pinot.spi.data.Schema["timeFieldSpec"])
at org.apache.pinot.tools.admin.command.AddTableCommand.attempt(AddTableCommand.java:214)
at org.apache.pinot.tools.admin.command.AddTableCommand.execute(AddTableCommand.java:198)
at org.apache.pinot.tools.Command.call(Command.java:33)
at org.apache.pinot.tools.Command.call(Command.java:29)
at picocli.CommandLine.executeUserObject(CommandLine.java:2031)
at picocli.CommandLine.access$1500(CommandLine.java:148)
at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2469)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2461)
at picocli.CommandLine$RunLast.handle(CommandLine.java:2423)
at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2277)
at picocli.CommandLine$RunLast.execute(CommandLine.java:2425)
at picocli.CommandLine.execute(CommandLine.java:2174)
at org.apache.pinot.tools.admin.PinotAdministrator.execute(PinotAdministrator.java:174)
at org.apache.pinot.tools.admin.PinotAdministrator.main(PinotAdministrator.java:210)
Caused by: org.apache.pinot.shaded.com.fasterxml.jackson.databind.JsonMappingException: N/A
at [Source: REDACTED (StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION disabled); line: 17, column: 3] (through reference chain: org.apache.pinot.spi.data.Schema["timeFieldSpec"])
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:275)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:659)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:647)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:143)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:302)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:169)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.DefaultDeserializationContext.readRootValue(DefaultDeserializationContext.java:342)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.ObjectReader._bindAndClose(ObjectReader.java:2146)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:1676)
at org.apache.pinot.spi.utils.JsonUtils.fileToObject(JsonUtils.java:172)
at org.apache.pinot.tools.admin.command.AddTableCommand.lambda$execute$3(AddTableCommand.java:198)
at org.apache.pinot.tools.admin.command.AddTableCommand.attempt(AddTableCommand.java:211)
... 13 more
Caused by: java.lang.NullPointerException
at org.apache.pinot.shaded.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:904)
at org.apache.pinot.spi.data.Schema.addField(Schema.java:276)
at org.apache.pinot.spi.data.Schema.setTimeFieldSpec(Schema.java:252)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:569)
at org.apache.pinot.shaded.com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:141)
... 21 more

[Jackie-Jiang]

timeFieldSpec is deprecated. Please use dateTimeFieldSpecs to configure time columns. Read more here