ClickHouse SQL 错误：Missing columns: 'CrashIdentifier' - 解决方案

{"title": "ClickHouse SQL 错误：Missing columns: 'CrashIdentifier' - 解决方案", "description": "本文介绍 ClickHouse SQL 查询中出现的 "Missing columns: 'CrashIdentifier'" 错误，并提供解决方案。错误通常发生在子查询中引用了错误的列名，导致无法找到对应数据。", "keywords": "ClickHouse, SQL, 错误, Missing columns, CrashIdentifier, 子查询, 列名, 解决方案", "content": "SELECT\n PlatformType AS PlatformType,\n (CASE\n WHEN PlatformType IN (1, 3, 5, 7) THEN (\n SELECT COUNT(crash_uuid)\n FROM log_iOS_crash\n WHERE crash_uuid = log_iMonkey_Wechat_overview.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 crashid = log_iMonkey_Wechat_overview.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"}