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