You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 高扬02 <ga...@bianfeng.com> on 2019/04/26 07:50:11 UTC
转发: How to use EXTENDED_COLUMN？
Hello,
By the way, in the situation "select host_column , extended_column where host_column..", which is more efficient, extended_column or joint_dimensions?
Thanks a lot.
Best regards.
发件人: 高扬02 [mailto:gaoyang02@bianfeng.com]
发送时间: 2019年4月26日 15:19
收件人: user@kylin.apache.org
主题: How to use EXTENDED_COLUMN？
Hello,
Kylin 2.6.0.
As the picture , I set dayplus2 as EXTENDED_COLUMN , and data_day is the dimension and host column.
But how to query with them? I queryed dayplus2 with filtered data_day , but it has no result.
Please show me how to query the extended_column , thanks a lot.
Best regards.
[cid:image001.png@01D4FC42.482A4D80]
[cid:image002.png@01D4FC42.F1E19180]
答复: How to use EXTENDED_COLUMN？
Posted by 高扬02 <ga...@bianfeng.com>.
Hi Shaofeng,
Sorry for not replying to this email in time. I searched for " kylin extended column". Some articles introduced the extended column but did not use it , But then I've tried out the usage for the query of the extended column myself. I have also searched the several articles you mentioned, which can serve as a reference for my case. Thank you very much.
Best regards,
GaoYang
发件人: ShaoFeng Shi [mailto:shaofengshi@apache.org]
发送时间: 2019年4月30日 10:24
收件人: user <us...@kylin.apache.org>
主题: Re: How to use EXTENDED_COLUMN？
Hi Gaoyang,
If you search "Apache Kylin" + "Extended column", there are a couple of related articles, like:
http://apache-kylin.74782.x6.nabble.com/Consulting-quot-EXTENDED-COLUMN-quot-td6463.html
https://blog.bcmeng.com/post/kylin-dimension.html#extended-column
https://www.cnblogs.com/double-kill/p/8371595.html
Regarding "which is more efficient, extended_column or joint_dimensions", I think "extended_column" is better because with it the HBase rowkey will be shorter; while "joint_dimension" will
add both of the columns into the rowkey, which will impact HBase scan performance.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org<ma...@apache.org>
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org<ma...@kylin.apache.org>
Join Kylin dev mail group: dev-subscribe@kylin.apache.org<ma...@kylin.apache.org>
高扬02 <ga...@bianfeng.com>> 于2019年4月26日周五 下午3:50写道：
Hello,
By the way, in the situation "select host_column , extended_column where host_column..", which is more efficient, extended_column or joint_dimensions?
Thanks a lot.
Best regards.
发件人: 高扬02 [mailto:gaoyang02@bianfeng.com<ma...@bianfeng.com>]
发送时间: 2019年4月26日 15:19
收件人: user@kylin.apache.org<ma...@kylin.apache.org>
主题: How to use EXTENDED_COLUMN？
Hello,
Kylin 2.6.0.
As the picture , I set dayplus2 as EXTENDED_COLUMN , and data_day is the dimension and host column.
But how to query with them? I queryed dayplus2 with filtered data_day , but it has no result.
Please show me how to query the extended_column , thanks a lot.
Best regards.
[cid:image001.png@01D4FF3F.AA808940]
[cid:image002.png@01D4FF3F.AA808940]
Re: How to use EXTENDED_COLUMN？
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi Gaoyang,
If you search "Apache Kylin" + "Extended column", there are a couple of
related articles, like:
http://apache-kylin.74782.x6.nabble.com/Consulting-quot-EXTENDED-COLUMN-quot-td6463.html
https://blog.bcmeng.com/post/kylin-dimension.html#extended-column
https://www.cnblogs.com/double-kill/p/8371595.html
Regarding "which is more efficient, extended_column or joint_dimensions", I
think "extended_column" is better because with it the HBase rowkey will be
shorter; while "joint_dimension" will
add both of the columns into the rowkey, which will impact HBase scan
performance.
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
高扬02 <ga...@bianfeng.com> 于2019年4月26日周五 下午3:50写道：
> Hello,
>
> By the way, in the situation "select host_column , extended_column where
> host_column..", which is more efficient, extended_column or
> joint_dimensions?
>
> Thanks a lot.
>
> Best regards.
>
>
>
> *发件人:* 高扬02 [mailto:gaoyang02@bianfeng.com]
> *发送时间:* 2019年4月26日 15:19
> *收件人:* user@kylin.apache.org
> *主题:* How to use EXTENDED_COLUMN？
>
>
>
> Hello,
>
>
>
> Kylin 2.6.0.
>
> As the picture , I set dayplus2 as EXTENDED_COLUMN , and data_day is the
> dimension and host column.
>
> But how to query with them? I queryed dayplus2 with filtered data_day ,
> but it has no result.
>
> Please show me how to query the extended_column , thanks a lot.
>
> Best regards.
>
>
>
>
>
>