Dataphin代码任务报错Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 3:28 cannot recognize input near 'AS' '"AAA"' ',' in selection target

问题描述

Dataphin代码任务报错Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 3:28 cannot recognize input near 'AS' '"AAA"' ',' in selection target。

问题原因

SQL语法存在问题，Hive无法识别。

解决方案

语法支持的问题，如要用中文或者String的话，可用反单引号括起来。

如：select xxx as `xx`;

适用于

• Dataphin