You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 移动苏州研发中心-陈雷雷 <77...@qq.com> on 2016/06/24 12:43:18 UTC
EXTENDED_COLUMN-build error
hi all:
I added a extended_column cell_name and when I build the cube it failed. I don't know why. The diagnosis zip is in the attachement.
Re: EXTENDED_COLUMN-build error
Posted by hongbin ma <ma...@apache.org>.
besides the measure part, you need SITE_EXTENDED_1 and SITE_EXTENDED_2
added in "hbase_mapping" as well
On Fri, Jul 1, 2016 at 1:59 PM, hongbin ma <ma...@apache.org> wrote:
> Unfortunately, there's no webUI for extended column yet. we're still
> working on it.
>
> You can edit the cube desc json directly, refer to
> KYLIN_HOME/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
> as an example, we have two extended column measure there: SITE_EXTENDED_1
> and SITE_EXTENDED_2
>
> after you manually edit the cube desc json, you also need to erase the
> line "signature", so that a new cube desc signature can be automatically
> generated.
>
> On Tue, Jun 28, 2016 at 12:30 AM, Yiming Liu <li...@gmail.com>
> wrote:
>
>> Get it. Thanks Dong & Leilei.
>>
>> 2016-06-27 22:14 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>>
>> > Hi YiMing
>> > 1,How did you add the extended column, through the GUI or REST API?
>> > I added the extended column through the GUI with kylin version
>> > 1.5.2.1. When you defined a cube, it has two actions on the cube. The
>> > second is to edit the json of the cube. In the json, it have measures
>> which
>> > you defined. All you have to do is to add json segment as fllows. The
>> value
>> > (PROVINCE_ID) in parameter is the PK in fact table and the value
>> > (PROVINCE_NAME) in next_parameter is the FK in fact table.
>> > {
>> > "name": "3",
>> > "function": {
>> > "expression": "EXTENDED_COLUMN",
>> > "parameter": {
>> > "type": "column",
>> > "value": "PROVINCE_ID",
>> > "next_parameter": {
>> > "type": "column",
>> > "value": "PROVINCE_NAME",
>> > "next_parameter": null
>> > }
>> > },
>> > "returntype": "extendedcolumn(100)"
>> > },
>> > "dependent_measure_ref": null
>> > }
>> >
>> > 2,Why the wrong json was introduced?
>> > First time, I did not add the next_parameter like this. You need
>> > tell kylin which is the PK and which is the FK.
>> > {
>> > "name": "3",
>> > "function": {
>> > "expression": "EXTENDED_COLUMN",
>> > "parameter": {
>> > "type": "column",
>> > "value": "PROVINCE_ID",
>> > "next_parameter": null
>> > },
>> > "returntype": null
>> > },
>> > "dependent_measure_ref": null
>> > }
>> >
>> > you can see details in KYLIN-1313 (
>> > https://issues.apache.org/jira/browse/KYLIN-1313).
>> > ------------------ 原始邮件 ------------------
>> > *发件人:* "Yiming Liu";<li...@gmail.com>;
>> > *发送时间:* 2016年6月27日(星期一) 晚上9:46
>> > *收件人:* "移动苏州研发中心-陈雷雷"<77...@qq.com>;
>> > *抄送:* "dev"<de...@kylin.apache.org>;
>> > *主题:* Re: EXTENDED_COLUMN-build error
>> >
>> > Hi Leilei,
>> >
>> > Could you explain a little more about the wrong json? How did you add
>> the
>> > extended column, through the GUI or REST API? Why the wrong json was
>> > introduced?
>> >
>> >
>> > 2016-06-27 17:15 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>> >
>> >> problem solved.
>> >>
>> >>
>> >> the json is wrong.
>> >>
>> >>
>> >> the right json is like this :
>> >> {
>> >> "name": "3",
>> >> "function": {
>> >> "expression": "EXTENDED_COLUMN",
>> >> "parameter": {
>> >> "type": "column",
>> >> "value": "PROVINCE_ID",
>> >> "next_parameter": {
>> >> "type": "column",
>> >> "value": "PROVINCE_NAME",
>> >> "next_parameter": null
>> >> }
>> >> },
>> >> "returntype": "extendedcolumn(100)"
>> >> },
>> >> "dependent_measure_ref": null
>> >> }
>> >>
>> >>
>> >>
>> >> ------------------ 原始邮件 ------------------
>> >> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
>> >> 发送时间: 2016年6月25日(星期六) 晚上8:27
>> >> 收件人: "dev"<de...@kylin.apache.org>;
>> >>
>> >> 主题: Re: EXTENDED_COLUMN-build error
>> >>
>> >>
>> >>
>> >> hi leilei, no attachement received, seems Apache mailing list doesn't
>> >> support it; Could you please try some way else or send it to my
>> mailbox?
>> >> Thanks;
>> >>
>> >> 2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>> >>
>> >> > hi all:
>> >> >
>> >> > I added a extended_column cell_name and when I build the cube it
>> >> > failed. I don't know why. The diagnosis zip is in the attachement.
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Best regards,
>> >>
>> >> Shaofeng Shi
>> >>
>> >
>> >
>> >
>> > --
>> > With Warm regards
>> >
>> > Yiming Liu (刘一鸣)
>> >
>>
>>
>>
>> --
>> With Warm regards
>>
>> Yiming Liu (刘一鸣)
>>
>
>
>
> --
> Regards,
>
> *Bin Mahone | 马洪宾*
>
--
Regards,
*Bin Mahone | 马洪宾*
Re: EXTENDED_COLUMN-build error
Posted by hongbin ma <ma...@apache.org>.
Unfortunately, there's no webUI for extended column yet. we're still
working on it.
You can edit the cube desc json directly, refer to
KYLIN_HOME/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
as an example, we have two extended column measure there: SITE_EXTENDED_1
and SITE_EXTENDED_2
after you manually edit the cube desc json, you also need to erase the line
"signature", so that a new cube desc signature can be automatically
generated.
On Tue, Jun 28, 2016 at 12:30 AM, Yiming Liu <li...@gmail.com>
wrote:
> Get it. Thanks Dong & Leilei.
>
> 2016-06-27 22:14 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>
> > Hi YiMing
> > 1,How did you add the extended column, through the GUI or REST API?
> > I added the extended column through the GUI with kylin version
> > 1.5.2.1. When you defined a cube, it has two actions on the cube. The
> > second is to edit the json of the cube. In the json, it have measures
> which
> > you defined. All you have to do is to add json segment as fllows. The
> value
> > (PROVINCE_ID) in parameter is the PK in fact table and the value
> > (PROVINCE_NAME) in next_parameter is the FK in fact table.
> > {
> > "name": "3",
> > "function": {
> > "expression": "EXTENDED_COLUMN",
> > "parameter": {
> > "type": "column",
> > "value": "PROVINCE_ID",
> > "next_parameter": {
> > "type": "column",
> > "value": "PROVINCE_NAME",
> > "next_parameter": null
> > }
> > },
> > "returntype": "extendedcolumn(100)"
> > },
> > "dependent_measure_ref": null
> > }
> >
> > 2,Why the wrong json was introduced?
> > First time, I did not add the next_parameter like this. You need
> > tell kylin which is the PK and which is the FK.
> > {
> > "name": "3",
> > "function": {
> > "expression": "EXTENDED_COLUMN",
> > "parameter": {
> > "type": "column",
> > "value": "PROVINCE_ID",
> > "next_parameter": null
> > },
> > "returntype": null
> > },
> > "dependent_measure_ref": null
> > }
> >
> > you can see details in KYLIN-1313 (
> > https://issues.apache.org/jira/browse/KYLIN-1313).
> > ------------------ 原始邮件 ------------------
> > *发件人:* "Yiming Liu";<li...@gmail.com>;
> > *发送时间:* 2016年6月27日(星期一) 晚上9:46
> > *收件人:* "移动苏州研发中心-陈雷雷"<77...@qq.com>;
> > *抄送:* "dev"<de...@kylin.apache.org>;
> > *主题:* Re: EXTENDED_COLUMN-build error
> >
> > Hi Leilei,
> >
> > Could you explain a little more about the wrong json? How did you add the
> > extended column, through the GUI or REST API? Why the wrong json was
> > introduced?
> >
> >
> > 2016-06-27 17:15 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> >
> >> problem solved.
> >>
> >>
> >> the json is wrong.
> >>
> >>
> >> the right json is like this :
> >> {
> >> "name": "3",
> >> "function": {
> >> "expression": "EXTENDED_COLUMN",
> >> "parameter": {
> >> "type": "column",
> >> "value": "PROVINCE_ID",
> >> "next_parameter": {
> >> "type": "column",
> >> "value": "PROVINCE_NAME",
> >> "next_parameter": null
> >> }
> >> },
> >> "returntype": "extendedcolumn(100)"
> >> },
> >> "dependent_measure_ref": null
> >> }
> >>
> >>
> >>
> >> ------------------ 原始邮件 ------------------
> >> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> >> 发送时间: 2016年6月25日(星期六) 晚上8:27
> >> 收件人: "dev"<de...@kylin.apache.org>;
> >>
> >> 主题: Re: EXTENDED_COLUMN-build error
> >>
> >>
> >>
> >> hi leilei, no attachement received, seems Apache mailing list doesn't
> >> support it; Could you please try some way else or send it to my mailbox?
> >> Thanks;
> >>
> >> 2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> >>
> >> > hi all:
> >> >
> >> > I added a extended_column cell_name and when I build the cube it
> >> > failed. I don't know why. The diagnosis zip is in the attachement.
> >> >
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Best regards,
> >>
> >> Shaofeng Shi
> >>
> >
> >
> >
> > --
> > With Warm regards
> >
> > Yiming Liu (刘一鸣)
> >
>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>
--
Regards,
*Bin Mahone | 马洪宾*
Re: EXTENDED_COLUMN-build error
Posted by Yiming Liu <li...@gmail.com>.
Get it. Thanks Dong & Leilei.
2016-06-27 22:14 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> Hi YiMing
> 1,How did you add the extended column, through the GUI or REST API?
> I added the extended column through the GUI with kylin version
> 1.5.2.1. When you defined a cube, it has two actions on the cube. The
> second is to edit the json of the cube. In the json, it have measures which
> you defined. All you have to do is to add json segment as fllows. The value
> (PROVINCE_ID) in parameter is the PK in fact table and the value
> (PROVINCE_NAME) in next_parameter is the FK in fact table.
> {
> "name": "3",
> "function": {
> "expression": "EXTENDED_COLUMN",
> "parameter": {
> "type": "column",
> "value": "PROVINCE_ID",
> "next_parameter": {
> "type": "column",
> "value": "PROVINCE_NAME",
> "next_parameter": null
> }
> },
> "returntype": "extendedcolumn(100)"
> },
> "dependent_measure_ref": null
> }
>
> 2,Why the wrong json was introduced?
> First time, I did not add the next_parameter like this. You need
> tell kylin which is the PK and which is the FK.
> {
> "name": "3",
> "function": {
> "expression": "EXTENDED_COLUMN",
> "parameter": {
> "type": "column",
> "value": "PROVINCE_ID",
> "next_parameter": null
> },
> "returntype": null
> },
> "dependent_measure_ref": null
> }
>
> you can see details in KYLIN-1313 (
> https://issues.apache.org/jira/browse/KYLIN-1313).
> ------------------ 原始邮件 ------------------
> *发件人:* "Yiming Liu";<li...@gmail.com>;
> *发送时间:* 2016年6月27日(星期一) 晚上9:46
> *收件人:* "移动苏州研发中心-陈雷雷"<77...@qq.com>;
> *抄送:* "dev"<de...@kylin.apache.org>;
> *主题:* Re: EXTENDED_COLUMN-build error
>
> Hi Leilei,
>
> Could you explain a little more about the wrong json? How did you add the
> extended column, through the GUI or REST API? Why the wrong json was
> introduced?
>
>
> 2016-06-27 17:15 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>
>> problem solved.
>>
>>
>> the json is wrong.
>>
>>
>> the right json is like this :
>> {
>> "name": "3",
>> "function": {
>> "expression": "EXTENDED_COLUMN",
>> "parameter": {
>> "type": "column",
>> "value": "PROVINCE_ID",
>> "next_parameter": {
>> "type": "column",
>> "value": "PROVINCE_NAME",
>> "next_parameter": null
>> }
>> },
>> "returntype": "extendedcolumn(100)"
>> },
>> "dependent_measure_ref": null
>> }
>>
>>
>>
>> ------------------ 原始邮件 ------------------
>> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
>> 发送时间: 2016年6月25日(星期六) 晚上8:27
>> 收件人: "dev"<de...@kylin.apache.org>;
>>
>> 主题: Re: EXTENDED_COLUMN-build error
>>
>>
>>
>> hi leilei, no attachement received, seems Apache mailing list doesn't
>> support it; Could you please try some way else or send it to my mailbox?
>> Thanks;
>>
>> 2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>>
>> > hi all:
>> >
>> > I added a extended_column cell_name and when I build the cube it
>> > failed. I don't know why. The diagnosis zip is in the attachement.
>> >
>> >
>> >
>>
>>
>>
>> --
>> Best regards,
>>
>> Shaofeng Shi
>>
>
>
>
> --
> With Warm regards
>
> Yiming Liu (刘一鸣)
>
--
With Warm regards
Yiming Liu (刘一鸣)
回复： EXTENDED_COLUMN-build error
Posted by 移动苏州研发中心-陈雷雷 <77...@qq.com>.
Hi YiMing
1,How did you add the extended column, through the GUI or REST API?
I added the extended column through the GUI with kylin version 1.5.2.1. When you defined a cube, it has two actions on the cube. The second is to edit the json of the cube. In the json, it have measures which you defined. All you have to do is to add json segment as fllows. The value (PROVINCE_ID) in parameter is the PK in fact table and the value (PROVINCE_NAME) in next_parameter is the FK in fact table.
{
"name": "3",
"function": {
"expression": "EXTENDED_COLUMN",
"parameter": {
"type": "column",
"value": "PROVINCE_ID",
"next_parameter": {
"type": "column",
"value": "PROVINCE_NAME",
"next_parameter": null
}
},
"returntype": "extendedcolumn(100)"
},
"dependent_measure_ref": null
}
2,Why the wrong json was introduced?
First time, I did not add the next_parameter like this. You need tell kylin which is the PK and which is the FK.
{
"name": "3",
"function": {
"expression": "EXTENDED_COLUMN",
"parameter": {
"type": "column",
"value": "PROVINCE_ID",
"next_parameter": null
},
"returntype": null
},
"dependent_measure_ref": null
}
you can see details in KYLIN-1313 (https://issues.apache.org/jira/browse/KYLIN-1313).
------------------ 原始邮件 ------------------
发件人: "Yiming Liu";<li...@gmail.com>;
发送时间: 2016年6月27日(星期一) 晚上9:46
收件人: "移动苏州研发中心-陈雷雷"<77...@qq.com>;
抄送: "dev"<de...@kylin.apache.org>;
主题: Re: EXTENDED_COLUMN-build error
Hi Leilei,
Could you explain a little more about the wrong json? How did you add the extended column, through the GUI or REST API? Why the wrong json was introduced?
2016-06-27 17:15 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
problem solved.
the json is wrong.
the right json is like this :
{
"name": "3",
"function": {
"expression": "EXTENDED_COLUMN",
"parameter": {
"type": "column",
"value": "PROVINCE_ID",
"next_parameter": {
"type": "column",
"value": "PROVINCE_NAME",
"next_parameter": null
}
},
"returntype": "extendedcolumn(100)"
},
"dependent_measure_ref": null
}
------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi";<sh...@apache.org>;
发送时间: 2016年6月25日(星期六) 晚上8:27
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: EXTENDED_COLUMN-build error
hi leilei, no attachement received, seems Apache mailing list doesn't
support it; Could you please try some way else or send it to my mailbox?
Thanks;
2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> hi all:
>
> I added a extended_column cell_name and when I build the cube it
> failed. I don't know why. The diagnosis zip is in the attachement.
>
>
>
--
Best regards,
Shaofeng Shi
--
With Warm regards
Yiming Liu (刘一鸣)
Re: EXTENDED_COLUMN-build error
Posted by Yiming Liu <li...@gmail.com>.
Hi Leilei,
Could you explain a little more about the wrong json? How did you add the
extended column, through the GUI or REST API? Why the wrong json was
introduced?
2016-06-27 17:15 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> problem solved.
>
>
> the json is wrong.
>
>
> the right json is like this :
> {
> "name": "3",
> "function": {
> "expression": "EXTENDED_COLUMN",
> "parameter": {
> "type": "column",
> "value": "PROVINCE_ID",
> "next_parameter": {
> "type": "column",
> "value": "PROVINCE_NAME",
> "next_parameter": null
> }
> },
> "returntype": "extendedcolumn(100)"
> },
> "dependent_measure_ref": null
> }
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> 发送时间: 2016年6月25日(星期六) 晚上8:27
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: EXTENDED_COLUMN-build error
>
>
>
> hi leilei, no attachement received, seems Apache mailing list doesn't
> support it; Could you please try some way else or send it to my mailbox?
> Thanks;
>
> 2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
>
> > hi all:
> >
> > I added a extended_column cell_name and when I build the cube it
> > failed. I don't know why. The diagnosis zip is in the attachement.
> >
> >
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
--
With Warm regards
Yiming Liu (刘一鸣)
回复： EXTENDED_COLUMN-build error
Posted by 移动苏州研发中心-陈雷雷 <77...@qq.com>.
problem solved.
the json is wrong.
the right json is like this :
{
"name": "3",
"function": {
"expression": "EXTENDED_COLUMN",
"parameter": {
"type": "column",
"value": "PROVINCE_ID",
"next_parameter": {
"type": "column",
"value": "PROVINCE_NAME",
"next_parameter": null
}
},
"returntype": "extendedcolumn(100)"
},
"dependent_measure_ref": null
}
------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi";<sh...@apache.org>;
发送时间: 2016年6月25日(星期六) 晚上8:27
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: EXTENDED_COLUMN-build error
hi leilei, no attachement received, seems Apache mailing list doesn't
support it; Could you please try some way else or send it to my mailbox?
Thanks;
2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> hi all:
>
> I added a extended_column cell_name and when I build the cube it
> failed. I don't know why. The diagnosis zip is in the attachement.
>
>
>
--
Best regards,
Shaofeng Shi
Re: EXTENDED_COLUMN-build error
Posted by ShaoFeng Shi <sh...@apache.org>.
hi leilei, no attachement received, seems Apache mailing list doesn't
support it; Could you please try some way else or send it to my mailbox?
Thanks;
2016-06-24 20:43 GMT+08:00 移动苏州研发中心-陈雷雷 <77...@qq.com>:
> hi all:
>
> I added a extended_column cell_name and when I build the cube it
> failed. I don't know why. The diagnosis zip is in the attachement.
>
>
>
--
Best regards,
Shaofeng Shi