[ 
https://issues.apache.org/jira/browse/DRILL-6293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vitalii Diravka updated DRILL-6293:
-----------------------------------
    Description: 
Hi,

{color:#222222}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.{color}
  
 *Hive Plugin :-* 
{code}
 {
   "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"   
   }
} 
  {code}
 *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 3
 2018-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.cad
 java.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 omitted
 2018-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.cad
 java.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 omitted
 2018-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 omitted
 Caused 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 down
 2018-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
  
 *Note :*
 {color:#222222}1. Using Show databases, i can see hive schemas.{color}
 {color:#222222}2. I have tried adding 
hive.metastore.client.capability.check=false in hive-site but its not 
working.{color}
 {color:#222222}3. Things working fine with hive 2.3.2{color}
  

  was:
Hi,

{color:#222222}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.{color}
 
*Hive Plugin :-* 
{
  "type": "hive",
  "enabled": true,
  "configProps": {
    "hive.metastore.uris": 
"thrift://[prod-hadoop-1xx.com:9083|http://prod-hadoop-1xx.com:9083/]";,
    "hive.metastore.sasl.enabled": "false",
    "[fs.default.name|http://fs.default.name/]": 
"hdfs://[prod-hadoop-1xx.com:9000|http://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 3
2018-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.cad
java.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 omitted
2018-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.cad
java.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 omitted
2018-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 omitted
Caused 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 down
2018-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
 
*Note :*
{color:#222222}1. Using Show databases, i can see hive schemas.{color}
{color:#222222}2. I have tried adding 
hive.metastore.client.capability.check=false in hive-site but its not 
working.{color}
{color:#222222}3. Things working fine with hive 2.3.2{color}
 


> Unable to read hive(2.1.1) tables using Drill 1.13.0 
> -----------------------------------------------------
>
>                 Key: DRILL-6293
>                 URL: https://issues.apache.org/jira/browse/DRILL-6293
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.13.0
>            Reporter: Anup Tiwari
>            Assignee: Vitalii Diravka
>            Priority: Major
>             Fix For: 1.14.0
>
>
> Hi,
> {color:#222222}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.{color}
>   
>  *Hive Plugin :-* 
> {code}
>  {
>    "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"   
>    }
> } 
>   {code}
>  *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 3
>  2018-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.cad
>  java.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 omitted
>  2018-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.cad
>  java.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 omitted
>  2018-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 omitted
>  Caused 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 down
>  2018-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
>   
>  *Note :*
>  {color:#222222}1. Using Show databases, i can see hive schemas.{color}
>  {color:#222222}2. I have tried adding 
> hive.metastore.client.capability.check=false in hive-site but its not 
> working.{color}
>  {color:#222222}3. Things working fine with hive 2.3.2{color}
>   



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to