文档
测试

创建Model

POST
http://192.168.88.132:7070/kylin/api/models

请求头

参数名
类型
描述
必填
Authorization
string
示例:Basic QURNSU46S1lMSU4=
必填

请求参数

参数名
类型
描述
必填
modelDescData
string
示例:{"uuid": "0928468a-9fab-4185-9a14-6f2e7c74823f","last_modified": 0,"version": "3.0.0.20500","name": "Tmodel","owner": null,"is_draft": false,"description": "","fact_table": "DEFAULT.KYLIN_SALES","lookups": [{"table": "DEFAULT.KYLIN_CAL_DT","kind": "LOOKUP","alias": "KYLIN_CAL_DT","join": {"type": "inner","primary_key": ["KYLIN_CAL_DT.CAL_DT"],"foreign_key": ["KYLIN_SALES.PART_DT"]}},{"table": "DEFAULT.KYLIN_CATEGORY_GROUPINGS","kind": "LOOKUP","alias": "KYLIN_CATEGORY_GROUPINGS","join": {"type": "inner","primary_key": ["KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID","KYLIN_CATEGORY_GROUPINGS.SITE_ID"],"foreign_key": ["KYLIN_SALES.LEAF_CATEG_ID","KYLIN_SALES.LSTG_SITE_ID"]}},{"table": "DEFAULT.KYLIN_ACCOUNT","kind": "LOOKUP","alias": "BUYER_ACCOUNT","join": {"type": "inner","primary_key": ["BUYER_ACCOUNT.ACCOUNT_ID"],"foreign_key": ["KYLIN_SALES.BUYER_ID"]}},{"table": "DEFAULT.KYLIN_ACCOUNT","kind": "LOOKUP","alias": "SELLER_ACCOUNT","join": {"type": "inner","primary_key": ["SELLER_ACCOUNT.ACCOUNT_ID"],"foreign_key": ["KYLIN_SALES.SELLER_ID"]}},{"table": "DEFAULT.KYLIN_COUNTRY","kind": "LOOKUP","alias": "BUYER_COUNTRY","join": {"type": "inner","primary_key": ["BUYER_COUNTRY.COUNTRY"],"foreign_key": ["BUYER_ACCOUNT.ACCOUNT_COUNTRY"]}},{"table": "DEFAULT.KYLIN_COUNTRY","kind": "LOOKUP","alias": "SELLER_COUNTRY","join": {"type": "inner","primary_key": ["SELLER_COUNTRY.COUNTRY"],"foreign_key": ["SELLER_ACCOUNT.ACCOUNT_COUNTRY"]}}],"dimensions": [{"table": "KYLIN_SALES","columns": ["TRANS_ID","SELLER_ID","BUYER_ID","PART_DT","LEAF_CATEG_ID","LSTG_FORMAT_NAME","LSTG_SITE_ID","OPS_USER_ID","OPS_REGION"]},{"table": "KYLIN_CAL_DT","columns": ["CAL_DT","WEEK_BEG_DT","MONTH_BEG_DT","YEAR_BEG_DT"]},{"table": "KYLIN_CATEGORY_GROUPINGS","columns": ["USER_DEFINED_FIELD1","USER_DEFINED_FIELD3","META_CATEG_NAME","CATEG_LVL2_NAME","CATEG_LVL3_NAME","LEAF_CATEG_ID","SITE_ID"]},{"table": "BUYER_ACCOUNT","columns": ["ACCOUNT_ID","ACCOUNT_BUYER_LEVEL","ACCOUNT_SELLER_LEVEL","ACCOUNT_COUNTRY","ACCOUNT_CONTACT"]},{"table": "SELLER_ACCOUNT","columns": ["ACCOUNT_ID","ACCOUNT_BUYER_LEVEL","ACCOUNT_SELLER_LEVEL","ACCOUNT_COUNTRY","ACCOUNT_CONTACT"]},{"table": "BUYER_COUNTRY","columns": ["COUNTRY","NAME"]},{"table": "SELLER_COUNTRY","columns": ["COUNTRY","NAME"]}],"metrics": ["KYLIN_SALES.PRICE","KYLIN_SALES.ITEM_COUNT"],"filter_condition": "","partition_desc": {"partition_date_column": "KYLIN_SALES.PART_DT","partition_time_column": null,"partition_date_start": 1325376000000,"partition_date_format": "yyyy-MM-dd","partition_time_format": "HH:mm:ss","partition_type": "APPEND","partition_condition_builder": "org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder"},"capacity": "MEDIUM"}
必填
modelName
string
示例:Tmodel
必填
project
string
示例:Test3
必填

响应参数

参数名
类型
描述
必填
uuid
string
示例:6fbce00c-2f13-89d7-3923-b414759228ee
必填
modelName
string
示例:Tmodel
必填
modelDescData
string
示例:{"uuid": "0928468a-9fab-4185-9a14-6f2e7c74823f","last_modified": 0,"version": "3.0.0.20500","name": "Tmodel","owner": null,"is_draft": false,"description": "","fact_table": "DEFAULT.KYLIN_SALES","lookups": [{"table": "DEFAULT.KYLIN_CAL_DT","kind": "LOOKUP","alias": "KYLIN_CAL_DT","join": {"type": "inner","primary_key": ["KYLIN_CAL_DT.CAL_DT"],"foreign_key": ["KYLIN_SALES.PART_DT"]}},{"table...
必填
successful
boolean
示例:true
必填
message
object
示例:null
必填
project
string
示例:Test3
必填
ccInCheck
object
示例:null
必填
seekingExprAdvice
boolean
示例:false
必填

说明 / 示例

模型的创建是一个流程化的过程,分为模型信息(Model Info)、数据模型(Data Model)、维度选取(Dimensions)、度量选取(Measures)、补充设置(setting)。 其中维度和度量列选取是选择一个范围,不代表这些列将来一定用于cube的纬度或者度量,后续创建cube的时候,只能从这些列中进行选择,因此,我们可以先把所有可能用到的列都选出来。 **注意**:维度表最好不要是 Hive 视图(View)因为需要将视图进行物化,从而导致额外的时间开销;选择度量列时,度量只能来自事实表或不加载进内存的维度表。 补充设置是为模型补充分割时间列信息和过滤条件。如果此模型中的事实表记录是按时间增长的,那么可以指定一个日期/时间列作为模型的分割时间列,从而可以让Cube按此列做增量构建。 过滤(Filter)是指如果想要把一些纪律忽略掉,那么可以设置一个过滤条件