Teradata语法错误期望的是名称或Unicode界限标识符或UDFCALLNAME关键字之类的东西)和联合关键字

发布于 2025-02-08 08:58:30 字数 1146 浏览 3 评论 0原文

但是,在我的SQL查询中,我试图将两个表与两个表的结合在一起,但是,每当我运行查询时,我会收到以下错误消息:Teradata语法错误期望像名称或Unicode界定标识符或UDFCALLNAME关键字') “联合”关键字。以下是查询的片段。是什么原因导致了这个问题,我应该进行什么编辑来解决此问题?

 FROM 
(SELECT RUN_DT, CAST(LOB AS VARCHAR(11)) AS LOB, MBRID, MEDICAID_NBR, CAST(DISEASE_COND AS VARCHAR(50)) AS DISEASE_COND,CAST(DISEASE_COND_NAME AS VARCHAR(100)) AS DISEASE_COND_NAME, CAST(NULL AS VARCHAR(150)) AS HCC_SUBCAT_DESC, PLAN_DIM_CK,
STATE_CODE, GAP_IND1, GAP_IND2, RISK_MODEL, AID, PRO_GENERIC_PRODUCT_DESC, RATE_CELL_DESC, DIAG, DIAG_DESC,
DOS, NDC, NDC_DESC, MEMBER_MONTHS, RISK_SCORE, GAP_PROBABILITY
FROM MEDICAID_CONDITIONS)
        UNION ALL
(SELECT RUN_DT, LOB, MEMBERID AS MBRID,CAST(NULL AS VARCHAR(30)) AS MEDICAID_NBR, DISEASE_COND, CAST(NULL AS VARCHAR(40)) AS DISEASE_COND_NAME,DISEASE_COND_NAME, PLAN_DIM_CK,
STATE_CODE, GAP_IND1, GAP_IND2, CAST(RISK_MODEL AS VARCHAR(20)) AS RISK_MODEL, CAST(NULL AS VARCHAR(20)) AS AID, CAST(NULL AS VARCHAR(72)) AS PRO_GENERIC_PRODUCT_DESC, CAST(NULL AS VARCHAR(72)) AS RATE_CELL_DESC, DIAG, DIAG_DESC,
DOS, NDC, NDC_DESC, MEMBER_MONTHS, RISK_SCORE, GAP_PROBABILITY
FROM MARKETPLACE_CONDITIONS) AS M

In my SQL query I'm trying to union two tables together however, whenever I run the query I get the following error message: teradata syntax error expected something like a name or a unicode delimited identifier or an udfcallname keyword between ')' and the 'union' keyword. Below is a snippet of the query. What is causing this issue and what edit should I make to resolve this issue?

 FROM 
(SELECT RUN_DT, CAST(LOB AS VARCHAR(11)) AS LOB, MBRID, MEDICAID_NBR, CAST(DISEASE_COND AS VARCHAR(50)) AS DISEASE_COND,CAST(DISEASE_COND_NAME AS VARCHAR(100)) AS DISEASE_COND_NAME, CAST(NULL AS VARCHAR(150)) AS HCC_SUBCAT_DESC, PLAN_DIM_CK,
STATE_CODE, GAP_IND1, GAP_IND2, RISK_MODEL, AID, PRO_GENERIC_PRODUCT_DESC, RATE_CELL_DESC, DIAG, DIAG_DESC,
DOS, NDC, NDC_DESC, MEMBER_MONTHS, RISK_SCORE, GAP_PROBABILITY
FROM MEDICAID_CONDITIONS)
        UNION ALL
(SELECT RUN_DT, LOB, MEMBERID AS MBRID,CAST(NULL AS VARCHAR(30)) AS MEDICAID_NBR, DISEASE_COND, CAST(NULL AS VARCHAR(40)) AS DISEASE_COND_NAME,DISEASE_COND_NAME, PLAN_DIM_CK,
STATE_CODE, GAP_IND1, GAP_IND2, CAST(RISK_MODEL AS VARCHAR(20)) AS RISK_MODEL, CAST(NULL AS VARCHAR(20)) AS AID, CAST(NULL AS VARCHAR(72)) AS PRO_GENERIC_PRODUCT_DESC, CAST(NULL AS VARCHAR(72)) AS RATE_CELL_DESC, DIAG, DIAG_DESC,
DOS, NDC, NDC_DESC, MEMBER_MONTHS, RISK_SCORE, GAP_PROBABILITY
FROM MARKETPLACE_CONDITIONS) AS M

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文