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