I merge all segments of this cube, it is not ok. Then i refresh this
cube(rebuild), the query is ok. I do not konw why.
The info of model and cube is blow:
The model info:
{
"uuid": "0cecfa23-d4fc-485b-a271-ae2d3aee4668",
"last_modified": 1479707363914,
"version": "1.6.0",
"name": "affiliate_valid_click_report_model",
"owner": "ADMIN",
"description": "",
"fact_table": "KYLIN.AFFILIATE_VALID_CLICK",
"lookups": [],
"dimensions": [
{
"table": "KYLIN.AFFILIATE_VALID_CLICK",
"columns": [
"AFFILIATE_ID",
"ADVERTISER_ID",
"OFFER_ID",
"AFF_AM_ID",
"ADV_AM_ID",
"BROWSER",
"COUNTRY",
"SOURCE",
"EVENT_TYPE",
"PAYOUT_TYPE",
"REVENUE_TYPE",
"MAIN_OFFER_ID",
"DT"
]
}
],
"metrics": [
"COUNTER",
"PAYOUT_POINTS",
"REVENUE_POINTS"
],
"filter_condition": "",
"partition_desc": {
"partition_date_column": "KYLIN.AFFILIATE_VALID_CLICK.DT",
"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$DefaultPartitionConditionBuilder"
},
"capacity": "MEDIUM"
}
The cube info:
{
"uuid": "f69a1e5e-4943-4e33-b6a9-4c3524bb1ce1",
"last_modified": 1479707636539,
"version": "1.6.0",
"name": "affiliate_valid_click_report_advertiserid_cube",
"model_name": "affiliate_valid_click_report_model",
"description": "",
"null_string": null,
"dimensions": [
{
"name": "KYLIN.AFFILIATE_VALID_CLICK.ADVERTISER_ID",
"table": "KYLIN.AFFILIATE_VALID_CLICK",
"column": "ADVERTISER_ID",
"derived": null
},
{
"name": "KYLIN.AFFILIATE_VALID_CLICK.DT",
"table": "KYLIN.AFFILIATE_VALID_CLICK",
"column": "DT",
"derived": null
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
},
{
"name": "SUM_COUNTER",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "COUNTER",
"next_parameter": null
},
"returntype": "bigint"
},
"dependent_measure_ref": null
}
],
"dictionaries": [],
"rowkey": {
"rowkey_columns": [
{
"column": "DT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "ADVERTISER_ID",
"encoding": "dict",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"SUM_COUNTER"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"DT",
"ADVERTISER_ID"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [
"DT",
"ADVERTISER_ID"
],
"joint_dims": []
}
}
],
"signature": "CkMrvYSgS5TdFuOXY0eb7w==",
"notify_list": [
"[email protected]"
],
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"partition_date_start": 1475280000000,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {}
}
------------------ Original ------------------
From: "Luke_Selina";<[email protected]>;
Date: Tue, Dec 20, 2016 06:49 PM
To: "dev"<[email protected]>;
Subject: Re: Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table
notfound,Why?
The error is so obviously, your sql can't realize your table
'AFFILIATE_VALID_CLICK', so you may try you fix it by the following steps
1. make sure table name is true
2. try figure out your cube built with this table
If all these are right , paste your model, cube info here.
--
View this message in context:
http://apache-kylin.74782.x6.nabble.com/Failed-with-Build-Cube-in-18-step-tp6700p6707.html
Sent from the Apache Kylin mailing list archive at Nabble.com.
