select '1.5' > 0.5; // Result is NULL in Spark but is true in Hive.
IIUC, we can cast string as double like Hive.
Add new type coercion rules to compatible with Hive
Should not coerce decimal type to double type when it's join column
[Github] Pull Request #19692 (liutang123)