您好, 我们公司在使用spark-3.1.2 以及 kylin4.0.0版本时,再kylin4创建model页面,setting选项卡中,添加了filter条件。但是构建cube失败,提示不能解析 filter 条件的属性。详细问题如下 filter如下图 报错提示如下: 2022-03-14 18:59:05,037 ERROR [Thread-1] application.SparkApplication : The spark job execute failed! org.apache.spark.sql.AnalysisException: cannot resolve '`first_level_category`' given input columns: 以下是 columns 内容:其中与first_level_category相关的就是 RZP_INDUSTRY_0_DOT_0_FIRST_LEVEL_CATEGORY !
[DATE_DIMENSION_TABLE_0_DOT_0_DT_DATE, DATE_DIMENSION_TABLE_0_DOT_0_DT_DAY, DATE_DIMENSION_TABLE_0_DOT_0_DT_MONTH, DATE_DIMENSION_TABLE_0_DOT_0_DT_SEASON, DATE_DIMENSION_TABLE_0_DOT_0_DT_YEAR, RZP_INDUSTRY_0_DOT_0_BOX_QUANTITY, RZP_INDUSTRY_0_DOT_0_BRAND, RZP_INDUSTRY_0_DOT_0_COLLECTION_NUM, RZP_INDUSTRY_0_DOT_0_DATA_MONTH, RZP_INDUSTRY_0_DOT_0_FEATURE_CALCIUM, RZP_INDUSTRY_0_DOT_0_FEATURE_CUSTOMER_GROUP, RZP_INDUSTRY_0_DOT_0_FEATURE_FAT, RZP_INDUSTRY_0_DOT_0_FEATURE_IMPORTED, RZP_INDUSTRY_0_DOT_0_FEATURE_IRON_ZINC, RZP_INDUSTRY_0_DOT_0_FEATURE_ORGANIC, RZP_INDUSTRY_0_DOT_0_FEATURE_PLACE_OF_PRODUCTION, RZP_INDUSTRY_0_DOT_0_FEATURE_PREBIOTICS, RZP_INDUSTRY_0_DOT_0_FEATURE_PROTEIN, RZP_INDUSTRY_0_DOT_0_FEATURE_SUGAR, RZP_INDUSTRY_0_DOT_0_FIRST_LEVEL_CATEGORY, RZP_INDUSTRY_0_DOT_0_INNER_PACKAGE, RZP_INDUSTRY_0_DOT_0_ONLINE_CHANEL, RZP_INDUSTRY_0_DOT_0_OUTER_PACKAGE, RZP_INDUSTRY_0_DOT_0_PACKING_QUANTITY, RZP_INDUSTRY_0_DOT_0_PRICE_SEGMENT, RZP_INDUSTRY_0_DOT_0_PRODUCT_FIRST_PICTURE, RZP_INDUSTRY_0_DOT_0_PRODUCT_LINK, RZP_INDUSTRY_0_DOT_0_PRODUCT_TITLE, RZP_INDUSTRY_0_DOT_0_SALES_VALUE, RZP_INDUSTRY_0_DOT_0_SALES_VOLUME, RZP_INDUSTRY_0_DOT_0_SALES_VOLUME_PRODUCT, RZP_INDUSTRY_0_DOT_0_SECOND_LEVEL_CATEGORY, RZP_INDUSTRY_0_DOT_0_SERIES, RZP_INDUSTRY_0_DOT_0_SHOP_FANS_NUM, RZP_INDUSTRY_0_DOT_0_SHOP_LINK, RZP_INDUSTRY_0_DOT_0_SHOP_NAME, RZP_INDUSTRY_0_DOT_0_SHOP_TYPE, RZP_INDUSTRY_0_DOT_0_SINGLE_PACKAGE_CAPACITY, RZP_INDUSTRY_0_DOT_0_SINGLE_PACKAGE_PRICE, RZP_INDUSTRY_0_DOT_0_SKU, RZP_INDUSTRY_0_DOT_0_SKU_CURRENT_PRICE, RZP_INDUSTRY_0_DOT_0_SKU_ORIGINAL_PRICE, RZP_INDUSTRY_0_DOT_0_SPECIFICATION_UNIT_PRICE, RZP_INDUSTRY_0_DOT_0_SPEC_FLAVOUR]; line 1 pos 0; 'Filter ('first_level_category = 奶粉) 如果从以上数组中确实是找不到first_level_category字段。 期待kylin团队,帮助我们解决该问题。感谢! zhouzhih...@bxtdata.com