New schema found. Please reattempt the query

1

Hi
I am getting this error while running mongodb query on dremio.

I have two dremio container on two datacenter. In one datacenter, it is working fine while in other data center it is not working and giving error
“New schema found. Please reattempt the query. Multiple attempts may be necessary to fully learn the schema.”

Kindly do the needful

2

@jitenderdheeman Do you have mixed types on any column on the Mongo collection?

3

yes. I have mixed types of columns

4

@jitenderdheeman
What are the different types for the same column?