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/07/15 06:49:34 UTC

Where the high cardinality dimension should be placed in the rowkey

Hello,
I have two high cardinality dimensions , which only “group by bmid_user”, but no “where bmid_user in (xx,xx)”, so I put them in the end of rowkeys. Is this right?
[cid:image001.png@01D53B1C.83B025A0]

Thanks very much.


答复: Where the high cardinality dimension should be placed in the rowkey

Posted by 高扬02 <ga...@bianfeng.com>.
Hi Temple Zhou,
Thank you for your reply.
Yes, the previous dimensions have filtering requirements like “where xx in (xx,xx)”.
Thanks very much.

发件人: Temple Zhou [mailto:dbaztp@gmail.com]
发送时间: 2019年7月15日 14:59
收件人: user <us...@kylin.apache.org>
主题: Re: Where the high cardinality dimension should be placed in the rowkey

If those dimensions before the two with high cardinality will be used for filtering, maybe, you are right.
[image.png]

On Mon, Jul 15, 2019 at 2:49 PM 高扬02 <ga...@bianfeng.com>> wrote:
Hello,
I have two high cardinality dimensions , which only “group by bmid_user”, but no “where bmid_user in (xx,xx)”, so I put them in the end of rowkeys. Is this right?
[cid:image003.png@01D53B1E.C83D83F0]

Thanks very much.


Re: Where the high cardinality dimension should be placed in the rowkey

Posted by Temple Zhou <db...@gmail.com>.
If those dimensions before the two with high cardinality will be used for
filtering, maybe, you are right.
[image: image.png]

On Mon, Jul 15, 2019 at 2:49 PM 高扬02 <ga...@bianfeng.com> wrote:

> Hello,
>
> I have two high cardinality dimensions , which only “group by bmid_user”,
> but no “where bmid_user in (xx,xx)”, so I put them in the end of rowkeys.
> Is this right?
>
>
>
> Thanks very much.
>
>
>