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

This post was flagged by the community and is temporarily hidden.


#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

This post was flagged by the community and is temporarily hidden.


#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