3.3.17版本 查询视图sql执行失败 报错: 统计信息找不到, missing statistic of col

💬 StarRocks 用户问答
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
(java.sql.SQLException) (conn=40748) only found column statistics: {1: date, 2: platform, 3: product_id, 4: product_name, 5: shop_name, 6: shop_logo_url, 7: shop_owner, 8: credit, 9: brand_name, 10: brand_logo_url, 11: list_price, 12: average_price, 13: sales_volume, 14: total_sales, 17: pic_url, 18: shop_id, 22: collect_count, 23: comment_count, 28: category_mapping, 30: property_dto_list, 34: dt, 35: property_json, 36: date_format, 38: wenben, 39: shuzi, 40: riqi, 44: update_time, 47: xiaoliang_richj2te30, 48: pingtai, 49: shangpinmingcheng, 50: dianpumingcheng, 51: dpLogolj, 52: suoshupinpai, 53: ppLogolj, 54: biaojia, 55: tupianlianjie, 56: dianpuID, 58: yingxiaoliebiao, 60: date_format, 62: shuzi, 63: riqi, 65: xiaoliang_richj2te30, 66: pingtai, 67: shangpinmingcheng, 68: dianpumingcheng, 69: dpLogolj, 70: suoshupinpai, 71: ppLogolj, 72: biaojia, 73: tupianlianjie, 74: dianpuID, 75: yingxiaoliebiao, 77: expr, 78: row_number(), 79: concat}, but missing statistic of col: 133: json_query.

sql:
/“sqltype” = ‘UPDATE’,“sqlid” = ‘1760205632099-z0ln’,“tasktype” = ‘etlDevelopTask’,“set_var.phased_scheduler_max_concurrency” = ‘1’,“userid” = ‘1’,“set_var.enable_phased_scheduler” = ‘true’,“fabric-jobId” = ‘171564bf-25a4-a8c7-6317-02d4cbb95c00’,“set_var.pipeline_dop” = ‘1’,“set_var.connector_scan_use_query_mem_ratio” = ‘0.1’,“instanceid” = ‘otQvFCpMsz-UXW2M3’,“logid” = ‘M0KIfuO2ZJ’,“objecttype” = ‘TASK’,“objectid” = ‘otQvFCpMsz’/ INSERT /*+ SET_VAR(“enable_phased_scheduler”= ‘true’, “phased_scheduler_max_concurrency”= ‘1’, “pipeline_dop”= ‘1’, “connector_scan_use_query_mem_ratio”= ‘0.1’) */
OVERWRITE lake.saas_hq_datalake.ads_ldl_product_sale_amount_rank_stat_info_f (stat_date, platform, industry, category, shop_name, shop_logo_url, shop_owner, shop_url, brand_name, brand_logo_url, product_id, product_name, product_image_url, product_url, category_change_type, origin_place, list_price, avg_price, sales_num, sale_amount, credit, market_share_ratio, dt, collect_count, comment_count, big_category_id, big_category_name, category_id1, category_name1, category_id2, category_name2, category_id3, category_name3, category_id4, category_name4, last_category_id, last_category_name, parent_category_Id, level, status, yuce_market_category_id, shop_id, property_bitmap, property_dto_list) (SELECT CAST(stat_date AS VARCHAR) AS stat_date, CAST(platform AS VARCHAR) AS platform, CAST(industry AS VARCHAR) AS industry, CAST(category AS VARCHAR) AS category, CAST(shop_name AS VARCHAR) AS shop_name, CAST(shop_logo_url AS VARCHAR) AS shop_logo_url, CAST(shop_owner AS VARCHAR) AS shop_owner, CAST(shop_url AS VARCHAR) AS shop_url, CAST(brand_name AS VARCHAR) AS brand_name, CAST(brand_logo_url AS VARCHAR) AS brand_logo_url, CAST(product_id AS VARCHAR) AS product_id, CAST(product_name AS VARCHAR) AS product_name, CAST(product_image_url AS VARCHAR) AS product_image_url, CAST(product_url AS VARCHAR) AS product_url, CAST(category_change_type AS VARCHAR) AS category_change_type, CAST(origin_place AS VARCHAR) AS origin_place, (list_price) AS list_price, (avg_price) AS avg_price, CAST(sales_num AS DOUBLE) AS sales_num, (sale_amount) AS sale_amount, CAST(credit AS VARCHAR) AS credit, CAST(market_share_ratio AS DOUBLE) AS market_share_ratio, CAST(dt AS VARCHAR) AS dt, CAST(collect_count AS DOUBLE) AS collect_count, CAST(comment_count AS DOUBLE) AS comment_count, CAST(big_category_id AS VARCHAR) AS big_category_id, CAST(big_category_name AS VARCHAR) AS big_category_name, CAST(category_id1 AS VARCHAR) AS category_id1, CAST(category_name1 AS VARCHAR) AS category_name1, CAST(category_id2 AS VARCHAR) AS category_id2, CAST(category_name2 AS VARCHAR) AS category_name2, CAST(category_id3 AS VARCHAR) AS category_id3, CAST(category_name3 AS VARCHAR) AS category_name3, CAST(category_id4 AS VARCHAR) AS category_id4, CAST(category_name4 AS VARCHAR) AS category_name4, CAST(last_category_id AS VARCHAR) AS last_category_id, CAST(last_category_name AS VARCHAR) AS last_category_name, CAST(parent_category_Id AS VARCHAR) AS parent_category_Id, CAST(level AS VARCHAR) AS level, CAST(status AS VARCHAR) AS status, CAST(yuce_market_category_id AS VARCHAR) AS yuce_market_category_id, CAST(shop_id AS VARCHAR) AS shop_id, CAST(property_bitmap AS VARCHAR) AS property_bitmap, CAST(property_dto_list AS VARCHAR) AS property_dto_list
FROM (SELECT CASE WHEN STR_TO_DATE(CONCAT(date, ‘01’), ‘%Y%m%d’) IS NOT NULL THEN CAST(STR_TO_DATE(CONCAT(date, ‘01’), ‘%Y%m%d’) AS VARCHAR) ELSE stat_date END AS stat_date, CASE WHEN platform_name IS NOT NULL THEN platform_name ELSE ‘未知’ END AS platform, CASE WHEN CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tName’ AS VARCHAR) IS NOT NULL THEN CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tName’ AS VARCHAR) ELSE ‘未知’ END AS industry, CASE WHEN CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat4tName’ AS VARCHAR) IS NOT NULL THEN CONCAT(CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat2tName’ AS VARCHAR), ‘->’, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat3tName’ AS VARCHAR), ‘->’, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat4tName’ AS VARCHAR)) WHEN CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat3tName’ AS VARCHAR) IS NOT NULL THEN CONCAT(CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat2tName’ AS VARCHAR), ‘->’, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat3tName’ AS VARCHAR)) ELSE CONCAT(CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat2tName’ AS VARCHAR)) END AS category, CASE WHEN shop_name IS NOT NULL THEN shop_name WHEN shop_name0 IS NOT NULL THEN shop_name0 ELSE ‘未知’ END AS shop_name, CASE WHEN shop_logo_url IS NOT NULL THEN shop_logo_url WHEN shop_logo_url0 IS NOT NULL THEN shop_logo_url0 ELSE ‘未知’ END AS shop_logo_url, CASE WHEN shop_owner IS NOT NULL THEN shop_owner ELSE ‘未知’ END AS shop_owner, CONCAT(CONCAT(‘http://shop’, shop_id), ‘.m.taobao.com/?’) AS shop_url, CASE WHEN brand_name IS NOT NULL THEN brand_name WHEN brand_name0 IS NOT NULL THEN brand_name0 ELSE ‘未知’ END AS brand_name, CASE WHEN brand_logo_url IS NOT NULL THEN brand_logo_url WHEN brand_logo_url0 IS NOT NULL THEN brand_logo_url0 ELSE ‘未知’ END AS brand_logo_url, CASE WHEN product_id IS NOT NULL THEN product_id WHEN product_id0 IS NOT NULL THEN product_id0 ELSE ‘未知’ END AS product_id, CASE WHEN product_name IS NOT NULL THEN product_name WHEN product_name0 IS NOT NULL THEN product_name0 ELSE ‘未知’ END AS product_name, CASE WHEN pic_url IS NOT NULL THEN pic_url WHEN product_image_url IS NOT NULL THEN product_image_url ELSE ‘未知’ END AS product_image_url, CASE WHEN CAST(NULL AS VARCHAR) IS NOT NULL THEN CAST(NULL AS VARCHAR) ELSE ‘未知’ END AS product_url, CASE WHEN CAST(NULL AS VARCHAR) IS NOT NULL THEN CAST(NULL AS VARCHAR) ELSE ‘未知’ END AS category_change_type, CASE WHEN CAST(NULL AS VARCHAR) IS NOT NULL THEN CAST(NULL AS VARCHAR) ELSE ‘未知’ END AS origin_place, CASE WHEN CASE WHEN CAST(list_price AS DECIMAL(38, 8)) IS NOT NULL THEN CAST(list_price AS DECIMAL(38, 8)) ELSE 0 END / 100 IS NOT NULL THEN CAST(CASE WHEN CAST(list_price AS DECIMAL(38, 8)) IS NOT NULL THEN CAST(list_price AS DECIMAL(38, 8)) ELSE 0 END / 100 AS DOUBLE) ELSE list_price0 END AS list_price, CASE WHEN price IS NOT NULL THEN price ELSE CAST(CASE WHEN CAST(average_price AS DECIMAL(38, 8)) IS NOT NULL THEN CAST(average_price AS DECIMAL(38, 8)) ELSE 0 END / 100 AS DOUBLE) END AS avg_price, CASE WHEN sale_num IS NOT NULL THEN CAST(sale_num AS VARCHAR) WHEN sales_volume IS NOT NULL THEN sales_volume ELSE CAST(CAST(0 AS VARCHAR) AS VARCHAR) END AS sales_num, CASE WHEN CAST(CAST(sale_num AS DECIMAL(26, 8)) * CAST(price AS DECIMAL(26, 8)) AS DECIMAL(26, 8)) IS NOT NULL THEN CAST(CAST(sale_num AS DECIMAL(26, 8)) * CAST(price AS DECIMAL(26, 8)) AS DECIMAL(26, 8)) ELSE CAST(CASE WHEN CAST(total_sales AS DECIMAL(38, 8)) IS NOT NULL THEN CAST(total_sales AS DECIMAL(38, 8)) ELSE 0 END / 100 AS DOUBLE) END AS sale_amount, CASE WHEN CAST(CAST(credit AS BIGINT) AS VARCHAR) IS NOT NULL THEN CAST(CAST(credit AS BIGINT) AS VARCHAR) ELSE ‘未知’ END AS credit, CASE WHEN CAST(NULL AS VARCHAR) IS NOT NULL THEN CAST(NULL AS INT) ELSE 0 END AS market_share_ratio, CASE WHEN dt IS NOT NULL THEN dt ELSE stat_date END AS dt, collect_count, comment_count, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘bigCategoryId’ AS VARCHAR) AS big_category_id, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘bigCategoryName’ AS VARCHAR) AS big_category_name, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tId’ AS VARCHAR) AS category_id1, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tName’ AS VARCHAR) AS category_name1, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat2tId’ AS VARCHAR) AS category_id2, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat2tName’ AS VARCHAR) AS category_name2, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat3tId’ AS VARCHAR) AS category_id3, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat3tName’ AS VARCHAR) AS category_name3, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat4tId’ AS VARCHAR) AS category_id4, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat4tName’ AS VARCHAR) AS category_name4, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘lastCategoryId’ AS VARCHAR) AS last_category_id, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘lastCategoryName’ AS VARCHAR) AS last_category_name, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘parentCategoryId’ AS VARCHAR) AS parent_category_Id, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘level’ AS VARCHAR) AS level, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘status’ AS VARCHAR) AS status, CAST(CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tId’ AS VARCHAR) AS yuce_market_category_id, CASE WHEN shop_id IS NOT NULL THEN shop_id ELSE shop_id0 END AS shop_id, property_json AS property_bitmap, property_dto_list
FROM (SELECT t2.date, t2.platform, t2.product_id, t2.product_name, t2.shop_name, t2.shop_logo_url, t2.shop_owner, t2.credit, t2.brand_name, t2.brand_logo_url, t2.list_price, t2.average_price, t2.sales_volume, t2.total_sales, t2.pic_url, t2.shop_id, t2.collect_count, t2.comment_count, t2.category_mapping, t2.property_dto_list, t2.dt, t2.property_json, t2.product_id0, t2.stat_date, t2.price, t2.sale_num, t2.platform0, t2.product_name0, t2.shop_name0, t2.shop_logo_url0, t2.brand_name0, t2.brand_logo_url0, t2.list_price0, t2.product_image_url, t2.shop_id0, t2.category_mapping0, dim_platform.platform_name
FROM ((SELECT date, platform, product_id, product_name, shop_name, shop_logo_url, shop_owner, credit, brand_name, brand_logo_url, list_price, average_price, sales_volume, total_sales, pic_url, shop_id, collect_count, comment_count, category_mapping, property_dto_list, dt, property_json, product_id0, stat_date, price, sale_num, platform0, product_name0, shop_name0, shop_logo_url0, brand_name0, brand_logo_url0, list_price0, product_image_url, shop_id0, category_mapping0, $f49
FROM (SELECT ods_api_product_rank_sale_amount_market_f.date, ods_api_product_rank_sale_amount_market_f.platform, ods_api_product_rank_sale_amount_market_f.product_id, ods_api_product_rank_sale_amount_market_f.product_name, ods_api_product_rank_sale_amount_market_f.shop_name, ods_api_product_rank_sale_amount_market_f.shop_logo_url, ods_api_product_rank_sale_amount_market_f.shop_owner, ods_api_product_rank_sale_amount_market_f.credit, ods_api_product_rank_sale_amount_market_f.brand_name, ods_api_product_rank_sale_amount_market_f.brand_logo_url, ods_api_product_rank_sale_amount_market_f.list_price, ods_api_product_rank_sale_amount_market_f.average_price, ods_api_product_rank_sale_amount_market_f.sales_volume, ods_api_product_rank_sale_amount_market_f.total_sales, ods_api_product_rank_sale_amount_market_f.pic_url, ods_api_product_rank_sale_amount_market_f.shop_id, ods_api_product_rank_sale_amount_market_f.collect_count, ods_api_product_rank_sale_amount_market_f.comment_count, ods_api_product_rank_sale_amount_market_f.category_mapping, ods_api_product_rank_sale_amount_market_f.property_dto_list, ods_api_product_rank_sale_amount_market_f.dt, ods_api_product_rank_sale_amount_market_f.property_json, ods_excel_fix_product_stat_info_f.product_id AS product_id0, ods_excel_fix_product_stat_info_f.stat_date, ods_excel_fix_product_stat_info_f.price, ods_excel_fix_product_stat_info_f.sale_num, ods_excel_fix_product_stat_info_f.platform AS platform0, ods_excel_fix_product_stat_info_f.product_name AS product_name0, ods_excel_fix_product_stat_info_f.shop_name AS shop_name0, ods_excel_fix_product_stat_info_f.shop_logo_url AS shop_logo_url0, ods_excel_fix_product_stat_info_f.brand_name AS brand_name0, ods_excel_fix_product_stat_info_f.brand_logo_url AS brand_logo_url0, ods_excel_fix_product_stat_info_f.list_price AS list_price0, ods_excel_fix_product_stat_info_f.product_image_url, ods_excel_fix_product_stat_info_f.shop_id AS shop_id0, ods_excel_fix_product_stat_info_f.category_mapping AS category_mapping0, CASE WHEN ods_api_product_rank_sale_amount_market_f.platform IS NOT NULL THEN ods_api_product_rank_sale_amount_market_f.platform WHEN ods_excel_fix_product_stat_info_f.platform IS NOT NULL THEN ods_excel_fix_product_stat_info_f.platform ELSE ‘1’ END AS $f49
FROM ((SELECT date AS date, platform AS platform, product_id AS product_id, product_name AS product_name, shop_name AS shop_name, shop_logo_url AS shop_logo_url, shop_owner AS shop_owner, credit AS credit, brand_name AS brand_name, brand_logo_url AS brand_logo_url, list_price AS list_price, average_price AS average_price, sales_volume AS sales_volume, total_sales AS total_sales, pic_url AS pic_url, shop_id AS shop_id, collect_count AS collect_count, comment_count AS comment_count, category_mapping AS category_mapping, property_dto_list AS property_dto_list, dt AS dt, property_json AS property_json, $f35
FROM (SELECT ods_api_product_rank_sale_amount_market_f.date, ods_api_product_rank_sale_amount_market_f.platform, ods_api_product_rank_sale_amount_market_f.product_id, ods_api_product_rank_sale_amount_market_f.product_name, ods_api_product_rank_sale_amount_market_f.shop_name, ods_api_product_rank_sale_amount_market_f.shop_logo_url, ods_api_product_rank_sale_amount_market_f.shop_owner, ods_api_product_rank_sale_amount_market_f.credit, ods_api_product_rank_sale_amount_market_f.brand_name, ods_api_product_rank_sale_amount_market_f.brand_logo_url, ods_api_product_rank_sale_amount_market_f.list_price, ods_api_product_rank_sale_amount_market_f.average_price, ods_api_product_rank_sale_amount_market_f.sales_volume, ods_api_product_rank_sale_amount_market_f.total_sales, ods_api_product_rank_sale_amount_market_f.pic_url, ods_api_product_rank_sale_amount_market_f.shop_id, ods_api_product_rank_sale_amount_market_f.collect_count, ods_api_product_rank_sale_amount_market_f.comment_count, ods_api_product_rank_sale_amount_market_f.category_mapping, ods_api_product_rank_sale_amount_market_f.property_dto_list, ods_api_product_rank_sale_amount_market_f.dt, ods_api_product_rank_sale_amount_market_f.property_json, DATE_FORMAT(STR_TO_DATE(CONCAT(ods_api_product_rank_sale_amount_market_f.date, ‘01’), ‘%Y%m%d’), ‘%Y-%m-%d’) AS $f35
FROM lake.saas_hq_datalake.ods_api_product_rank_sale_amount_market_f) AS ods_api_product_rank_sale_amount_market_f) AS ods_api_product_rank_sale_amount_market_f FULL JOIN (SELECT wenben AS product_id, CONCAT(DATE_FORMAT(riqi, ‘%Y-%m’), ‘-01’) AS stat_date, shuzi AS price, xiaoliang_richj2te30 AS sale_num, pingtai AS platform, shangpinmingcheng AS product_name, dianpumingcheng AS shop_name, dpLogolj AS shop_logo_url, suoshupinpai AS brand_name, ppLogolj AS brand_logo_url, biaojia AS list_price, tupianlianjie AS product_image_url, dianpuID AS shop_id, yingxiaoliebiao AS category_mapping
FROM (SELECT wenben, shuzi, riqi, update_time, xiaoliang_richj2te30, pingtai, shangpinmingcheng, dianpumingcheng, dpLogolj, suoshupinpai, ppLogolj, biaojia, tupianlianjie, dianpuID, yingxiaoliebiao, $23, ROW_NUMBER() OVER (PARTITION BY wenben, $23 ORDER BY update_time IS NULL DESC, update_time DESC) AS w0$o0
FROM (SELECT ods_excel_fix_product_stat_info_f.wenben, ods_excel_fix_product_stat_info_f.shuzi, ods_excel_fix_product_stat_info_f.riqi, ods_excel_fix_product_stat_info_f.update_time, ods_excel_fix_product_stat_info_f.xiaoliang_richj2te30, ods_excel_fix_product_stat_info_f.pingtai, ods_excel_fix_product_stat_info_f.shangpinmingcheng, ods_excel_fix_product_stat_info_f.dianpumingcheng, ods_excel_fix_product_stat_info_f.dpLogolj, ods_excel_fix_product_stat_info_f.suoshupinpai, ods_excel_fix_product_stat_info_f.ppLogolj, ods_excel_fix_product_stat_info_f.biaojia, ods_excel_fix_product_stat_info_f.tupianlianjie, ods_excel_fix_product_stat_info_f.dianpuID, ods_excel_fix_product_stat_info_f.yingxiaoliebiao, DATE_FORMAT(ods_excel_fix_product_stat_info_f.riqi, ‘%Y-%m’) AS $23
FROM default_catalog.cubeappdata_hq.ods_excel_fix_product_stat_info_f
WHERE CAST(ods_excel_fix_product_stat_info_f.yingxiaoliebiao AS JSON) -> ‘cat1tId’ IS NOT NULL AND DATE_FORMAT(ods_excel_fix_product_stat_info_f.riqi, ‘%Y-%m’) IS NOT NULL AND ods_excel_fix_product_stat_info_f.wenben IS NOT NULL) AS ods_excel_fix_product_stat_info_f) AS ods_excel_fix_product_stat_info_f
WHERE w0$o0 = 1) AS ods_excel_fix_product_stat_info_f ON (ods_api_product_rank_sale_amount_market_f.$f35 = ods_excel_fix_product_stat_info_f.stat_date AND ods_api_product_rank_sale_amount_market_f.product_id = ods_excel_fix_product_stat_info_f.product_id))) AS t0) AS t2 LEFT JOIN (SELECT dim_platform.platform_id, MAX(dim_platform.platform_name) AS platform_name
FROM lake.saas_hq_datalake.dim_platform
WHERE dim_platform.channel = ‘炼丹炉’
GROUP BY dim_platform.channel, dim_platform.platform_id) AS dim_platform ON t2.$f49 = dim_platform.platform_id)) AS t3
WHERE CAST(CASE WHEN category_mapping IS NOT NULL THEN category_mapping ELSE category_mapping0 END AS JSON) -> ‘cat1tId’ IS NOT NULL AND CASE WHEN platform IS NOT NULL THEN platform WHEN platform0 IS NOT NULL THEN platform0 ELSE ‘1’ END IS NOT NULL) AS t5)

【背景】做过哪些操作？
查询的表是视图

【业务影响】
【是否存算分离】
【StarRocks版本】例如：3.3.17
【集群规模】例如：3fe（3 follower+0observer）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群16-可乐鸡或者邮箱，谢谢
【附件】

京ICP备2022026421号-1