mimir icon indicating copy to clipboard operation
mimir copied to clipboard

CAST behavior inconsistent between Mimir and Spark

Open okennedy opened this issue 5 years ago • 0 comments

The following query behaves differently depending on whether CAST is evaluated in Mimir or in Spark.

SELECT CAST('.' AS int)

In Mimir it returns NULL, while in Spark it returns 0.

  • [ ] Short-term fix: Make Mimir cast '.' to 0.
  • [ ] Long-term fix: Switch over to Spark's cast operation directly.

okennedy avatar Jan 03 '20 22:01 okennedy