Schema element "$_dremio_$_update_$::int64"

#1

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).

#2

@ennpet, try running the following query on the dataset:
ALTER PDS <your dataset here> REFRESH METADATA

Also, can you attach the job profile?

#3

Hello Ben,

REFRESH METADATA seems not to help.
Still the same error.

Profile:
https://1drv.ms/u/s!AkcCdpR1_vN7gfdbes1TaMhH4_IGPQ

Best regards
Enn

#4

@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?
#5

@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

#6

@ben
actually, looks like the problem is only with “SELECT COUNT(*) FROM”.
“SELECT * FROM”. works.

#7

@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?

#8

Try sending the profile to me ben@dremio.com