couldn't resolve slot descriptor when 1=0

[EmmyMiao87]

--ddl DROP TABLE duer_dm_client_stab; CREATE TABLE duer_dm_client_stab(event_dayvarchar(128) NOT NULL COMMENT "日期",client_idvarchar(128) NOT NULL COMMENT "厂商唯一ID",appidvarchar(128) NOT NULL COMMENT "厂商唯一ID",appnamevarchar(256) NOT NULL COMMENT "厂商名称",asr_result_typevarchar(64) NOT NULL COMMENT "语音识别结果",error_typevarchar(64) NOT NULL COMMENT "错误类型",pvINT REPLACE NOT NULL COMMENT "pv",uvINT REPLACE NOT NULL COMMENT "uv",pv_pctDOUBLE REPLACE NOT NULL COMMENT "pv占比",uv_pct DOUBLE REPLACE NOT NULL COMMENT "uv占比" ) ENGINE=OLAP AGGREGATE KEY(event_day, client_id, appid, appname, asr_result_type, error_type) DISTRIBUTED BY HASH(event_day`) BUCKETS 32
PROPERTIES (
"storage_type" = "COLUMN"
);

--query
SELECT
event_day,
'all' as appversion,
SUM(
CASE WHEN error_type = '2' THEN pv ELSE 0 END
) AS pv_asr_weak,
SUM(
CASE WHEN error_type = '3' THEN pv ELSE 0 END
) AS pv_user_cancel,
SUM(
CASE WHEN error_type = '4' THEN pv ELSE 0 END
) AS pv_net_error,
SUM(
CASE WHEN error_type = '5' THEN pv ELSE 0 END
) AS pv_no_response,
SUM(
CASE WHEN error_type = '1000' THEN pv ELSE 0 END
) AS pv_other_error,
SUM(
CASE WHEN error_type = '-1' THEN pv ELSE 0 END
) AS pv_other,
SUM(pv) AS pv_all,
ROUND(
100 * SUM(
CASE WHEN error_type = '2' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_asr_weak_pct,
ROUND(
100 * SUM(
CASE WHEN error_type = '3' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_user_cancel_pct,
ROUND(
100 * SUM(
CASE WHEN error_type = '4' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_net_error_pct,
ROUND(
100 * SUM(
CASE WHEN error_type = '5' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_no_response_pct,
ROUND(
100 * SUM(
CASE WHEN error_type = '1000' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_other_error_pct,
ROUND(
100 * SUM(
CASE WHEN error_type = '-1' THEN pv ELSE 0 END
)/ SUM(pv),
4
) pv_other_pct
FROM
duer_dm_client_stab
WHERE
event_day between 20190817
and 20190916
AND appname = '小度智能音箱'
AND error_type != 'all'
and 1 = 0
GROUP BY
event_day;`
1=0 is incorrect while 1=1 is correct.