Dremio - Hive Connectivity issue

VALIDATION ERROR: java.net.UnknownHostException: IOS-JO

SQL Query select * from cdr_data.movietitles

(java.lang.IllegalArgumentException) java.net.UnknownHostException: IOS-JO
org.apache.hadoop.security.SecurityUtil.buildTokenService():417
org.apache.hadoop.hdfs.NameNodeProxiesClient.createProxyWithClientProtocol():132
org.apache.hadoop.hdfs.DFSClient.():359
org.apache.hadoop.hdfs.DFSClient.():293
org.apache.hadoop.hdfs.DistributedFileSystem.initialize():157
org.apache.hadoop.fs.FileSystem.createFileSystem():2812
org.apache.hadoop.fs.FileSystem.access$200():100
org.apache.hadoop.fs.FileSystem$Cache.getInternal():2849
org.apache.hadoop.fs.FileSystem$Cache.get():2831
org.apache.hadoop.fs.FileSystem.get():389
org.apache.hadoop.fs.Path.getFileSystem():356
com.dremio.exec.store.dfs.FileSystemWrapperCreator.get():94
com.dremio.exec.store.dfs.FileSystemWrapperCreator.get():90
com.dremio.exec.store.hive.metadata.HiveMetadataUtils.inputPathExists():979
com.dremio.exec.store.hive.metadata.HiveMetadataUtils.getPartitionMetadata():751
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing.():117
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing.():51
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing$Builder.build():230
com.dremio.exec.store.hive.HiveStoragePlugin.listPartitionChunks():535
com.dremio.exec.catalog.DatasetSaver.save():96
com.dremio.exec.catalog.DatasetSaver.save():154
com.dremio.exec.catalog.DatasetManager.getTableFromPlugin():343
com.dremio.exec.catalog.DatasetManager.getTable():207
com.dremio.exec.catalog.CatalogImpl.getTable():134
com.dremio.exec.catalog.DelegatingCatalog.getTable():61
com.dremio.exec.catalog.CachingCatalog.getTable():85
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():228
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():179
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():168
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():164
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():70
com.dremio.exec.work.foreman.AttemptManager.plan():387
com.dremio.exec.work.foreman.AttemptManager.lambda$run$0():296
com.dremio.service.commandpool.CommandWrapper.run():62
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748
Caused By (java.net.UnknownHostException) MPTIOS-JO
org.apache.hadoop.security.SecurityUtil.buildTokenService():417
org.apache.hadoop.hdfs.NameNodeProxiesClient.createProxyWithClientProtocol():132
org.apache.hadoop.hdfs.DFSClient.():359
org.apache.hadoop.hdfs.DFSClient.():293
org.apache.hadoop.hdfs.DistributedFileSystem.initialize():157
org.apache.hadoop.fs.FileSystem.createFileSystem():2812
org.apache.hadoop.fs.FileSystem.access$200():100
org.apache.hadoop.fs.FileSystem$Cache.getInternal():2849
org.apache.hadoop.fs.FileSystem$Cache.get():2831
org.apache.hadoop.fs.FileSystem.get():389
org.apache.hadoop.fs.Path.getFileSystem():356
com.dremio.exec.store.dfs.FileSystemWrapperCreator.get():94
com.dremio.exec.store.dfs.FileSystemWrapperCreator.get():90
com.dremio.exec.store.hive.metadata.HiveMetadataUtils.inputPathExists():979
com.dremio.exec.store.hive.metadata.HiveMetadataUtils.getPartitionMetadata():751
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing.():117
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing.():51
com.dremio.exec.store.hive.metadata.HivePartitionChunkListing$Builder.build():230
com.dremio.exec.store.hive.HiveStoragePlugin.listPartitionChunks():535
com.dremio.exec.catalog.DatasetSaver.save():96
com.dremio.exec.catalog.DatasetSaver.save():154
com.dremio.exec.catalog.DatasetManager.getTableFromPlugin():343
com.dremio.exec.catalog.DatasetManager.getTable():207
com.dremio.exec.catalog.CatalogImpl.getTable():134
com.dremio.exec.catalog.DelegatingCatalog.getTable():61
com.dremio.exec.catalog.CachingCatalog.getTable():85
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():228
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():179
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():168
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():164
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():70
com.dremio.exec.work.foreman.AttemptManager.plan():387
com.dremio.exec.work.foreman.AttemptManager.lambda$run$0():296
com.dremio.service.commandpool.CommandWrapper.run():62
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748

@Eedupuganti

Is “IOS-JO” the metastore host? Can you check hive-site.xml and make sure the metastore host matches what is given in Dremio - Hive source