执行错误:[vertica][vjdbc](4856)错误:语法错误在“”处或附近

vqlkdk9b  于 2021-07-29  发布在  Java
关注(0)|答案(1)|浏览(851)

尝试将此活动插入到我的表中,但出现以下错误。有什么想法吗?sql查询检查程序一直在我的insert语句中告诉我它的异常值,但我没有看到任何异常值。谢谢!

INSERT INTO
   "_CEL_MD_ACTIVITIES" ("_CEL_MD_ACTIVITIES"."CASE_KEY", "_CEL_MD_ACTIVITIES"."ACTIVITY_EN", "_CEL_MD_ACTIVITIES"."EVENTTIME") 
   SELECT
      "_CEL_MD_CASE_TABLE"."CASE_ID" AS "_CEL_MD_ACTIVITIES"."CASE_KEY",
      'Case Reopened' AS "_CEL_MD_ACTIVITIES"."ACTIVITY_EN",
      "_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" AS "_CEL_MD_ACTIVITIES"."EVENTTIME" 
   FROM
      "_CEL_MD_CASE_TABLE" 
      JOIN
         "_CEL_MD_ACTIVITIES" 
         ON "_CEL_MD_CASE_TABLE"."CASE_ID" = "_CEL_MD_ACTIVITIES"."CASE_KEY" 
   WHERE
      "_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" IS NOT NULL;

执行错误:[vertica]vjdbc错误:语法错误在“”处或附近

kfgdxczn

kfgdxczn1#

将联接中涉及的表的名称和字段用作别名。例如

AS   "_CEL_MD_ACTIVITIES"."ACTIVITY_EN",

这是不对的。您应该更改别名,不要在其中使用点(.)或删除别名的用法

相关问题