[jira] [Created] (KYLIN-4211) PartitionDesc support custom year、month、day partitions name

["chuxiao (Jira)" <ji...@apache.org>]

chuxiao created KYLIN-4211:
------------------------------

             Summary: PartitionDesc support custom year、month、day partitions name
                 Key: KYLIN-4211
                 URL: https://issues.apache.org/jira/browse/KYLIN-4211
             Project: Kylin
          Issue Type: Improvement
            Reporter: chuxiao


YearMonthDayPartitionConditionBuilder supports partition named year, month, day, but can not support partition names like Y, M, D.
Because there are user using  fact table partitioned by Y, M, D, so add CustomYearMonthDayFieldPartitionConditionBuilder, support custom year, month, day partitions name.

Partition metadata in model.json like:
{
  "uuid" : "459d48c1-a8a6-cdf5-6ea7-e2ae48b248e9",
  "last_modified" : 1571652918478,
  "version" : "2.6.0.20500",
  "name" : "kylin_sales_ymd",
  "owner" : "admin",
  "is_draft" : false,
  "description" : "",
  "fact_table" : "BIGDATA_KYLIN.KYLIN_SALES_YMD",
  "lookups" : [ ],
  "dimensions" : [ {
    "table" : "KYLIN_SALES_YMD",
    "columns" : [ "LEAF_CATEG_ID", "TRANS_ID", "SLR_SEGMENT_CD", "SELLER_ID", "BUYER_ID", "OPS_USER_ID", "OPS_REGION", "Y", "M", "D" ]
  } ],
  "metrics" : [ "KYLIN_SALES_YMD.PRICE", "KYLIN_SALES_YMD.ITEM_COUNT" ],
  "filter_condition" : "",
  "partition_desc" : {
    "partition_date_column" : "KYLIN_SALES_YMD.Y, KYLIN_SALES_YMD.M, KYLIN_SALES_YMD.D",
    "partition_time_column" : null,
    "partition_date_start" : 0,
    "partition_date_format" : "yyyy-MM-dd",
    "partition_time_format" : "HH:mm:ss",
    "partition_type" : "APPEND",
    "partition_condition_builder" : "org.apache.kylin.metadata.model.PartitionDesc$CustomYearMonthDayFieldPartitionConditionBuilder"
  },
  "capacity" : "MEDIUM"
}

Partition_date_column is the year, month, and day partition field split by ','.， and Partition_condition_builder is org.apache.kylin.metadata.model.PartitionDesc$CustomYearMonthDayFieldPartitionConditionBuilder
Web can create a normal model and  "Edit JSON"  on Kylin web



--
This message was sent by Atlassian Jira
(v8.3.4#803005)