创建Cube
POST
http://192.168.88.132:7070/kylin/api/cubes
请求头
参数名
类型
描述
必填
Authorization
string
示例：Basic QURNSU46S1lMSU4=
必填
Content-Type
string
示例：application/json
必填
请求参数
参数名
类型
描述
必填
cubeDescData
string
示例：{"uuid": "0ef9b7a8-3929-4dff-b59d-2100aadc8dbf","last_modified": 0,"version": "3.0.0.20500","name": "Tcube","is_draft": false,"model_name": "Tmodel","description": "","null_string": null,"dimensions": [{"name": "TRANS_ID","table": "KYLIN_SALES","column": "TRANS_ID","derived": null},{"name": "YEAR_BEG_DT","table": "KYLIN_CAL_DT","column": null,"derived": ["YEAR_BEG_DT"]},{"name": "MONTH_BEG_DT","table": "KYLIN_CAL_DT","column": null,"derived": ["MONTH_BEG_DT"]},{"name": "WEEK_BEG_DT","table": "KYLIN_CAL_DT","column": null,"derived": ["WEEK_BEG_DT"]},{"name": "USER_DEFINED_FIELD1","table": "KYLIN_CATEGORY_GROUPINGS","column": null,"derived": ["USER_DEFINED_FIELD1"]},{"name": "USER_DEFINED_FIELD3","table": "KYLIN_CATEGORY_GROUPINGS","column": null,"derived": ["USER_DEFINED_FIELD3"]},{"name": "META_CATEG_NAME","table": "KYLIN_CATEGORY_GROUPINGS","column": "META_CATEG_NAME","derived": null},{"name": "CATEG_LVL2_NAME","table": "KYLIN_CATEGORY_GROUPINGS","column": "CATEG_LVL2_NAME","derived": null},{"name": "CATEG_LVL3_NAME","table": "KYLIN_CATEGORY_GROUPINGS","column": "CATEG_LVL3_NAME","derived": null},{"name": "LSTG_FORMAT_NAME","table": "KYLIN_SALES","column": "LSTG_FORMAT_NAME","derived": null},{"name": "SELLER_ID","table": "KYLIN_SALES","column": "SELLER_ID","derived": null},{"name": "BUYER_ID","table": "KYLIN_SALES","column": "BUYER_ID","derived": null},{"name": "ACCOUNT_BUYER_LEVEL","table": "BUYER_ACCOUNT","column": "ACCOUNT_BUYER_LEVEL","derived": null},{"name": "ACCOUNT_SELLER_LEVEL","table": "SELLER_ACCOUNT","column": "ACCOUNT_SELLER_LEVEL","derived": null},{"name": "BUYER_COUNTRY","table": "BUYER_ACCOUNT","column": "ACCOUNT_COUNTRY","derived": null},{"name": "SELLER_COUNTRY","table": "SELLER_ACCOUNT","column": "ACCOUNT_COUNTRY","derived": null},{"name": "BUYER_COUNTRY_NAME","table": "BUYER_COUNTRY","column": "NAME","derived": null},{"name": "SELLER_COUNTRY_NAME","table": "SELLER_COUNTRY","column": "NAME","derived": null},{"name": "OPS_USER_ID","table": "KYLIN_SALES","column": "OPS_USER_ID","derived": null},{"name": "OPS_REGION","table": "KYLIN_SALES","column": "OPS_REGION","derived": null}],"measures": [{"name": "GMV_SUM","function": {"expression": "SUM","parameter": {"type": "column","value": "KYLIN_SALES.PRICE"},"returntype": "decimal(19,4)"}},{"name": "BUYER_LEVEL_SUM","function": {"expression": "SUM","parameter": {"type": "column","value": "BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"},"returntype": "bigint"}},{"name": "SELLER_LEVEL_SUM","function": {"expression": "SUM","parameter": {"type": "column","value": "SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"},"returntype": "bigint"}},{"name": "TRANS_CNT","function": {"expression": "COUNT","parameter": {"type": "constant","value": "1"},"returntype": "bigint"}},{"name": "SELLER_CNT_HLL","function": {"expression": "COUNT_DISTINCT","parameter": {"type": "column","value": "KYLIN_SALES.SELLER_ID"},"returntype": "hllc(10)"}},{"name": "TOP_SELLER","function": {"expression": "TOP_N","parameter": {"type": "column","value": "KYLIN_SALES.PRICE","next_parameter": {"type": "column","value": "KYLIN_SALES.SELLER_ID"}},"returntype": "topn(100)","configuration": {"topn.encoding.KYLIN_SALES.SELLER_ID": "dict","topn.encoding_version.KYLIN_SALES.SELLER_ID": "1"}}}],"rowkey": {"rowkey_columns": [{"column": "KYLIN_SALES.BUYER_ID","encoding": "integer:4","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.SELLER_ID","encoding": "integer:4","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.TRANS_ID","encoding": "integer:4","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.PART_DT","encoding": "date","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.LEAF_CATEG_ID","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "BUYER_ACCOUNT.ACCOUNT_COUNTRY","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "SELLER_ACCOUNT.ACCOUNT_COUNTRY","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "BUYER_COUNTRY.NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "SELLER_COUNTRY.NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.LSTG_FORMAT_NAME","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.LSTG_SITE_ID","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.OPS_USER_ID","encoding": "dict","encoding_version": 1,"isShardBy": false},{"column": "KYLIN_SALES.OPS_REGION","encoding": "dict","encoding_version": 1,"isShardBy": false}]},"hbase_mapping": {"column_family": [{"name": "F1","columns": [{"qualifier": "M","measure_refs": ["GMV_SUM","BUYER_LEVEL_SUM","SELLER_LEVEL_SUM","TRANS_CNT"]}]},{"name": "F2","columns": [{"qualifier": "M","measure_refs": ["SELLER_CNT_HLL","TOP_SELLER"]}]}]},"aggregation_groups": [{"includes": ["KYLIN_SALES.PART_DT","KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME","KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME","KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME","KYLIN_SALES.LEAF_CATEG_ID","KYLIN_SALES.LSTG_FORMAT_NAME","KYLIN_SALES.LSTG_SITE_ID","KYLIN_SALES.OPS_USER_ID","KYLIN_SALES.OPS_REGION","BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL","SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL","BUYER_ACCOUNT.ACCOUNT_COUNTRY","SELLER_ACCOUNT.ACCOUNT_COUNTRY","BUYER_COUNTRY.NAME","SELLER_COUNTRY.NAME"],"select_rule": {"hierarchy_dims": [["KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME","KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME","KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME","KYLIN_SALES.LEAF_CATEG_ID"]],"mandatory_dims": ["KYLIN_SALES.PART_DT"],"joint_dims": [["BUYER_ACCOUNT.ACCOUNT_COUNTRY","BUYER_COUNTRY.NAME"],["SELLER_ACCOUNT.ACCOUNT_COUNTRY","SELLER_COUNTRY.NAME"],["BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL","SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"],["KYLIN_SALES.LSTG_FORMAT_NAME","KYLIN_SALES.LSTG_SITE_ID"],["KYLIN_SALES.OPS_USER_ID","KYLIN_SALES.OPS_REGION"]]}}],"signature": null,"notify_list": [],"status_need_notify": [],"partition_date_start": 1325376000000,"partition_date_end": 3153600000000,"auto_merge_time_ranges": [],"volatile_range": 0,"retention_range": 0,"engine_type": 2,"storage_type": 2,"override_kylin_properties": {"kylin.cube.aggrgroup.is-mandatory-only-valid": "true","kylin.engine.spark.rdd-partition-cut-mb": "500"},"cuboid_black_list": [],"parent_forward": 3,"mandatory_dimension_set_list": [],"snapshot_table_desc_list": []}
必填
cubeName
string
示例：Tcube
必填
project
string
示例：Test3
必填
响应参数
参数名
类型
描述
必填
uuid
string
示例：e5996c9a-a87a-e4f5-3e2b-80ae45ee515d
必填
cubeName
string
示例：Tcube
必填
cubeDescData
string
示例：{"uuid": "0ef9b7a8-3929-4dff-b59d-2100aadc8dbf","last_modified": 0,"version": "3.0.0.20500","name": "Tcube","is_draft": false,"model_name": "Tmodel","description": "","null_string": null,"dimensions": [{"name": "TRANS_ID","table": "KYLIN_SALES","column": "TRANS_ID","derived": null},{"name": "YEAR_BEG_DT","table": "KYLIN_CAL_DT","column": null,"derived": ["YEAR_BEG_DT"]},{"name": "MONTH_BEG_...
必填
streamingData
object
示例：null
必填
kafkaData
object
示例：null
必填
successful
boolean
示例：true
必填
message
object
示例：null
必填
project
string
示例：Test3
必填
streamingCube
object
示例：null
必填