Use table's full name "KYLIN.AFFILIATE_VALID_CLICK" when its schema isn't the default?
2016-12-21 9:47 GMT+08:00 张磊 <[email protected]>: > 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. > -- Best regards, Shaofeng Shi 史少锋
