This is still the cube description, not the data model description; From
0.7, for a cube there will be two json, one is cube, the other is data
model; You will see them when you expand the cube row;

On 3/20/15, 3:56 PM, "闫开元" <[email protected]> wrote:

>I solved new problem at last , and here is the json you want
>
>{
>  "uuid": "bb13d642-b4ad-46c4-adb6-3da3688fb81a",
>  "name": "ZSJ_KAINE",
>  "description": "",
>  "dimensions": [
>    {
>      "id": 1,
>      "name": "DEFAULT.ZSJ_FACT_YT.NY",
>      "table": "DEFAULT.ZSJ_FACT_YT",
>      "column": [
>        "NY"
>      ],
>      "derived": null,
>      "hierarchy": false
>    }
>  ],
>  "measures": [
>    {
>      "id": 1,
>      "name": "_COUNT_",
>      "function": {
>        "expression": "COUNT",
>        "parameter": {
>          "type": "constant",
>          "value": "1"
>        },
>        "returntype": "bigint"
>      },
>      "dependent_measure_ref": null
>    }
>  ],
>  "rowkey": {
>    "rowkey_columns": [
>      {
>        "column": "NY",
>        "length": 0,
>        "dictionary": "true",
>        "mandatory": false
>      }
>    ],
>    "aggregation_groups": [
>      [
>        "NY"
>      ]
>    ]
>  },
>  "signature": "pAu8eioTnc9AmtdtbTMitA==",
>  "last_modified": 1426837882936,
>  "model_name": "ZSJ_KAINE",
>  "null_string": null,
>  "hbase_mapping": {
>    "column_family": [
>      {
>        "name": "F1",
>        "columns": [
>          {
>            "qualifier": "M",
>            "measure_refs": [
>              "_COUNT_"
>            ]
>          }
>        ]
>      }
>    ]
>  },
>  "notify_list": []
>}
>
>
>2015-03-20 13:54 GMT+08:00 闫开元 <[email protected]>:
>
>>
>> I download the newest version and meet a new problem when I build a
>>cube.Could
>> you help me to solve it ?
>>
>> [http-bio-7070-exec-7]:[2015-03-20
>> 
>>13:48:15,518][DEBUG][org.apache.kylin.rest.controller.CubeController.dese
>>rializeDataModelDesc(CubeController.java:479)]
>> - Saving MODEL null
>> [http-bio-7070-exec-7]:[2015-03-20
>> 
>>13:48:15,533][ERROR][org.apache.kylin.rest.controller.BasicController.han
>>dleError(BasicController.java:52)]
>> -
>> java.lang.NullPointerException
>>         at java.io.StringReader.<init>(StringReader.java:50)
>>         at
>> 
>>com.fasterxml.jackson.core.JsonFactory.createParser(JsonFactory.java:796)
>>         at
>> 
>>com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2
>>034)
>>         at
>> org.apache.kylin.common.util.JsonUtil.readValue(JsonUtil.java:51)
>>         at
>> 
>>org.apache.kylin.rest.controller.CubeController.deserializeDataModelDesc(
>>CubeController.java:480)
>>         ...
>>
>> Error Message
>>
>> Failed to take action.
>>
>>
>> {
>>   "name": "ZSJ_KAINE",
>>   "description": "",
>>   "fact_table": "ZSJ_FACT_YT",
>>   "filter_condition": null,
>>   "notify_list": [],
>>   "cube_partition_desc": {
>>     "partition_date_column": null,
>>     "partition_date_start": null,
>>     "cube_partition_type": "APPEND"
>>   },
>>   "capacity": "MEDIUM",
>>   "cost": 50,
>>   "dimensions": [
>>     {
>>       "name": "ZSJ_FACT_YT.NY",
>>       "table": "ZSJ_FACT_YT",
>>       "column": "NY",
>>       "id": 1
>>     }
>>   ],
>>   "measures": [
>>     {
>>       "id": 1,
>>       "name": "_COUNT_",
>>       "function": {
>>         "expression": "COUNT",
>>         "returntype": "bigint",
>>         "parameter": {
>>           "type": "constant",
>>           "value": "1"
>>         }
>>       }
>>     }
>>   ],
>>   "rowkey": {
>>     "rowkey_columns": [
>>       {
>>         "column": "NY",
>>         "length": 0,
>>         "dictionary": "true",
>>         "mandatory": false
>>       }
>>     ],
>>     "aggregation_groups": [
>>       [
>>         "NY"
>>       ]
>>     ]
>>   },
>>   "hbase_mapping": {
>>     "column_family": [
>>       {
>>         "name": "f1",
>>         "columns": [
>>           {
>>             "qualifier": "m",
>>             "measure_refs": [
>>               "_COUNT_"
>>             ]
>>           }
>>         ]
>>       }
>>     ]
>>   },
>>   "project": "DG_A2",
>>   "model": {
>>     "name": "ZSJ_KAINE",
>>     "fact_table": "ZSJ_FACT_YT",
>>     "lookups": [
>>       {
>>         "table": "ZSJ_DIM_NY",
>>         "join": {
>>           "type": "inner",
>>           "primary_key": [
>>             "YEARMONTH"
>>           ],
>>           "foreign_key": [
>>             "NY"
>>           ]
>>         }
>>       }
>>     ]
>>   }
>> }
>>
>>
>>
>>
>> 2015-03-17 14:40 GMT+08:00 hongbin ma <[email protected]>:
>>
>>> can you go to cubes tab ,select your cube, open the sub tabs called
>>> "json" and send us the content?
>>>
>>> On Mon, Mar 16, 2015 at 9:34 PM, Luke Han <[email protected]> wrote:
>>>
>>>> Forward to mailing list for further support
>>>>
>>>> 在 2015年3月16日星期一 UTC-7下午4:18:07,Kaine写道:
>>>>>
>>>>> 为什么table会被as成null,多个表同时join的话就会出错
>>>>> INSERT OVERWRITE TABLE kylin_intermediate_ZSJ_19700101000000_
>>>>> 2922789940817071255_96c192af_6191_4a13_b827_02c9d5eb1a7d SELECT
>>>>> FACT_TABLE.QKDYDM
>>>>> ,FACT_TABLE.NY
>>>>> FROM DEFAULT.ZSJ_FACT_YT as FACT_TABLE
>>>>> INNER JOIN DEFAULT.ZSJ_DIM_NY as null
>>>>> ON FACT_TABLE.NY = null.YEARMONTH
>>>>> INNER JOIN DEFAULT.ZSJ_DIM_ORG as null
>>>>> ON FACT_TABLE.QKDYDM = null.YTDM
>>>>>
>>>>
>>>
>>

Reply via email to