# Hive connection error - table not found

**URL:** <https://community.dremio.com/t/hive-connection-error-table-not-found/1543>\
**Category:** Uncategorized\
**Created:** [July 31, 2018, 11:33am UTC](https://community.dremio.com/t/hive-connection-error-table-not-found/1543 "2018-07-31T11:33:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![liord](https://avatars.discourse-cdn.com/v4/letter/l/ba8739/32.png) [@liord](https://community.dremio.com/u/liord)\
**Post date:** [July 31, 2018, 11:33am UTC](https://community.dremio.com/t/hive-connection-error-table-not-found/1543/1 "2018-07-31T11:33:45Z")

</div>

Hi,  
I am trying to connect remote hive. I configured the hive metastore and Dremio can I access it- I see my schemas and tables.  
When I am trying to query data from the tables I get the error of  
VALIDATION ERROR: TABLE ‘HIVE.SCHEMA.TABLE’ IS NOT FOUND.  
I copied hive-site.xml and site-core.xml to conf dir of Dremio.  
Is there anything else I might forgot doing?  
Thank you,  
Lior.

---

<div class="post-metadata">

**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\
**Post date:** [July 31, 2018, 12:25pm UTC](https://community.dremio.com/t/hive-connection-error-table-not-found/1543/2 "2018-07-31T12:25:06Z")

</div>

Can you share the query profile? There may be a more obvious error mentioned in the stacktrace - [https://www.dremio.com/tutorials/share-query-profile-dremio/](https://www.dremio.com/tutorials/share-query-profile-dremio/)

---

<div class="post-metadata">

**Author:** ![liord](https://avatars.discourse-cdn.com/v4/letter/l/ba8739/32.png) [@liord](https://community.dremio.com/u/liord)\
**Post date:** [July 31, 2018, 1:15pm UTC](https://community.dremio.com/t/hive-connection-error-table-not-found/1543/3 "2018-07-31T13:15:55Z")

</div>

I am working in a secured network, So it might be hard doing so.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 14, 2018, 7:26am UTC](https://community.dremio.com/t/hive-connection-error-table-not-found/1543/4 "2018-08-14T07:26:30Z")

</div>

Hi @liord

Can you do a describe formatted through a Hive shell and make sure this is not a Hive View?

Thanks  
@balaji.ramaswamy