# Issue with Hive 3 and Dremio 2.1.4

**URL:** <https://community.dremio.com/t/issue-with-hive-3-and-dremio-2-1-4/1968>\
**Category:** Uncategorized\
**Created:** [October 4, 2018, 10:31am UTC](https://community.dremio.com/t/issue-with-hive-3-and-dremio-2-1-4/1968 "2018-10-04T10:31:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Merk91](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@Merk91](https://community.dremio.com/u/Merk91)\
**Post date:** [October 4, 2018, 10:31am UTC](https://community.dremio.com/t/issue-with-hive-3-and-dremio-2-1-4/1968/1 "2018-10-04T10:31:49Z")

</div>

Hi,  
i have an issue retriving a qwery result from HIVE 3 with Dremio 2.1.4 .  
If i open an Hive table from the Dremio UI, it show: NO RESULT

But if i do the same qwery in Hive by command line i can see all the result.

The /var/log/dremio/server.log file report:  
INFO query.logger - {“queryId”:“244a15e0-d795-287e-a61f-8f99c43d6700”,“schema”:“Hive.test”,“queryText”:“SELECT \*\nFROM Hive.test.classe\_veicolo”,“start”:1538648606540,“finish”:1538648606721,“outcome”:“COMPLETED”,“username”:“user”,“commandDescription”:“execute; query”}

Does somene know why it happen and how to fix it?

---

<div class="post-metadata">

**Author:** ![horadrim](https://avatars.discourse-cdn.com/v4/letter/h/e56c9b/32.png) [@horadrim](https://community.dremio.com/u/horadrim)\
**Post date:** [October 4, 2018, 12:14pm UTC](https://community.dremio.com/t/issue-with-hive-3-and-dremio-2-1-4/1968/2 "2018-10-04T12:14:40Z")

</div>

The issue is related to how Hive manage transactional table. If the base dir is not created yet (i.e. no major compactor were executed) Dremio is unable to read the delta dir. The workaround is to manually execute a major compaction (alter table [table name] compact ‘major’). This way should works. Following transactions are read correctly, without the need of new compactions.

Is it a bug in Dremio? Will be fixed in following releases?