# Strange A# data type - No enum constant

**URL:** <https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140>\
**Category:** Uncategorized\
**Created:** [May 14, 2018, 5:37pm UTC](https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140 "2018-05-14T17:37:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![muv](https://avatars.discourse-cdn.com/v4/letter/m/e9a140/32.png) [@muv](https://community.dremio.com/u/muv)\
**Post date:** [May 14, 2018, 5:37pm UTC](https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140/1 "2018-05-14T17:37:59Z")

</div>

I have a Dremio dataset pointing to a MongoDB collection.  
The collection has column called **date** which was initially an ISO-formatted string in MongoDB.  
I have now converted it into MondoDB **date type** directly in MongoDB. Dremio now shows type of this column in the dataset as yellow letters **A#**. When clicking on it (trying to change the type), I get the following error:

**No enum constant com.dremio.common.types.TypeProtos.MinorType.DATEMILLI**

What am I doing wrong? How can this be fixed? The goal is to make Dremio treat this column as date type for future joining and filtering.

Dremio build: 2.0.1-201804132205050000-10b1de0

---

<div class="post-metadata">

**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\
**Post date:** [May 14, 2018, 9:39pm UTC](https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140/2 "2018-05-14T21:39:47Z")

</div>

This may be a bug and we can try to reproduce here. Meanwhile, I wonder if refreshing the metadata will get you past this issue: [https://docs.dremio.com/sql-reference/sql-commands/datasets.html#managing-physical-datasets](https://docs.dremio.com/sql-reference/sql-commands/datasets.html#managing-physical-datasets)

Note this command has some side effects you should consider related to reflections and security.

Normally Dremio will automatically adjust to changes in schema through it’s schema learning engine. You may be able to trigger this by running a select \* on that collection using Run (with a limit if you need to).

---

<div class="post-metadata">

**Author:** ![muv](https://avatars.discourse-cdn.com/v4/letter/m/e9a140/32.png) [@muv](https://community.dremio.com/u/muv)\
**Post date:** [May 15, 2018, 10:54am UTC](https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140/3 "2018-05-15T10:54:39Z")

</div>

Run did not fix it, unfortunately.  
I found in Dremio documentation that A# denotes a mixed type (it would be great to have it in the table listing all type symbols). But my date column is not mixed (had strings in all rows, now dates). And Dremio does not allow me to change the type.

---

<div class="post-metadata">

**Author:** ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)\
**Post date:** [May 15, 2018, 1:21pm UTC](https://community.dremio.com/t/strange-a-data-type-no-enum-constant/1140/4 "2018-05-15T13:21:49Z")

</div>

From this tutorial, see the section on mixed types: [https://www.dremio.com/tutorials/data-curation-with-dremio](https://www.dremio.com/tutorials/data-curation-with-dremio)

You could try working through that wizard. Alternately, maybe some of your records are still strings?

Did you try refreshing the metadata?