Unable to coerce from the file's data type

1

Hi testing an update from v19.12.0 to v20.9.0

When running one of our queries after the update I am running to the following error.

Unable to coerce from the file's data type "int64" to the column's data type 
"struct<links::list<null>, id::varchar, refName::varchar>" in table 
"supportCase.json", column "status" and file "supportCase.json".

Here is the column it refers to:

status column
status column207×567 1.79 KB

Another user in the same instance can run this query with no problem.

2

@emdomingo Looks like there are mixed types that cannot be coerced, It might be possible the data the other user is querying does not have mixed types, are you running the same exact query? Are you able to send your job profile that failed with this error and from the user for who it worked