You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Anup Tiwari <an...@games24x7.com> on 2018/03/20 09:06:23 UTC
[Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Hi,
I am not able to read my hive tables in drill 1.13.0 and with same plugin conf
it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and let me
know if i have missed anything.
Hive Plugin :-
{ "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris":
"thrift://prod-hadoop-1xx.com:9083", "hive.metastore.sasl.enabled": "false",
"fs.default.name": "hdfs://prod-hadoop-1xx.com:9000" }}
Query :-
select id from hive.cad where log_date = '2018-03-18' limit 3
Error :-
2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where log_date =
'2018-03-18' limit 32018-03-20 14:25:27,354
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1, column
16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive')
org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive'
SQL Query null
[Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
~[drill-common-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:199)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.calcite.runtime.CalciteContextException: From line 1, column 16 to
line 1, column 19: Object 'cad' not found within 'hive' at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4703)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:127)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not found
within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames omitted
2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete before
shutting down2018-03-20 14:25:27,375
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
complete before shutting down
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Please find JIRA Link :-
https://issues.apache.org/jira/browse/DRILL-6293
On Sat, Mar 24, 2018 7:01 PM, Vitalii Diravka vitalii.diravka@gmail.com wrote:
Hi Anup.
The API of Hive2.3 is changed, but not documented fully yet.
So the difference should be found and resolved in Drill.
Please go ahead and create Jira [1] with description of your environment,
settings, CTAS and query, which doesn't work.
Thanks
[1] https://issues.apache.org/jira/projects/DRILL/
Kind regards
Vitalii
On Sat, Mar 24, 2018 at 12:50 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> I have not upgraded hive version but installed hive 2.3.2 on a server and
> tried to read data and its working.Can we have any workaround to run drill
> 1.13
> with hive 2.1 or up-gradation is the only option?
>
>
>
>
>
> On Sat, Mar 24, 2018 3:52 PM, Anup Tiwari anup.tiwari@games24x7.com
> wrote:
> Sorry for delayed response as i didn't got time to test this.
> @Vitalii, I have tried setting hive.metastore.client.capability.check=false
> in
> both ways which are :-
> 1. "hive.metastore.uris":
> "thrift://prod-hadoop-107.bom-prod.aws.games24x7.com:9083?
> hive.metastore.client.capability.check=false",
> in drill hive plugin and restarted metastore and tried to access hive
> tables
> via drill.
>
> 2. Added capability property in hive-site.xml and restarted metastore and
> tried
> to access hive tables via drill.
>
> Both ways didn't work. So does that mean Drill 1.13.0 version is
> compatible with
> Hive 2.3 and above?
>
>
>
>
>
> On Tue, Mar 20, 2018 6:28 PM, Vitalii Diravka vitalii.diravka@gmail.com
> wrote:
> @Anup, it should. If it isn't back compatible, it is a Hive issue.
>
>
>
>
> Hive Trift Metastore API was changed, but still isn't documented in
>
> cwiki.apache.org [1]
>
> *hive.metastore.client.capability.check *[2] property is true by default.
>
> Possibly changing this could help you.
>
> You can change it in Drill Hive plugin or in hive-site.xml
>
> Looks like, the issue will be the same for using hive-server2 2.3 version
>
> and hive-metastore 2.1 version. If so it is a Hive issue.
>
>
>
>
> So you can try to change the property before updating to Hive 2.3 version.
>
>
>
>
> [1] https://issues.apache.org/jira/browse/HIVE-15062
>
> [2]
>
> https://issues.apache.org/jira/browse/HIVE-15062?
> focusedCommentId=15659298&page=com.atlassian.jira.
> plugin.system.issuetabpanels:comment-tabpanel#comment-15659298
>
>
>
>
> Kind regards
>
> Vitalii
>
>
>
>
> On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <an...@games24x7.com>
>
> wrote:
>
>
>
>
> > Please find below information :-
>
> > Apache Hadoop 2.7.3Apache Hive 2.1.1
>
> > @Vitalii, For testing i can setup upgrade hive but upgrading hive will
>
> > take time
>
> > on our production server. Don't you think it should be back compatible?
>
> >
>
> >
>
> >
>
> >
>
> > On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com
>
> > wrote:
>
> > Anup,
>
> >
>
> >
>
> >
>
> >
>
> > "get_table_req" method is present in ThriftHiveMetastore header of Apache
>
> >
>
> > Hive 2.3 version.
>
> >
>
> > I believe Hive upgrade will help you. Probably it is Hive's back
>
> >
>
> > compatibility issue.
>
> >
>
> > Please let us know, whether upgrade helps.
>
> >
>
> >
>
> >
>
> >
>
> > Kind regards
>
> >
>
> > Vitalii
>
> >
>
> >
>
> >
>
> >
>
> > On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <
>
> > vitalii.diravka@gmail.com
>
> >
>
> > wrote:
>
> >>
>
> >
>
> >
>
> >
>
> >
>
> > Hi Anup,
>
> >>
>
> >
>
> >
>
> >>
>
> > Maybe we missed something after updating onto hive-2.3 client versions.
>
> >>
>
> >
>
> > Could you provide the following info:
>
> >>
>
> >
>
> > * What is your hive-server and metastore versions? If it is not 2.3
>
> >>
>
> >
>
> > version could you update onto this?
>
> >>
>
> >
>
> > * What is your hadoop distribution?
>
> >>
>
> >
>
> >
>
> >>
>
> > Kind regards
>
> >>
>
> >
>
> > Vitalii
>
> >>
>
> >
>
> >
>
> >>
>
> > On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
>
> >>
>
> >
>
> > wrote:
>
> >>
>
> >
>
> >
>
> >>
>
> > Okay, that confirms that the Hive storage plugin is not configured
>
> >>>
>
> >>
>
> > correctly - you are unable to access any Hive table. What's your Hive
>
> >>>
>
> >>
>
> > server version?
>
> >>>
>
> >>
>
> >
>
> >>>
>
> > On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>
> >>>
>
> >>
>
> > wrote:
>
> >>>
>
> >>
>
> >
>
> >>>
>
> > > Hi,
>
> >>>
>
> >>
>
> > > Please find my reply :-
>
> >>>
>
> >>
>
> > > Can you do a 'use hive;` followed by 'show tables;' and see if table
>
> >>>
>
> >>
>
> > > 'cad' is listed? : Did and got empty set(No rows selected).
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > If you try via hive shell, do you see it? : Yes
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > can you check if this is impacting accessing all hive tables (may be
>
> >>>
>
> >>
>
> > > create a new one and try) or if this is specific to a certain table /
>
> >>>
>
> >>
>
> > > database in Hive? : Tried 2 tables but getting same error. I have not
>
> >>>
>
> >>
>
> > tried
>
> >>>
>
> >>
>
> > > creating anew one, will try that and let you know.
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>
> >>>
>
> >>
>
> > wrote:
>
> >>>
>
> >>
>
> > > Down in the stack trace it's complaining that the table name 'cad' was
>
> >>>
>
> >>
>
> > not
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>
> >>>
>
> >>
>
> > table
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > 'cad' is listed?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > If you try via hive shell, do you see it?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > Also, can you check if this is impacting accessing all hive tables (may
>
> >>>
>
> >>
>
> > be
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > create a new one and try) or if this is specific to a certain table /
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > database in Hive?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > -Abhishek
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> >
>
> >>>
>
> >
>
> >>
>
> >
>
> >>
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > Regards,
>
> > Anup Tiwari
>
>
>
>
>
>
> Regards,
> Anup Tiwari
>
>
> Regards,
> Anup Tiwari
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Vitalii Diravka <vi...@gmail.com>.
Hi Anup.
The API of Hive2.3 is changed, but not documented fully yet.
So the difference should be found and resolved in Drill.
Please go ahead and create Jira [1] with description of your environment,
settings, CTAS and query, which doesn't work.
Thanks
[1] https://issues.apache.org/jira/projects/DRILL/
Kind regards
Vitalii
On Sat, Mar 24, 2018 at 12:50 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> I have not upgraded hive version but installed hive 2.3.2 on a server and
> tried to read data and its working.Can we have any workaround to run drill
> 1.13
> with hive 2.1 or up-gradation is the only option?
>
>
>
>
>
> On Sat, Mar 24, 2018 3:52 PM, Anup Tiwari anup.tiwari@games24x7.com
> wrote:
> Sorry for delayed response as i didn't got time to test this.
> @Vitalii, I have tried setting hive.metastore.client.capability.check=false
> in
> both ways which are :-
> 1. "hive.metastore.uris":
> "thrift://prod-hadoop-107.bom-prod.aws.games24x7.com:9083?
> hive.metastore.client.capability.check=false",
> in drill hive plugin and restarted metastore and tried to access hive
> tables
> via drill.
>
> 2. Added capability property in hive-site.xml and restarted metastore and
> tried
> to access hive tables via drill.
>
> Both ways didn't work. So does that mean Drill 1.13.0 version is
> compatible with
> Hive 2.3 and above?
>
>
>
>
>
> On Tue, Mar 20, 2018 6:28 PM, Vitalii Diravka vitalii.diravka@gmail.com
> wrote:
> @Anup, it should. If it isn't back compatible, it is a Hive issue.
>
>
>
>
> Hive Trift Metastore API was changed, but still isn't documented in
>
> cwiki.apache.org [1]
>
> *hive.metastore.client.capability.check *[2] property is true by default.
>
> Possibly changing this could help you.
>
> You can change it in Drill Hive plugin or in hive-site.xml
>
> Looks like, the issue will be the same for using hive-server2 2.3 version
>
> and hive-metastore 2.1 version. If so it is a Hive issue.
>
>
>
>
> So you can try to change the property before updating to Hive 2.3 version.
>
>
>
>
> [1] https://issues.apache.org/jira/browse/HIVE-15062
>
> [2]
>
> https://issues.apache.org/jira/browse/HIVE-15062?
> focusedCommentId=15659298&page=com.atlassian.jira.
> plugin.system.issuetabpanels:comment-tabpanel#comment-15659298
>
>
>
>
> Kind regards
>
> Vitalii
>
>
>
>
> On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <an...@games24x7.com>
>
> wrote:
>
>
>
>
> > Please find below information :-
>
> > Apache Hadoop 2.7.3Apache Hive 2.1.1
>
> > @Vitalii, For testing i can setup upgrade hive but upgrading hive will
>
> > take time
>
> > on our production server. Don't you think it should be back compatible?
>
> >
>
> >
>
> >
>
> >
>
> > On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com
>
> > wrote:
>
> > Anup,
>
> >
>
> >
>
> >
>
> >
>
> > "get_table_req" method is present in ThriftHiveMetastore header of Apache
>
> >
>
> > Hive 2.3 version.
>
> >
>
> > I believe Hive upgrade will help you. Probably it is Hive's back
>
> >
>
> > compatibility issue.
>
> >
>
> > Please let us know, whether upgrade helps.
>
> >
>
> >
>
> >
>
> >
>
> > Kind regards
>
> >
>
> > Vitalii
>
> >
>
> >
>
> >
>
> >
>
> > On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <
>
> > vitalii.diravka@gmail.com
>
> >
>
> > wrote:
>
> >>
>
> >
>
> >
>
> >
>
> >
>
> > Hi Anup,
>
> >>
>
> >
>
> >
>
> >>
>
> > Maybe we missed something after updating onto hive-2.3 client versions.
>
> >>
>
> >
>
> > Could you provide the following info:
>
> >>
>
> >
>
> > * What is your hive-server and metastore versions? If it is not 2.3
>
> >>
>
> >
>
> > version could you update onto this?
>
> >>
>
> >
>
> > * What is your hadoop distribution?
>
> >>
>
> >
>
> >
>
> >>
>
> > Kind regards
>
> >>
>
> >
>
> > Vitalii
>
> >>
>
> >
>
> >
>
> >>
>
> > On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
>
> >>
>
> >
>
> > wrote:
>
> >>
>
> >
>
> >
>
> >>
>
> > Okay, that confirms that the Hive storage plugin is not configured
>
> >>>
>
> >>
>
> > correctly - you are unable to access any Hive table. What's your Hive
>
> >>>
>
> >>
>
> > server version?
>
> >>>
>
> >>
>
> >
>
> >>>
>
> > On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>
> >>>
>
> >>
>
> > wrote:
>
> >>>
>
> >>
>
> >
>
> >>>
>
> > > Hi,
>
> >>>
>
> >>
>
> > > Please find my reply :-
>
> >>>
>
> >>
>
> > > Can you do a 'use hive;` followed by 'show tables;' and see if table
>
> >>>
>
> >>
>
> > > 'cad' is listed? : Did and got empty set(No rows selected).
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > If you try via hive shell, do you see it? : Yes
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > can you check if this is impacting accessing all hive tables (may be
>
> >>>
>
> >>
>
> > > create a new one and try) or if this is specific to a certain table /
>
> >>>
>
> >>
>
> > > database in Hive? : Tried 2 tables but getting same error. I have not
>
> >>>
>
> >>
>
> > tried
>
> >>>
>
> >>
>
> > > creating anew one, will try that and let you know.
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>
> >>>
>
> >>
>
> > wrote:
>
> >>>
>
> >>
>
> > > Down in the stack trace it's complaining that the table name 'cad' was
>
> >>>
>
> >>
>
> > not
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>
> >>>
>
> >>
>
> > table
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > 'cad' is listed?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > If you try via hive shell, do you see it?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > Also, can you check if this is impacting accessing all hive tables (may
>
> >>>
>
> >>
>
> > be
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > create a new one and try) or if this is specific to a certain table /
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > database in Hive?
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > > -Abhishek
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> > >
>
> >>>
>
> >>
>
> >
>
> >>>
>
> >
>
> >>
>
> >
>
> >>
>
> >
>
> >
>
> >
>
> >
>
> >
>
> > Regards,
>
> > Anup Tiwari
>
>
>
>
>
>
> Regards,
> Anup Tiwari
>
>
> Regards,
> Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
I have not upgraded hive version but installed hive 2.3.2 on a server and
tried to read data and its working.Can we have any workaround to run drill 1.13
with hive 2.1 or up-gradation is the only option?
On Sat, Mar 24, 2018 3:52 PM, Anup Tiwari anup.tiwari@games24x7.com wrote:
Sorry for delayed response as i didn't got time to test this.
@Vitalii, I have tried setting hive.metastore.client.capability.check=false in
both ways which are :-
1. "hive.metastore.uris":
"thrift://prod-hadoop-107.bom-prod.aws.games24x7.com:9083?hive.metastore.client.capability.check=false",
in drill hive plugin and restarted metastore and tried to access hive tables
via drill.
2. Added capability property in hive-site.xml and restarted metastore and tried
to access hive tables via drill.
Both ways didn't work. So does that mean Drill 1.13.0 version is compatible with
Hive 2.3 and above?
On Tue, Mar 20, 2018 6:28 PM, Vitalii Diravka vitalii.diravka@gmail.com wrote:
@Anup, it should. If it isn't back compatible, it is a Hive issue.
Hive Trift Metastore API was changed, but still isn't documented in
cwiki.apache.org [1]
*hive.metastore.client.capability.check *[2] property is true by default.
Possibly changing this could help you.
You can change it in Drill Hive plugin or in hive-site.xml
Looks like, the issue will be the same for using hive-server2 2.3 version
and hive-metastore 2.1 version. If so it is a Hive issue.
So you can try to change the property before updating to Hive 2.3 version.
[1] https://issues.apache.org/jira/browse/HIVE-15062
[2]
https://issues.apache.org/jira/browse/HIVE-15062?focusedCommentId=15659298&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15659298
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Please find below information :-
> Apache Hadoop 2.7.3Apache Hive 2.1.1
> @Vitalii, For testing i can setup upgrade hive but upgrading hive will
> take time
> on our production server. Don't you think it should be back compatible?
>
>
>
>
> On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com
> wrote:
> Anup,
>
>
>
>
> "get_table_req" method is present in ThriftHiveMetastore header of Apache
>
> Hive 2.3 version.
>
> I believe Hive upgrade will help you. Probably it is Hive's back
>
> compatibility issue.
>
> Please let us know, whether upgrade helps.
>
>
>
>
> Kind regards
>
> Vitalii
>
>
>
>
> On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <
> vitalii.diravka@gmail.com
>
> wrote:
>>
>
>
>
>
> Hi Anup,
>>
>
>
>>
> Maybe we missed something after updating onto hive-2.3 client versions.
>>
>
> Could you provide the following info:
>>
>
> * What is your hive-server and metastore versions? If it is not 2.3
>>
>
> version could you update onto this?
>>
>
> * What is your hadoop distribution?
>>
>
>
>>
> Kind regards
>>
>
> Vitalii
>>
>
>
>>
> On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
>>
>
> wrote:
>>
>
>
>>
> Okay, that confirms that the Hive storage plugin is not configured
>>>
>>
> correctly - you are unable to access any Hive table. What's your Hive
>>>
>>
> server version?
>>>
>>
>
>>>
> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>>>
>>
> wrote:
>>>
>>
>
>>>
> > Hi,
>>>
>>
> > Please find my reply :-
>>>
>>
> > Can you do a 'use hive;` followed by 'show tables;' and see if table
>>>
>>
> > 'cad' is listed? : Did and got empty set(No rows selected).
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it? : Yes
>>>
>>
> >
>>>
>>
> > can you check if this is impacting accessing all hive tables (may be
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> > database in Hive? : Tried 2 tables but getting same error. I have not
>>>
>>
> tried
>>>
>>
> > creating anew one, will try that and let you know.
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>>>
>>
> wrote:
>>>
>>
> > Down in the stack trace it's complaining that the table name 'cad' was
>>>
>>
> not
>>>
>>
> >
>>>
>>
> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>>>
>>
> table
>>>
>>
> >
>>>
>>
> > 'cad' is listed?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > Also, can you check if this is impacting accessing all hive tables (may
>>>
>>
> be
>>>
>>
> >
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> >
>>>
>>
> > database in Hive?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > -Abhishek
>>>
>>
> >
>>>
>>
> >
>>>
>>
>
>>>
>
>>
>
>>
>
>
>
>
>
> Regards,
> Anup Tiwari
Regards,
Anup Tiwari
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Sorry for delayed response as i didn't got time to test this.
@Vitalii, I have tried setting hive.metastore.client.capability.check=false in
both ways which are :-
1. "hive.metastore.uris":
"thrift://prod-hadoop-107.bom-prod.aws.games24x7.com:9083?hive.metastore.client.capability.check=false",
in drill hive plugin and restarted metastore and tried to access hive tables
via drill.
2. Added capability property in hive-site.xml and restarted metastore and tried
to access hive tables via drill.
Both ways didn't work. So does that mean Drill 1.13.0 version is compatible with
Hive 2.3 and above?
On Tue, Mar 20, 2018 6:28 PM, Vitalii Diravka vitalii.diravka@gmail.com wrote:
@Anup, it should. If it isn't back compatible, it is a Hive issue.
Hive Trift Metastore API was changed, but still isn't documented in
cwiki.apache.org [1]
*hive.metastore.client.capability.check *[2] property is true by default.
Possibly changing this could help you.
You can change it in Drill Hive plugin or in hive-site.xml
Looks like, the issue will be the same for using hive-server2 2.3 version
and hive-metastore 2.1 version. If so it is a Hive issue.
So you can try to change the property before updating to Hive 2.3 version.
[1] https://issues.apache.org/jira/browse/HIVE-15062
[2]
https://issues.apache.org/jira/browse/HIVE-15062?focusedCommentId=15659298&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15659298
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Please find below information :-
> Apache Hadoop 2.7.3Apache Hive 2.1.1
> @Vitalii, For testing i can setup upgrade hive but upgrading hive will
> take time
> on our production server. Don't you think it should be back compatible?
>
>
>
>
> On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com
> wrote:
> Anup,
>
>
>
>
> "get_table_req" method is present in ThriftHiveMetastore header of Apache
>
> Hive 2.3 version.
>
> I believe Hive upgrade will help you. Probably it is Hive's back
>
> compatibility issue.
>
> Please let us know, whether upgrade helps.
>
>
>
>
> Kind regards
>
> Vitalii
>
>
>
>
> On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <
> vitalii.diravka@gmail.com
>
> wrote:
>>
>
>
>
>
> Hi Anup,
>>
>
>
>>
> Maybe we missed something after updating onto hive-2.3 client versions.
>>
>
> Could you provide the following info:
>>
>
> * What is your hive-server and metastore versions? If it is not 2.3
>>
>
> version could you update onto this?
>>
>
> * What is your hadoop distribution?
>>
>
>
>>
> Kind regards
>>
>
> Vitalii
>>
>
>
>>
> On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
>>
>
> wrote:
>>
>
>
>>
> Okay, that confirms that the Hive storage plugin is not configured
>>>
>>
> correctly - you are unable to access any Hive table. What's your Hive
>>>
>>
> server version?
>>>
>>
>
>>>
> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>>>
>>
> wrote:
>>>
>>
>
>>>
> > Hi,
>>>
>>
> > Please find my reply :-
>>>
>>
> > Can you do a 'use hive;` followed by 'show tables;' and see if table
>>>
>>
> > 'cad' is listed? : Did and got empty set(No rows selected).
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it? : Yes
>>>
>>
> >
>>>
>>
> > can you check if this is impacting accessing all hive tables (may be
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> > database in Hive? : Tried 2 tables but getting same error. I have not
>>>
>>
> tried
>>>
>>
> > creating anew one, will try that and let you know.
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>>>
>>
> wrote:
>>>
>>
> > Down in the stack trace it's complaining that the table name 'cad' was
>>>
>>
> not
>>>
>>
> >
>>>
>>
> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>>>
>>
> table
>>>
>>
> >
>>>
>>
> > 'cad' is listed?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > Also, can you check if this is impacting accessing all hive tables (may
>>>
>>
> be
>>>
>>
> >
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> >
>>>
>>
> > database in Hive?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > -Abhishek
>>>
>>
> >
>>>
>>
> >
>>>
>>
>
>>>
>
>>
>
>>
>
>
>
>
>
> Regards,
> Anup Tiwari
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Vitalii Diravka <vi...@gmail.com>.
@Anup, it should. If it isn't back compatible, it is a Hive issue.
Hive Trift Metastore API was changed, but still isn't documented in
cwiki.apache.org [1]
*hive.metastore.client.capability.check *[2] property is true by default.
Possibly changing this could help you.
You can change it in Drill Hive plugin or in hive-site.xml
Looks like, the issue will be the same for using hive-server2 2.3 version
and hive-metastore 2.1 version. If so it is a Hive issue.
So you can try to change the property before updating to Hive 2.3 version.
[1] https://issues.apache.org/jira/browse/HIVE-15062
[2]
https://issues.apache.org/jira/browse/HIVE-15062?focusedCommentId=15659298&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15659298
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 1:54 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Please find below information :-
> Apache Hadoop 2.7.3Apache Hive 2.1.1
> @Vitalii, For testing i can setup upgrade hive but upgrading hive will
> take time
> on our production server. Don't you think it should be back compatible?
>
>
>
>
> On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com
> wrote:
> Anup,
>
>
>
>
> "get_table_req" method is present in ThriftHiveMetastore header of Apache
>
> Hive 2.3 version.
>
> I believe Hive upgrade will help you. Probably it is Hive's back
>
> compatibility issue.
>
> Please let us know, whether upgrade helps.
>
>
>
>
> Kind regards
>
> Vitalii
>
>
>
>
> On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <
> vitalii.diravka@gmail.com
>
> wrote:
>>
>
>
>
>
> Hi Anup,
>>
>
>
>>
> Maybe we missed something after updating onto hive-2.3 client versions.
>>
>
> Could you provide the following info:
>>
>
> * What is your hive-server and metastore versions? If it is not 2.3
>>
>
> version could you update onto this?
>>
>
> * What is your hadoop distribution?
>>
>
>
>>
> Kind regards
>>
>
> Vitalii
>>
>
>
>>
> On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
>>
>
> wrote:
>>
>
>
>>
> Okay, that confirms that the Hive storage plugin is not configured
>>>
>>
> correctly - you are unable to access any Hive table. What's your Hive
>>>
>>
> server version?
>>>
>>
>
>>>
> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>>>
>>
> wrote:
>>>
>>
>
>>>
> > Hi,
>>>
>>
> > Please find my reply :-
>>>
>>
> > Can you do a 'use hive;` followed by 'show tables;' and see if table
>>>
>>
> > 'cad' is listed? : Did and got empty set(No rows selected).
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it? : Yes
>>>
>>
> >
>>>
>>
> > can you check if this is impacting accessing all hive tables (may be
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> > database in Hive? : Tried 2 tables but getting same error. I have not
>>>
>>
> tried
>>>
>>
> > creating anew one, will try that and let you know.
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>>>
>>
> wrote:
>>>
>>
> > Down in the stack trace it's complaining that the table name 'cad' was
>>>
>>
> not
>>>
>>
> >
>>>
>>
> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>>>
>>
> table
>>>
>>
> >
>>>
>>
> > 'cad' is listed?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > If you try via hive shell, do you see it?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > Also, can you check if this is impacting accessing all hive tables (may
>>>
>>
> be
>>>
>>
> >
>>>
>>
> > create a new one and try) or if this is specific to a certain table /
>>>
>>
> >
>>>
>>
> > database in Hive?
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> >
>>>
>>
> > -Abhishek
>>>
>>
> >
>>>
>>
> >
>>>
>>
>
>>>
>
>>
>
>>
>
>
>
>
>
> Regards,
> Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Please find below information :-
Apache Hadoop 2.7.3Apache Hive 2.1.1
@Vitalii, For testing i can setup upgrade hive but upgrading hive will take time
on our production server. Don't you think it should be back compatible?
On Tue, Mar 20, 2018 4:33 PM, Vitalii Diravka vitalii.diravka@gmail.com wrote:
Anup,
"get_table_req" method is present in ThriftHiveMetastore header of Apache
Hive 2.3 version.
I believe Hive upgrade will help you. Probably it is Hive's back
compatibility issue.
Please let us know, whether upgrade helps.
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <vitalii.diravka@gmail.com
> wrote:
> Hi Anup,
>
> Maybe we missed something after updating onto hive-2.3 client versions.
> Could you provide the following info:
> * What is your hive-server and metastore versions? If it is not 2.3
> version could you update onto this?
> * What is your hadoop distribution?
>
> Kind regards
> Vitalii
>
> On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
> wrote:
>
>> Okay, that confirms that the Hive storage plugin is not configured
>> correctly - you are unable to access any Hive table. What's your Hive
>> server version?
>>
>> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>> wrote:
>>
>> > Hi,
>> > Please find my reply :-
>> > Can you do a 'use hive;` followed by 'show tables;' and see if table
>> > 'cad' is listed? : Did and got empty set(No rows selected).
>> >
>> > If you try via hive shell, do you see it? : Yes
>> >
>> > can you check if this is impacting accessing all hive tables (may be
>> > create a new one and try) or if this is specific to a certain table /
>> > database in Hive? : Tried 2 tables but getting same error. I have not
>> tried
>> > creating anew one, will try that and let you know.
>> >
>> >
>> >
>> >
>> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>> wrote:
>> > Down in the stack trace it's complaining that the table name 'cad' was
>> not
>> >
>> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>> table
>> >
>> > 'cad' is listed?
>> >
>> >
>> >
>> >
>> > If you try via hive shell, do you see it?
>> >
>> >
>> >
>> >
>> > Also, can you check if this is impacting accessing all hive tables (may
>> be
>> >
>> > create a new one and try) or if this is specific to a certain table /
>> >
>> > database in Hive?
>> >
>> >
>> >
>> >
>> > -Abhishek
>> >
>> >
>>
>
>
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Vitalii Diravka <vi...@gmail.com>.
Anup,
"get_table_req" method is present in ThriftHiveMetastore header of Apache
Hive 2.3 version.
I believe Hive upgrade will help you. Probably it is Hive's back
compatibility issue.
Please let us know, whether upgrade helps.
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 12:56 PM, Vitalii Diravka <vitalii.diravka@gmail.com
> wrote:
> Hi Anup,
>
> Maybe we missed something after updating onto hive-2.3 client versions.
> Could you provide the following info:
> * What is your hive-server and metastore versions? If it is not 2.3
> version could you update onto this?
> * What is your hadoop distribution?
>
> Kind regards
> Vitalii
>
> On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
> wrote:
>
>> Okay, that confirms that the Hive storage plugin is not configured
>> correctly - you are unable to access any Hive table. What's your Hive
>> server version?
>>
>> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
>> wrote:
>>
>> > Hi,
>> > Please find my reply :-
>> > Can you do a 'use hive;` followed by 'show tables;' and see if table
>> > 'cad' is listed? : Did and got empty set(No rows selected).
>> >
>> > If you try via hive shell, do you see it? : Yes
>> >
>> > can you check if this is impacting accessing all hive tables (may be
>> > create a new one and try) or if this is specific to a certain table /
>> > database in Hive? : Tried 2 tables but getting same error. I have not
>> tried
>> > creating anew one, will try that and let you know.
>> >
>> >
>> >
>> >
>> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org
>> wrote:
>> > Down in the stack trace it's complaining that the table name 'cad' was
>> not
>> >
>> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
>> table
>> >
>> > 'cad' is listed?
>> >
>> >
>> >
>> >
>> > If you try via hive shell, do you see it?
>> >
>> >
>> >
>> >
>> > Also, can you check if this is impacting accessing all hive tables (may
>> be
>> >
>> > create a new one and try) or if this is specific to a certain table /
>> >
>> > database in Hive?
>> >
>> >
>> >
>> >
>> > -Abhishek
>> >
>> >
>>
>
>
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Vitalii Diravka <vi...@gmail.com>.
Hi Anup,
Maybe we missed something after updating onto hive-2.3 client versions.
Could you provide the following info:
* What is your hive-server and metastore versions? If it is not 2.3 version
could you update onto this?
* What is your hadoop distribution?
Kind regards
Vitalii
On Tue, Mar 20, 2018 at 12:31 PM, Abhishek Girish <ag...@apache.org>
wrote:
> Okay, that confirms that the Hive storage plugin is not configured
> correctly - you are unable to access any Hive table. What's your Hive
> server version?
>
> On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
> wrote:
>
> > Hi,
> > Please find my reply :-
> > Can you do a 'use hive;` followed by 'show tables;' and see if table
> > 'cad' is listed? : Did and got empty set(No rows selected).
> >
> > If you try via hive shell, do you see it? : Yes
> >
> > can you check if this is impacting accessing all hive tables (may be
> > create a new one and try) or if this is specific to a certain table /
> > database in Hive? : Tried 2 tables but getting same error. I have not
> tried
> > creating anew one, will try that and let you know.
> >
> >
> >
> >
> > On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org wrote:
> > Down in the stack trace it's complaining that the table name 'cad' was
> not
> >
> > found; Can you do a 'use hive;` followed by 'show tables;' and see if
> table
> >
> > 'cad' is listed?
> >
> >
> >
> >
> > If you try via hive shell, do you see it?
> >
> >
> >
> >
> > Also, can you check if this is impacting accessing all hive tables (may
> be
> >
> > create a new one and try) or if this is specific to a certain table /
> >
> > database in Hive?
> >
> >
> >
> >
> > -Abhishek
> >
> >
>
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Abhishek Girish <ag...@apache.org>.
Okay, that confirms that the Hive storage plugin is not configured
correctly - you are unable to access any Hive table. What's your Hive
server version?
On Tue, Mar 20, 2018 at 3:39 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Hi,
> Please find my reply :-
> Can you do a 'use hive;` followed by 'show tables;' and see if table
> 'cad' is listed? : Did and got empty set(No rows selected).
>
> If you try via hive shell, do you see it? : Yes
>
> can you check if this is impacting accessing all hive tables (may be
> create a new one and try) or if this is specific to a certain table /
> database in Hive? : Tried 2 tables but getting same error. I have not tried
> creating anew one, will try that and let you know.
>
>
>
>
> On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org wrote:
> Down in the stack trace it's complaining that the table name 'cad' was not
>
> found; Can you do a 'use hive;` followed by 'show tables;' and see if table
>
> 'cad' is listed?
>
>
>
>
> If you try via hive shell, do you see it?
>
>
>
>
> Also, can you check if this is impacting accessing all hive tables (may be
>
> create a new one and try) or if this is specific to a certain table /
>
> database in Hive?
>
>
>
>
> -Abhishek
>
>
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Hi,
Please find my reply :-
Can you do a 'use hive;` followed by 'show tables;' and see if table
'cad' is listed? : Did and got empty set(No rows selected).
If you try via hive shell, do you see it? : Yes
can you check if this is impacting accessing all hive tables (may be
create a new one and try) or if this is specific to a certain table /
database in Hive? : Tried 2 tables but getting same error. I have not tried
creating anew one, will try that and let you know.
On Tue, Mar 20, 2018 3:19 PM, Abhishek Girish agirish@apache.org wrote:
Down in the stack trace it's complaining that the table name 'cad' was not
found; Can you do a 'use hive;` followed by 'show tables;' and see if table
'cad' is listed?
If you try via hive shell, do you see it?
Also, can you check if this is impacting accessing all hive tables (may be
create a new one and try) or if this is specific to a certain table /
database in Hive?
-Abhishek
On Tue, Mar 20, 2018 at 2:37 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Note : Using Show databases, i can see hive schemas.
>
>
>
>
>
> On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari anup.tiwari@games24x7.com
> wrote:
> Hi,
> I am not able to read my hive tables in drill 1.13.0 and with same plugin
> conf
> it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and
> let me
> know if i have missed anything.
> Hive Plugin :-
> { "type": "hive", "enabled": true, "configProps":
> { "hive.metastore.uris":
> "thrift://prod-hadoop-1xx.com:9083", "hive.metastore.sasl.enabled":
> "false",
> "fs.default.name": "hdfs://prod-hadoop-1xx.com:9000" }}
> Query :-
> select id from hive.cad where log_date = '2018-03-18' limit 3
> Error :-
> 2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where
> log_date =
> '2018-03-18' limit 32018-03-20 14:25:27,354
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1,
> column
> 16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive')
> org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From
> line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive'
> SQL Query null
> [Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
> org.apache.drill.common.exceptions.UserException$Builder.
> build(UserException.java:633)
> ~[drill-common-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:199)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.calcite.runtime.CalciteContextException: From line 1, column
> 16 to
> line 1, column 19: Object 'cad' not found within 'hive' at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidati
> onError(SqlValidatorImpl.java:4703)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:127)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
> org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not
> found
> within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
> Native
> Method) ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames
> omitted
> 2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete
> before
> shutting down2018-03-20 14:25:27,375
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
> complete before shutting down
> Regards,
> Anup Tiwari
>
>
>
> Regards,
> Anup Tiwari
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException: Invalid
method name: 'get_table_req'
Posted by Abhishek Girish <ag...@apache.org>.
Down in the stack trace it's complaining that the table name 'cad' was not
found; Can you do a 'use hive;` followed by 'show tables;' and see if table
'cad' is listed?
If you try via hive shell, do you see it?
Also, can you check if this is impacting accessing all hive tables (may be
create a new one and try) or if this is specific to a certain table /
database in Hive?
-Abhishek
On Tue, Mar 20, 2018 at 2:37 PM, Anup Tiwari <an...@games24x7.com>
wrote:
> Note : Using Show databases, i can see hive schemas.
>
>
>
>
>
> On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari anup.tiwari@games24x7.com
> wrote:
> Hi,
> I am not able to read my hive tables in drill 1.13.0 and with same plugin
> conf
> it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and
> let me
> know if i have missed anything.
> Hive Plugin :-
> { "type": "hive", "enabled": true, "configProps":
> { "hive.metastore.uris":
> "thrift://prod-hadoop-1xx.com:9083", "hive.metastore.sasl.enabled":
> "false",
> "fs.default.name": "hdfs://prod-hadoop-1xx.com:9000" }}
> Query :-
> select id from hive.cad where log_date = '2018-03-18' limit 3
> Error :-
> 2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where
> log_date =
> '2018-03-18' limit 32018-03-20 14:25:27,354
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
> at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1,
> column
> 16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive')
> org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From
> line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive'
> SQL Query null
> [Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
> org.apache.drill.common.exceptions.UserException$Builder.
> build(UserException.java:633)
> ~[drill-common-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:199)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.calcite.runtime.CalciteContextException: From line 1, column
> 16 to
> line 1, column 19: Object 'cad' not found within 'hive' at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidati
> onError(SqlValidatorImpl.java:4703)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:127)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
> org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not
> found
> within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
> Native
> Method) ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
> at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames
> omitted
> 2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete
> before
> shutting down2018-03-20 14:25:27,375
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
> complete before shutting down
> Regards,
> Anup Tiwari
>
>
>
> Regards,
> Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Note : Using Show databases, i can see hive schemas.
On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari anup.tiwari@games24x7.com wrote:
Hi,
I am not able to read my hive tables in drill 1.13.0 and with same plugin conf
it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and let me
know if i have missed anything.
Hive Plugin :-
{ "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris":
"thrift://prod-hadoop-1xx.com:9083", "hive.metastore.sasl.enabled": "false",
"fs.default.name": "hdfs://prod-hadoop-1xx.com:9000" }}
Query :-
select id from hive.cad where log_date = '2018-03-18' limit 3
Error :-
2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where log_date =
'2018-03-18' limit 32018-03-20 14:25:27,354
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1, column
16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive')
org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive'
SQL Query null
[Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
~[drill-common-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:199)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.calcite.runtime.CalciteContextException: From line 1, column 16 to
line 1, column 19: Object 'cad' not found within 'hive' at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4703)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:127)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not found
within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames omitted
2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete before
shutting down2018-03-20 14:25:27,375
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
complete before shutting down
Regards,
Anup Tiwari
Regards,
Anup Tiwari
Re: [Drill 1.13.0] : org.apache.thrift.TApplicationException:
Invalid method name: 'get_table_req'
Posted by Anup Tiwari <an...@games24x7.com>.
Note : Using Show databases, i can see hive schemas.
On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari anup.tiwari@games24x7.com wrote:
Hi,
I am not able to read my hive tables in drill 1.13.0 and with same plugin conf
it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and let me
know if i have missed anything.
Hive Plugin :-
{ "type": "hive", "enabled": true, "configProps": { "hive.metastore.uris":
"thrift://prod-hadoop-1xx.com:9083", "hive.metastore.sasl.enabled": "false",
"fs.default.name": "hdfs://prod-hadoop-1xx.com:9000" }}
Query :-
select id from hive.cad where log_date = '2018-03-18' limit 3
Error :-
2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where log_date =
'2018-03-18' limit 32018-03-20 14:25:27,354
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntryFrom(SqlValidatorUtil.java:1003)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEntry(SqlValidatorUtil.java:960)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.prepare.CalciteCatalogReader.getTable(CalciteCatalogReader.java:117)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteCatalogReader.getTable(SqlConverter.java:633)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:261)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get hive
table. Retries once.org.apache.thrift.TApplicationException: Invalid method
name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937) [guava-18.0.jar:na]
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]2018-03-20
14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to read
table. default.cadjava.util.concurrent.ExecutionException:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
~[guava-18.0.jar:na] at
com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:137)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2348)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.get(LocalCache.java:3937)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
~[guava-18.0.jar:na] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$HiveClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getDrillTable(HiveSchemaFactory.java:213)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.getTable(HiveDatabaseSchema.java:62)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$HiveSchema.getTable(HiveSchemaFactory.java:201)
[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:82)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.thrift.TApplicationException: Invalid method name: 'get_table_req' at
org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:1550)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1344)
~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.getHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:535)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$TableLoader.load(DrillHiveMetaStoreClient.java:531)
~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
~[guava-18.0.jar:na] at
com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1, column
16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive')
org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From line 1,
column 16 to line 1, column 19: Object 'cad' not found within 'hive'
SQL Query null
[Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
~[drill-common-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:199)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:630)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:202)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:174)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:146)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:84)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
[drill-java-exec-1.13.0.jar:1.13.0] at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_72] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_72] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_72]Caused by:
org.apache.calcite.runtime.CalciteContextException: From line 1, column 16 to
line 1, column 19: Object 'cad' not found within 'hive' at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4703)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:127)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2972)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2957)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter$DrillValidator.validateFrom(SqlConverter.java:267)
~[drill-java-exec-1.13.0.jar:1.13.0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3216)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:947)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:928)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:903)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:613)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlConverter.java:190)
[drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not found
within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.8.0_72] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
~[na:1.8.0_72] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[na:1.8.0_72] at
java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_72]
at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames omitted
2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete before
shutting down2018-03-20 14:25:27,375
[254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
complete before shutting down
Regards,
Anup Tiwari
Regards,
Anup Tiwari