# Schema element "$\_dremio\_$\_update\_$::int64" **URL:** \ **Category:** Uncategorized\ **Created:** [March 13, 2019, 4:47pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977 "2019-03-13T16:47:31Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\ **Post date:** [March 13, 2019, 4:47pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/1 "2019-03-13T16:47:32Z")
Hello, I successfully imported one Excel-file but cannot run “SELECT count(\*)” on it. I am getting the following error : SCHEMA\_CHANGE ERROR: New schema found and recorded. Please reattempt the query. Multiple attempts may be necessary to fully learn the schema. In job profile I see that Dremio found to schemas with the only differens in field schema element “\_dremio\__update_$::int64”. Original Schema schema(Auftraggeber::varchar, … Bestelldat::timestamp, \_dremio\__update_$::int64) New Schema schema(Auftraggeber::varchar, Bestelldat::timestamp) I cannot figure out where comes this “\_dremio\__update_$” field in the schema from and how to fix the problem). ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [March 13, 2019, 4:58pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/2 "2019-03-13T16:58:25Z")
@ennpet, try running the following query on the dataset: `ALTER PDS REFRESH METADATA` Also, can you attach the job profile? > **[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. ---
**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\ **Post date:** [March 13, 2019, 8:40pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/3 "2019-03-13T20:40:18Z")
Hello Ben, REFRESH METADATA seems not to help. Still the same error. Profile: [https://1drv.ms/u/s!AkcCdpR1\_vN7gfdbes1TaMhH4\_IGPQ](https://1drv.ms/u/s!AkcCdpR1_vN7gfdbes1TaMhH4_IGPQ) Best regards Enn ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [March 14, 2019, 12:19am UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/4 "2019-03-14T00:19:58Z")
@ennpet, 1. Is it possible for you to share that excel file? 2. Have you tried removing the formatting for this dataset and then re-applying it? ---
**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\ **Post date:** [March 14, 2019, 9:29am UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/5 "2019-03-14T09:29:24Z")
@ben I added this file over import button and therefor cannot remove format. I reduced the file to only one datarow and the error persists. This file I can share: [https://1drv.ms/f/s!AkcCdpR1\_vN7gfdaTTt\_7LVKrj8l2w](https://1drv.ms/f/s!AkcCdpR1_vN7gfdaTTt_7LVKrj8l2w) ---
**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\ **Post date:** [March 14, 2019, 9:35am UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/6 "2019-03-14T09:35:42Z")
@ben actually, looks like the problem is only with “SELECT COUNT(\*) FROM”. “SELECT \* FROM”. works. ---
**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\ **Post date:** [March 15, 2019, 8:58pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/7 "2019-03-15T20:58:34Z")
@ben Hi, I added onedrive link to th excel file and profile, but my antwort was hidden. I didn’t find in the tutorial how I could share these files in the chat. Can you give me instructions? ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [March 15, 2019, 8:59pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/8 "2019-03-15T20:59:29Z")
Try sending the profile to me [ben@dremio.com](mailto:ben@dremio.com) ---
**Author:** ![reshma.cs](https://avatars.discourse-cdn.com/v4/letter/r/e47774/32.png) [@reshma.cs](https://community.dremio.com/u/reshma.cs)\ **Post date:** [September 16, 2020, 1:20pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/9 "2020-09-16T13:20:56Z")
@ben May I know if this issue has been resolved, because I am facing the exact same issue even after refreshing the 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 24, 2020, 7:32am UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/10 "2020-09-24T07:32:26Z")
@reshma.cs This is a known issue that have an Engineering bug filed. Once we fix this issue, the release notes will have an update Thanks Bali ---
**Author:** ![reshma.cs](https://avatars.discourse-cdn.com/v4/letter/r/e47774/32.png) [@reshma.cs](https://community.dremio.com/u/reshma.cs)\ **Post date:** [September 24, 2020, 4:27pm UTC](https://community.dremio.com/t/schema-element-dremio-update-int64/2977/11 "2020-09-24T16:27:05Z")
Thanks @balaji.ramaswamy