Hi,dear dremioer：
when I connected the postgresql8.2 with dremio3.0,there happened this error information:
UnrecognizedPropertyException: Unrecognized field “skippedColumns” (class com.dremio.exec.store.jdbc.JdbcSubScan), not marked as ignorable (10 known properties: “schema”, “initialAllocation”, “userName”, “referenced-tables”, “@id”, “columns”, “sql”, “maxAllocation”, “cost”, “pluginId”])
Hi @bjbhjsj
Does this happen when you add the source? Can you please send us the server.log?
Thanks
@balaji.ramaswamy
SYSTEM ERROR: UnrecognizedPropertyException: Unrecognized field “skippedColumns” (class com.dremio.exec.store.jdbc.JdbcSubScan), not marked as ignorable (10 known properties: “schema”, “initialAllocation”, “userName”, “referenced-tables”, “@id”, “columns”, “sql”, “maxAllocation”, “cost”, “pluginId”]) at [Source: org.xerial.snappy.SnappyInputStream@274b9b2d; line: 1, column: 5282] (through reference chain: com.dremio.exec.physical.config.SingleSender[“child”]->com.dremio.exec.store.dfs.easy.EasyWriter[“child”]->com.dremio.exec.physical.config.Project[“child”]->com.dremio.exec.physical.config.Project[“child”]->com.dremio.exec.store.jdbc.JdbcSubScan[“skippedColumns”]) Fragment 1:0 [Error Id: 5b46b89d-5789-4458-b648-a9d5cf50d1e7 on gpstandby:-1] (com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException) Unrecognized field “skippedColumns” (class com.dremio.exec.store.jdbc.JdbcSubScan), not marked as ignorable (10 known properties: “schema”, “initialAllocation”, “userName”, “referenced-tables”, “@id”, “columns”, “sql”, “maxAllocation”, “cost”, “pluginId”]) at [Source: org.xerial.snappy.SnappyInputStream@274b9b2d; line: 1, column: 5282] (through reference chain: com.dremio.exec.physical.config.SingleSender[“child”]->com.dremio.exec.store.dfs.easy.EasyWriter[“child”]->com.dremio.exec.physical.config.Project[“child”]->com.dremio.exec.physical.config.Project[“child”]->com.dremio.exec.store.jdbc.JdbcSubScan[“skippedColumns”]) com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException.from():62 com.fasterxml.jackson.databind.DeserializationContext.reportUnknownProperty():851 com.fasterxml.jackson.databind.deser.std.StdDeserializer.handleUnknownProperty():1085 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.handleUnknownProperty():1392 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.handleUnknownVanilla():1370 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():230 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():193 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():408 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1127 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserializeFromObject():236 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1098 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():117 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91 com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142 com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():493 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():384 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1127 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserializeFromObject():236 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1098 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():117 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91 com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142 com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():493 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():384 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1127 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserializeFromObject():236 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1098 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():117 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91 com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142 com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():493 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():384 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1127 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserializeFromObject():236 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1098 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():117 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91 com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142 com.fasterxml.jackson.databind.deser.SettableBeanProperty.deserialize():493 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeWithErrorWrapping():465 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeUsingPropertyBased():384 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeFromObjectUsingNonDefault():1127 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserializeFromObject():236 com.fasterxml.jackson.databind.deser.BeanDeserializerBase.deserializeWithObjectId():1098 com.fasterxml.jackson.databind.deser.BeanDeserializer._deserializeOther():166 com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize():135 com.fasterxml.jackson.module.afterburner.deser.SuperSonicBeanDeserializer.deserialize():117 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer._deserializeTypedForId():120 com.fasterxml.jackson.databind.jsontype.impl.AsPropertyTypeDeserializer.deserializeTypedFromObject():91 com.fasterxml.jackson.databind.deser.AbstractDeserializer.deserializeWithType():142 com.fasterxml.jackson.databind.deser.impl.TypeWrappedDeserializer.deserialize():63 com.fasterxml.jackson.databind.ObjectReader._bindAndClose():1579 com.fasterxml.jackson.databind.ObjectReader.readValue():1166 com.dremio.common.serde.ProtobufByteStringSerDe.readValue():129 com.dremio.exec.planner.PhysicalPlanReader.readValue():207 com.dremio.exec.planner.PhysicalPlanReader.readFragmentOperator():196 com.dremio.sabot.exec.fragment.FragmentExecutor.setupExecution():330 com.dremio.sabot.exec.fragment.FragmentExecutor.run():234 com.dremio.sabot.exec.fragment.FragmentExecutor.access$800():86 com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():591 com.dremio.sabot.task.AsyncTaskWrapper.run():107 com.dremio.sabot.task.slicing.SlicingThread.run():102