[jira] [Created] (KYLIN-4210) Support the custom year, month, and day field name partition for the fact table

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

chuxiao created KYLIN-4210:
------------------------------

             Summary: Support the custom year, month, and day field name partition for the fact table 
                 Key: KYLIN-4210
                 URL: https://issues.apache.org/jira/browse/KYLIN-4210
             Project: Kylin
          Issue Type: Improvement
          Components: Job Engine
    Affects Versions: v3.0.0-alpha
            Reporter: chuxiao


YearMonthDayPartitionConditionBuilder supports partitions named year, month, day, but can not supportl other 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 partition 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 ','. Partition_condition_builder is org.apache.kylin.metadata.model.PartitionDesc$CustomYearMonthDayFieldPartitionConditionBuilder



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