您好,
    我们公司在使用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字段。


zhouzhih...@bxtdata.com

Reply via email to