# Hive table not accelerated when create raw reflection

**URL:** <https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918>\
**Category:** Uncategorized\
**Created:** [August 27, 2021, 6:01am UTC](https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918 "2021-08-27T06:01:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![lakeshen](https://avatars.discourse-cdn.com/v4/letter/l/e495f1/32.png) [@lakeshen](https://community.dremio.com/u/lakeshen)\
**Post date:** [August 27, 2021, 6:01am UTC](https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918/1 "2021-08-27T06:01:51Z")

</div>

Hi community,

I use dremio 17 version, when I create the raw reflection with all columns for a hive table. And then I run a query with this table,it didn’t accelerated by the raw reflection. But when I do the same action in community version , not oss version,the mvn cmd like this :  
mvn clean install -DskipTests, it run successful and accelerated by the raw reflection.  
mvn clean install -DskipTests -Ddremio.oss-only=true, it not accelerated by the raw reflection.

---

<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 30, 2021, 7:48am UTC](https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918/2 "2021-08-30T07:48:16Z")

</div>

@lakeshen Are you able to send us the 2 profiles, from OSS and not OSS versions?

> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.

---

<div class="post-metadata">

**Author:** ![lakeshen](https://avatars.discourse-cdn.com/v4/letter/l/e495f1/32.png) [@lakeshen](https://community.dremio.com/u/lakeshen)\
**Post date:** [August 31, 2021, 2:40am UTC](https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918/4 "2021-08-31T02:40:54Z")

</div>

Hi ramaswamy,

Thank you very much for your reply.Here is my SQL profile:  
[samesql\_hive\_ acceleratedby\_raw\_reflection.zip](https://community.dremio.com/uploads/short-url/7vhOOZo9ZXT9T7Zm7erh5ixTChm.zip) (64.2 KB)  
[samesql\_hive\_ not\_acceleratedby\_raw\_reflection.zip](https://community.dremio.com/uploads/short-url/lWIYYQAj1ONxrW16YxeejnDXVGY.zip) (86.9 KB)

There are the same sql, same raw reflection. But in oss version , it did not accelerated by raw reflection.Not OSS verion accelerated by raw reflection success.

---

<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:** [September 1, 2021, 8:55am UTC](https://community.dremio.com/t/hive-table-not-accelerated-when-create-raw-reflection/7918/5 "2021-09-01T08:55:55Z")

</div>

@lakeshen I do not see the reflection even listed, there is a way on enterprise edition to completely disable acceleration, wondering if that is happening for you on OSS. Do none of the queries get accelerated? can you query `sys.reflections` and see if the status of any reflection is `CAN_ACCELERATE`?