kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: Table 'AFFILIATE_VALID_CLICK' not found. Sometimes table notfound,Why?
Date Wed, 21 Dec 2016 09:29:31 GMT
Use table's full name "KYLIN.AFFILIATE_VALID_CLICK" when its schema isn't
the default?

2016-12-21 9:47 GMT+08:00 张磊 <121762713@qq.com>:

> 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": [
>     "zhanglei@papayamobile.cn"
>   ],
>   "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";<huangzhendong90@gmail.com>;
> Date:  Tue, Dec 20, 2016 06:49 PM
> To:  "dev"<dev@kylin.apache.org>;
>
> 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 史少锋

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message