I’ve got error when tried to open an index that has a field with type geo_points. Here is the error:
DATA_READ ERROR: IllegalStateException
Line 1
Column 2051
Field geo_location
SQL Query SELECT * FROM "sample-index"."_doc"
(java.lang.IllegalStateException) null
com.dremio.plugins.elastic.execution.WriteHolders$InvalidWriteHolder.writeList():58
com.dremio.plugins.elastic.execution.FieldReadDefinition.writeList():172
com.dremio.plugins.elastic.execution.ElasticsearchJsonReader.writeDeclaredList():365
com.dremio.plugins.elastic.execution.ElasticsearchJsonReader.writeDeclaredMap():320
com.dremio.plugins.elastic.execution.ElasticsearchJsonReader.writeToVector():224
com.dremio.plugins.elastic.execution.ElasticsearchJsonReader.write():192
com.dremio.plugins.elastic.execution.ElasticsearchRecordReader.next():279
com.dremio.plugins.elastic.ElasticDatasetMetadata.getSampledSchema():162
com.dremio.plugins.elastic.ElasticDatasetMetadata.build():97
com.dremio.plugins.elastic.ElasticsearchStoragePlugin.getDatasetMetadata():402
com.dremio.exec.catalog.DatasetSaver.save():98
com.dremio.exec.catalog.DatasetSaver.save():142
com.dremio.exec.catalog.DatasetManager.getTableFromPlugin():356
com.dremio.exec.catalog.DatasetManager.getTable():207
com.dremio.exec.catalog.CatalogImpl.getTable():179
com.dremio.exec.catalog.SourceAccessChecker.lambda$getTable$3():126
com.dremio.exec.catalog.SourceAccessChecker.getIfVisible():90
com.dremio.exec.catalog.SourceAccessChecker.getTable():126
com.dremio.exec.catalog.DelegatingCatalog.getTable():88
com.dremio.exec.catalog.CachingCatalog.getTable():93
com.dremio.exec.catalog.DremioCatalogReader.getTable():94
com.dremio.exec.catalog.DremioCatalogReader.getTable():71
org.apache.calcite.sql.validate.EmptyScope.getTableNamespace():76
org.apache.calcite.sql.validate.DelegatingScope.getTableNamespace():197
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():102
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197
org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60
org.apache.calcite.sql.validate.AbstractNamespace.validate():84
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924
org.apache.calcite.sql.SqlSelect.validate():226
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899
org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609
com.dremio.exec.planner.sql.SqlConverter.validate():226
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():196
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():181
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():177
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():47
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():59
com.dremio.exec.work.foreman.AttemptManager.plan():428
com.dremio.exec.work.foreman.AttemptManager.lambda$run$1():337
com.dremio.service.commandpool.CommandWrapper.run():62
com.dremio.context.RequestContext.run():95
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Here is the sample of geo_location field:
{
"geo_location" : [
35.9333344,
31.85
]
}
Some of the value is empty array. I don’t understand why this error appeared because dremio seems to support geo_shape but not support geo_point?