topic Re: [DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)" in Data Engineering

[DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)"

AmineDE — Tue, 12 Nov 2024 14:25:22 GMT

Hi All,

i got the error below using a compute instance with any of the runtime but not with sql warehouse xsmall. How could we explain it ?

Runtime Error in model sics_business_recon_unpivoted (models\Engineering\Business\sics_business_recon_unpivoted.sql)
[DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)" due to data type mismatch: Input to `coalesce` should all be the same type, but it's ("STRING" or "BOOLEAN"). SQLSTATE: 09; line 1346 pos 21

Re: [DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)"

SparkJun — Wed, 13 Nov 2024 06:29:03 GMT

can you try to run this on DBSQL and see if that errors out: coalesce(CAST(VALUE AS BOOLEAN), false)?
What's the DBR version for your cluster?

Re: [DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)"

AmineDE — Thu, 14 Nov 2024 08:46:28 GMT

on db sql coalesce(CAST(VALUE AS BOOLEAN), false) is working without errors
DBR tested are 13.3 to 16, for any of them it is not working.