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

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

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

  1. INSERT INTO
  2. "_CEL_MD_ACTIVITIES" ("_CEL_MD_ACTIVITIES"."CASE_KEY", "_CEL_MD_ACTIVITIES"."ACTIVITY_EN", "_CEL_MD_ACTIVITIES"."EVENTTIME")
  3. SELECT
  4. "_CEL_MD_CASE_TABLE"."CASE_ID" AS "_CEL_MD_ACTIVITIES"."CASE_KEY",
  5. 'Case Reopened' AS "_CEL_MD_ACTIVITIES"."ACTIVITY_EN",
  6. "_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" AS "_CEL_MD_ACTIVITIES"."EVENTTIME"
  7. FROM
  8. "_CEL_MD_CASE_TABLE"
  9. JOIN
  10. "_CEL_MD_ACTIVITIES"
  11. ON "_CEL_MD_CASE_TABLE"."CASE_ID" = "_CEL_MD_ACTIVITIES"."CASE_KEY"
  12. WHERE
  13. "_CEL_MD_CASE_TABLE"."CASE_REOPEN_DATE" IS NOT NULL;

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

kfgdxczn

kfgdxczn1#

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

  1. AS "_CEL_MD_ACTIVITIES"."ACTIVITY_EN",

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

相关问题