ClickHouse SQL Query Error: Missing Columns 'CrashIdentifier', 'uuid', and 'Ds' - Troubleshooting Guide

{/'title/':/'SELECT //n PlatformType AS PlatformType,//n (CASE //n WHEN PlatformType IN (1, 3, 5, 7) THEN (//n SELECT COUNT(uuid)//n FROM log_iOS_crash//n WHERE uuid = CrashIdentifier//n AND Ds >= toDateTime(#day_wechat_crash_time.start#)//n AND Ds <= toDateTime(#day_wechat_crash_time.end#)//n )//n WHEN PlatformType IN (2, 4, 6, 8) THEN (//n SELECT COUNT(crashid)//n FROM log_android_crash//n WHERE uuid = CrashIdentifier//n AND Ds >= toDateTime(#day_wechat_crash_time.start#)//n AND Ds <= toDateTime(#day_wechat_crash_time.end#)//n )//n ELSE 0//n END) AS index_crashcount_0//nFROM log_iMonkey_Wechat_overview//nWHERE Debug = 0 AND PlatformType != 0 AND CrashIdentifier != '' AND//n Ds >= toDateTime(#day_wechat_crash_time.start#)//n AND Ds <= toDateTime(#day_wechat_views_time.end#) //nGROUP BY PlatformType//nORDER BY index_crashcount_0 DESC//nLIMIT 5000//n报错errormessage: 运行SQL失败:[404]运行异常: Code: 47. DB::Exception: Missing columns: 'CrashIdentifier' while processing query: 'SELECT count(uuid) FROM log_iOS_crash WHERE (uuid = CrashIdentifier) AND (Ds >= toDateTime('2023-06-12 00:00:00')) AND (Ds <= toDateTime('2023-07-11 23:59:59'))', required columns: 'uuid' 'CrashIdentifier' 'Ds', maybe you meant: ['uuid','Ds']: While processing (SELECT count(uuid) FROM log_iOS_crash WHERE (uuid = CrashIdentifier) AND (Ds >= toDateTime('2023-06-12 00:00:00')) AND (Ds <= toDateTime('2023-07-11 23:59:59'))) AS _subquery1142: While processing multiIf((PlatformType AS PlatformType) IN (1, 3, 5, 7), (SELECT count(uuid) FROM log_iOS_crash WHERE (uuid = CrashIdentifier) AND (Ds >= toDateTime('2023-06-12 00:00:00')) AND (Ds <= toDateTime('2023-07-11 23:59:59'))) AS _subquery1142, PlatformType IN (2, 4, 6, 8), (SELECT count(crashid) FROM log_android_crash WHERE (uuid = CrashIdentifier) AND (Ds >= toDateTime('2023-06-12 00:00:00')) AND (Ds <= toDateTime('2023-07-11 23:59:59'))) AS _subquery1143, 0) AS index_crashcount_0. (UNKNOWN_IDENTIFIER) (version 52.3.10.8)//n(request_id:293f3ddd36e0488cb26fe55d30d2318c)//nurl: https://fisherbi.woa.com/iExplorer/dashboard/editor/10689//n怎么修改内容：根据报错信息，可以看出在子查询中缺少必要的列/'CrashIdentifier/'、/'uuid/'和/'Ds/'，可能是由于表中缺少这些列或者列名写错导致的。你需要检查以下几点来修改代码：//n//n1. 确认表/'log_iOS_crash/'中是否存在列/'uuid/'和/'Ds/'，并且列名是否正确。如果不存在或者列名不正确，需要修改子查询中相应的列名。//n//n2. 确认表/'log_android_crash/'中是否存在列/'uuid/'和/'Ds/'，并且列名是否正确。如果不存在或者列名不正确，需要修改子查询中相应的列名。//n//n请根据上述提示检查并修改代码，并重新运行查询。/