sql - 为什么我会收到此错误-“预期结果集但不是从查询中生成的.....”

Question

我正在运行一个配置单元查询，该查询根据字段中是否存在给定值的实例来收集两个表的统计信息。但是，当我运行下面的代码时，我收到一个错误：

 WITH AB AS (
    SELECT substr(A1.tm, 1,10) as MY_DATE , A1.MY_ID
    FROM db1.table1 A1 ,db1.table2 A2  WHERE
 A1.MY_ID=A2.MY_ID AND A2.TXT LIKE '%Check%' and LENGTH(trim(a2.txt))  < 65
    and  substr(A1.tm, 1,10)= date_sub(current_timestamp(),1)
    ),
    BC AS ( 
    SELECT  AB.MY_DATE,  AB.MY_ID ,
    CASE WHEN (TXT like '%Do you need assistance%') THEN '1' ,
    WHEN  (TXT like '%transfer%') THEN '2' ELSE NULL END 
    AS NODE
    FROM AB left JOIN db1.table2 BC ON AB.MY_ID =BC.MY_ID
    where substr(tm, 1,10)= date_sub(current_timestamp(),1)
    )
    CD AS (
    SELECT  AB.RPT_DATE, 
    SUM ( CASE WHEN NODE_1=1 THEN 1 ELSE 0 ) AS
    CONTAINMENT ,
    SUM ( CASE WHEN NODE_1=2 THEN 1 ELSE 0 ) AS HANDOFF , 
    COUNT(DISTINCT AB.MY_ID) AS VOL_TOTAL
    FROM BC
    GROUP BY AB.RPT_DATE
    )
    SELECT coalesce(BC.RPT_date ,date_sub(current_timestamp(),1)) as MY_DATE  ,
    COALESCE(BC.VOL_TOTAL,0) AS VOL_TOTAL  ,COALESCE (BC.CONTAINMENT,0) AS CONTAINMENT ,
    COALESCE (BC.HANDOFF,0) AS HANDOFF ,
    'v' as catg
    FROM CD;

我收到“预期结果集但未从查询“With AB AS() .....”生成的错误。任何想法或建议说明为什么会这样？

我知道没有太多背景，但在语法方面有什么遗漏吗？

标签： sqlhivecasehiveql