Down in the stack trace it's complaining that the table name 'cad' was not
found; Can you do a 'use hive;` followed by 'show tables;' and see if table
'cad' is listed?

If you try via hive shell, do you see it?

Also, can you check if this is impacting accessing all hive tables (may be
create a new one and try) or if this is specific to a certain table /
database in Hive?

-Abhishek

On Tue, Mar 20, 2018 at 2:37 PM, Anup Tiwari <[email protected]>
wrote:

> Note :  Using Show databases, i can see hive schemas.
>
>
>
>
>
> On Tue, Mar 20, 2018 2:36 PM, Anup Tiwari [email protected]
> wrote:
> Hi,
> I am not able to read my hive tables in drill 1.13.0 and with same plugin
> conf
> it was working in Drill 1.12.0 and 1.10.0. Please look into it asap and
> let me
> know if i have missed anything.
> Hive Plugin :-
> {  "type": "hive",  "enabled": true,  "configProps":
> {    "hive.metastore.uris":
> "thrift://prod-hadoop-1xx.com:9083",    "hive.metastore.sasl.enabled":
> "false",
>     "fs.default.name": "hdfs://prod-hadoop-1xx.com:9000"  }}
> Query :-
> select id from hive.cad where log_date = '2018-03-18' limit 3
> Error :-
> 2018-03-20 14:25:27,351 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.a.drill.exec.work.foreman.Foreman - Query text for query id
> 254f337f-9ac3-b66f-ed17-1de459da3283: select id from hive.cad where
> log_date =
> '2018-03-18' limit 32018-03-20 14:25:27,354
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
>  at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,356 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ryFrom(SqlValidatorUtil.java:1003)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorUtil.getTableEnt
> ry(SqlValidatorUtil.java:960)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.prepare.CalciteCatalogReader.getTable(Cal
> citeCatalogReader.java:117)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillCalciteC
> atalogReader.getTable(SqlConverter.java:633)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:261)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 36 common frames omitted2018-03-20 14:25:27,358
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.DrillHiveMetaStoreClient - Failure while attempting to get
> hive
> table. Retries once.org.apache.thrift.TApplicationException: Invalid
> method
> name: 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:285)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> [guava-18.0.jar:na]
>  at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> [guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> [guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]2018-03-20
> 14:25:27,359 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] WARN
> o.a.d.e.s.h.schema.HiveSchemaFactory - Exception occurred while trying to
> read
> table. default.cadjava.util.concurrent.ExecutionException:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> com.google.common.util.concurrent.AbstractFuture$Sync.
> getValue(AbstractFuture.java:299)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture$Sync.get(
> AbstractFuture.java:286)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.AbstractFuture.get(Abstrac
> tFuture.java:116)
> ~[guava-18.0.jar:na] at
> com.google.common.util.concurrent.Uninterruptibles.getUninte
> rruptibly(Uninterruptibles.java:137)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.getAndRecordStats
> (LocalCache.java:2348)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2320)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(
> LocalCache.java:2282)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.get(LocalCache.java:3937)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$LocalLoadingCache.get(
> LocalCache.java:4824)
> ~[guava-18.0.jar:na] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Hi
> veClientWithCaching.getHiveReadEntry(DrillHiveMetaStoreClient.java:495)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getSelectionBaseOnName(HiveSchemaFactory.java:233)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getDrillTable(HiveSchemaFactory.java:213)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveDatabaseSchema.
> getTable(HiveDatabaseSchema.java:62)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.schema.HiveSchemaFactory$Hi
> veSchema.getTable(HiveSchemaFactory.java:201)
> [drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable
> (SimpleCalciteSchema.java:82)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:257)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:142)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.EmptyScope.resolveTable(
> EmptyScope.java:99)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.DelegatingScope.resolveTable
> (DelegatingScope.java:203)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:105)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> [calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.thrift.TApplicationException: Invalid method name:
> 'get_table_req' at
> org.apache.thrift.TApplicationException.read(TApplicationExc
> eption.java:111)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:79)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.recv_get_table_req(ThriftHiveMetastore.java:1563)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$
> Client.get_table_req(ThriftHiveMetastore.java:1550)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTabl
> e(HiveMetaStoreClient.java:1344)
> ~[drill-hive-exec-shaded-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient.ge
> tHiveReadEntryHelper(DrillHiveMetaStoreClient.java:296)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:535)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.store.hive.DrillHiveMetaStoreClient$Ta
> bleLoader.load(DrillHiveMetaStoreClient.java:531)
> ~[drill-storage-hive-core-1.13.0.jar:1.13.0] at
> com.google.common.cache.LocalCache$LoadingValueReference.loa
> dFuture(LocalCache.java:3527)
> ~[guava-18.0.jar:na] at
> com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
> ~[guava-18.0.jar:na] ... 43 common frames omitted2018-03-20 14:25:27,361
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.a.d.exec.planner.sql.SqlConverter - User Error Occurred: From line 1,
> column
> 16 to line 1, column 19: Object 'cad' not found within 'hive' (From line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive')
> org.apache.drill.common.exceptions.UserException: VALIDATION ERROR: From
> line 1,
> column 16 to line 1, column 19: Object 'cad' not found within 'hive'
> SQL Query null
> [Error Id: 6d55d512-e7eb-4953-952c-95f3c2544c8c ] at
> org.apache.drill.common.exceptions.UserException$Builder.
> build(UserException.java:633)
> ~[drill-common-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:199)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateNode(DefaultSqlHandler.java:630)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .validateAndConvert(DefaultSqlHandler.java:202)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler
> .getPlan(DefaultSqlHandler.java:174)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPla
> n(DrillSqlWorker.java:146)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(Dri
> llSqlWorker.java:84)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:567)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:264)
> [drill-java-exec-1.13.0.jar:1.13.0] at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
> Executor.java:1142)
> [na:1.8.0_72] at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
> lExecutor.java:617)
> [na:1.8.0_72] at java.lang.Thread.run(Thread.java:745)
> [na:1.8.0_72]Caused by:
> org.apache.calcite.runtime.CalciteContextException: From line 1, column
> 16 to
> line 1, column 19: Object 'cad' not found within 'hive' at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
>  at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:800)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:788)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidati
> onError(SqlValidatorImpl.java:4703)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.resolveI
> mpl(IdentifierNamespace.java:127)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.IdentifierNamespace.validate
> Impl(IdentifierNamespace.java:177)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2972)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFro
> m(SqlValidatorImpl.java:2957)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter$DrillValidato
> r.validateFrom(SqlConverter.java:267)
> ~[drill-java-exec-1.13.0.jar:1.13.0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSel
> ect(SqlValidatorImpl.java:3216)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl
> (SelectNamespace.java:60)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(
> AbstractNamespace.java:84)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNam
> espace(SqlValidatorImpl.java:947)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQue
> ry(SqlValidatorImpl.java:928)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSco
> pedExpression(SqlValidatorImpl.java:903)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(
> SqlValidatorImpl.java:613)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.drill.exec.planner.sql.SqlConverter.validate(SqlC
> onverter.java:190)
> [drill-java-exec-1.13.0.jar:1.13.0] ... 10 common frames omittedCaused by:
> org.apache.calcite.sql.validate.SqlValidatorException: Object 'cad' not
> found
> within 'hive' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
> Native
> Method) ~[na:1.8.0_72] at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Native
> ConstructorAccessorImpl.java:62)
> ~[na:1.8.0_72] at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De
> legatingConstructorAccessorImpl.java:45)
> ~[na:1.8.0_72] at
> java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> ~[na:1.8.0_72]
>  at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Reso
> urces.java:463)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] at
> org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:572)
> ~[calcite-core-1.15.0-drill-r0.jar:1.15.0-drill-r0] ... 31 common frames
> omitted
> 2018-03-20 14:25:27,375 [254f337f-9ac3-b66f-ed17-1de459da3283:foreman]
> INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 queries to complete
> before
> shutting down2018-03-20 14:25:27,375
> [254f337f-9ac3-b66f-ed17-1de459da3283:foreman] INFO
> o.apache.drill.exec.work.WorkManager - Waiting for 0 running fragments to
> complete before shutting down
> Regards,
> Anup Tiwari
>
>
>
> Regards,
> Anup Tiwari

Reply via email to