1、coalesce报错
FAILED: SemanticException [Error 10014]: Line 197:4 Wrong arguments ''10'': Unsafe compares
BETWEEN different types are disabled for safety reasons. If you know what you are doing,
please SET hive.strict.checks.type.safety to false
AND make sure that hive.mapred.mode is NOT SET to 'strict' to proceed. Note that you may get errors
OR incorrect results if you make a mistake while
USING some of the unsafe features.