报错
Type mismatch in column 1 of UNION
解决方案:
sql 在 union的时候 两个表字段出现类型不一致现象
报错
Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 5, column 64. Encountered: “\ufffd” (65533), after : “”
解决方案:
存在中文的别名现象
报错
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Illegal mixing of types in CASE or COALESCE statement
解决方案
CASE when 和 COALESCE 不能混用,调整sql
