[DATATYPE_MISMATCH.DATA_DIFF_TYPES] Cannot resolve "coalesce(VALUE, false)"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2024 06:25 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2024 10:29 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-14-2024 12:46 AM
- 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.
