Skip to content

Instantly share code, notes, and snippets.

@shaipraj
Created February 8, 2017 06:28
Show Gist options
  • Save shaipraj/fc930e8e39be82a23d910d6388439776 to your computer and use it in GitHub Desktop.
Save shaipraj/fc930e8e39be82a23d910d6388439776 to your computer and use it in GitHub Desktop.
{
"uuid": "e2c424fc-a554-4939-8f30-c319660e67c0",
"last_modified": 1486473243781,
"version": "1.6.0",
"name": "CUBE_TPC_H_3",
"model_name": "model_CUBE_TPC_H_3",
"description": "",
"null_string": [
"null"
],
"dimensions": [
{
"name": "SUPPLIER",
"table": "IW_CUBE_TPCH3.SUPPLIER",
"column": null,
"derived": [
"SUPPKEY",
"NAME",
"ADDRESS",
"NATIONKEY",
"PHONE",
"ACCTBAL",
"DERIVED_ATTR_1"
]
},
{
"name": "ORDERS",
"table": "IW_CUBE_TPCH3.ORDERS",
"column": null,
"derived": [
"ORDERKEY",
"CUSTKEY",
"ORDERSTATUS",
"TOTALPRICE",
"ORDERDATE",
"ORDERPRIORITY",
"CLERK",
"SHIPPRIORITY",
"COMMENT"
]
},
{
"name": "PART",
"table": "IW_CUBE_TPCH3.PART",
"column": null,
"derived": [
"PARTKEY",
"NAME",
"MFGR",
"BRAND",
"TYPE",
"SIZE",
"CONTAINER",
"RETAILPRICE",
"DERIVED_ATTR_1"
]
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_MAX_LINENUMBER",
"function": {
"expression": "MAX",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_SUM_LINENUMBER",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_LINENUMBER_PARTKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": {
"type": "column",
"value": "PARTKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_LINENUMBER_SUPPKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": {
"type": "column",
"value": "SUPPKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_LINENUMBER_ORDERKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": {
"type": "column",
"value": "ORDERKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_MIN_LINENUMBER",
"function": {
"expression": "MIN",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_LINENUMBER",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_LINNUMBER",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "LINENUMBER",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_QUANTITY",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_DISCOUNT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_MIN_QUANTITY",
"function": {
"expression": "MIN",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_SUM_QUANTITY",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_MAX_QUANTITY",
"function": {
"expression": "MAX",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_QUANTITY_PARTKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": {
"type": "column",
"value": "PARTKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_QUANTITY_SUPPKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": {
"type": "column",
"value": "SUPPKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_QUANTITY_ORDERKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "QUANTITY",
"next_parameter": {
"type": "column",
"value": "ORDERKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_MIN_EXTENDED_PRICE",
"function": {
"expression": "MIN",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_EXTENDED_PRICE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_EXTENDED_PRICE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_SUM_EXTENDED_PRICE",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_MAX_EXTENDED_PRICE",
"function": {
"expression": "MAX",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_EXTENDED_PRICE_PARTKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": {
"type": "column",
"value": "PARTKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_EXTENDED_PRICE_SUPPKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": {
"type": "column",
"value": "SUPPKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_EXTENDED_PRICE_ORDERKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "EXTENDED_PRICE",
"next_parameter": {
"type": "column",
"value": "ORDERKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_MAX_DISCOUNT",
"function": {
"expression": "MAX",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_DISCOUNT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_MIN_DISCOUNT",
"function": {
"expression": "MIN",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_DISCOUNT_PARTKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": {
"type": "column",
"value": "PARTKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_DISCOUNT_SUPPKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": {
"type": "column",
"value": "SUPPKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_DISCOUNT_ORDERKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": {
"type": "column",
"value": "ORDERKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_SUM_DISCOUNT",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "DISCOUNT",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_TAX",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_MIN_TAX",
"function": {
"expression": "MIN",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_TAX_PARTKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": {
"type": "column",
"value": "PARTKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_TAX_SUPPKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": {
"type": "column",
"value": "SUPPKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_TOPK_TAX_ORDERKEY",
"function": {
"expression": "TOP_N",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": {
"type": "column",
"value": "ORDERKEY",
"next_parameter": null
}
},
"returntype": "topn(100)"
},
"dependent_measure_ref": null
},
{
"name": "_MAX_TAX",
"function": {
"expression": "MAX",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_TAX",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_SUM_TAX",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "TAX",
"next_parameter": null
},
"returntype": "decimal"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_RETURN_FLAG",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "RETURNFLAG",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_RETURN_FLAG",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "RETURNFLAG",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_LINE_STATUS",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "LINESTATUS",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_LINE_STATUS",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "LINESTATUS",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_SHIP_DATE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPDATE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_SHIP_DATE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPDATE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_SHIP_INSTRUCT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPINSTRUCT",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_SHIP_INSTRUCT",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPINSTRUCT",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_APPROX_DISTINCT_COUNT_SHIP_MODE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPMODE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
},
{
"name": "_EXACT_DISTINCT_COUNT_SHIP_MODE",
"function": {
"expression": "COUNT_DISTINCT",
"parameter": {
"type": "column",
"value": "SHIPMODE",
"next_parameter": null
},
"returntype": "hllc(10)"
},
"dependent_measure_ref": null
}
],
"rowkey": {
"rowkey_columns": [
{
"column": "SUPPKEY",
"encoding": "fixed_length:8",
"isShardBy": false
},
{
"column": "ORDERKEY",
"encoding": "fixed_length:8",
"isShardBy": false
},
{
"column": "PARTKEY",
"encoding": "fixed_length:8",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"_MAX_LINENUMBER",
"_SUM_LINENUMBER",
"_TOPK_LINENUMBER_PARTKEY",
"_TOPK_LINENUMBER_SUPPKEY",
"_TOPK_LINENUMBER_ORDERKEY",
"_MIN_LINENUMBER",
"_EXACT_DISTINCT_COUNT_LINENUMBER",
"_APPROX_DISTINCT_COUNT_LINNUMBER",
"_EXACT_DISTINCT_COUNT_QUANTITY",
"_APPROX_DISTINCT_COUNT_DISCOUNT",
"_MIN_QUANTITY",
"_SUM_QUANTITY",
"_MAX_QUANTITY",
"_TOPK_QUANTITY_PARTKEY",
"_TOPK_QUANTITY_SUPPKEY",
"_TOPK_QUANTITY_ORDERKEY",
"_MIN_EXTENDED_PRICE",
"_APPROX_DISTINCT_COUNT_EXTENDED_PRICE",
"_EXACT_DISTINCT_COUNT_EXTENDED_PRICE",
"_SUM_EXTENDED_PRICE",
"_MAX_EXTENDED_PRICE",
"_TOPK_EXTENDED_PRICE_PARTKEY",
"_TOPK_EXTENDED_PRICE_SUPPKEY",
"_TOPK_EXTENDED_PRICE_ORDERKEY",
"_MAX_DISCOUNT",
"_EXACT_DISTINCT_COUNT_DISCOUNT",
"_MIN_DISCOUNT",
"_TOPK_DISCOUNT_PARTKEY",
"_TOPK_DISCOUNT_SUPPKEY",
"_TOPK_DISCOUNT_ORDERKEY",
"_SUM_DISCOUNT",
"_EXACT_DISTINCT_COUNT_TAX",
"_MIN_TAX",
"_TOPK_TAX_PARTKEY",
"_TOPK_TAX_SUPPKEY",
"_TOPK_TAX_ORDERKEY",
"_MAX_TAX",
"_APPROX_DISTINCT_COUNT_TAX",
"_SUM_TAX",
"_APPROX_DISTINCT_COUNT_RETURN_FLAG",
"_EXACT_DISTINCT_COUNT_RETURN_FLAG",
"_EXACT_DISTINCT_COUNT_LINE_STATUS",
"_APPROX_DISTINCT_COUNT_LINE_STATUS",
"_APPROX_DISTINCT_COUNT_SHIP_DATE",
"_EXACT_DISTINCT_COUNT_SHIP_DATE",
"_EXACT_DISTINCT_COUNT_SHIP_INSTRUCT",
"_APPROX_DISTINCT_COUNT_SHIP_INSTRUCT",
"_APPROX_DISTINCT_COUNT_SHIP_MODE",
"_EXACT_DISTINCT_COUNT_SHIP_MODE"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"SUPPKEY",
"PARTKEY"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [],
"joint_dims": []
}
}
],
"signature": "6DHw4675mVrSNZbBnMB0nQ==",
"notify_list": [],
"status_need_notify": [],
"partition_date_start": 0,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment