# schema/Tables are getting lost at dremio from HIVE source

**URL:** https://community.dremio.com/t/schema-tables-are-getting-lost-at-dremio-from-hive-source/6318
**Category:** Uncategorized
**Created:** [September 22, 2020, 1:23pm UTC](https://community.dremio.com/t/schema-tables-are-getting-lost-at-dremio-from-hive-source/6318 "2020-09-22T13:23:05Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![achounde](https://avatars.discourse-cdn.com/v4/letter/a/c89c15/32.png) [@achounde](https://community.dremio.com/u/achounde)
#### Post date: [September 22, 2020, 1:23pm UTC](https://community.dremio.com/t/schema-tables-are-getting-lost-at-dremio-from-hive-source/6318/1 "2020-09-22T13:23:05Z")

</div>

Hello Team,

I have dremio standalone cluster and added HIVE as data source, but I came accross strange behavior of dremio metadata. Some of hive schema/tables are missing at dremio.

To fetch it back I need to manually restart the dremio services,  
Could you please suggest if there is any query to fetch schema or table from source.

I am not using any reflection for this source, also I configured the Metadata refresh property as below -

**Dataset Discovery :**  
Fetch every 1 min

**Dataset Details :**  
Fetch mode - All Datasets (Deprecated)  
Fetch Every - 1 Minutes  
Expire after - 20 Days

**Authorization :**  
Expire after 1 week

Please provide help me