You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 杨浩 <ya...@gmail.com> on 2017/11/14 02:52:02 UTC
how to change the order of rowkey_columns
To speed up the query, we should position the frequent column before
others, such as partition column date should be at the first for every
query would contain it. Then how to change the order of rowkey_columns, or
in other words, what decides the order of rowkey_columns?
Re: how to change the order of rowkey_columns
Posted by ShaoFeng Shi <sh...@apache.org>.
I had thought everyone knows that; If not, that means the GUI there is not
enough clear.
2017-11-15 9:40 GMT+08:00 杨浩 <ya...@gmail.com>:
> Thanks for that
>
> 2017-11-14 22:50 GMT+08:00 Billy Liu <bi...@apache.org>:
>
>> You could change the rowkey order by drag-and-drop from GUI directly.
>>
>> 2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
>>
>>> To speed up the query, we should position the frequent column before
>>> others, such as partition column date should be at the first for every
>>> query would contain it. Then how to change the order of rowkey_columns, or
>>> in other words, what decides the order of rowkey_columns?
>>>
>>
>>
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Re: how to change the order of rowkey_columns
Posted by ShaoFeng Shi <sh...@apache.org>.
The default sequence is the sequence they were added to dimension list. But
you can adjust the position based on the query patterns: move the filtering
columns ahead of non-filtering columns will let Kylin to narrow down the
scan scope, so gain better query performance.
2017-11-15 13:57 GMT+08:00 Dongpeng Wang <ap...@163.com>:
>
> RowKey Sequence is fact table Column sequence.
>
>
>
> apache_dev@163.com
>
> From: 杨浩
> Date: 2017-11-15 09:40
> To: user
> CC: dev
> Subject: Re: how to change the order of rowkey_columns
> Thanks for that
>
> 2017-11-14 22:50 GMT+08:00 Billy Liu <bi...@apache.org>:
>
> > You could change the rowkey order by drag-and-drop from GUI directly.
> >
> > 2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
> >
> >> To speed up the query, we should position the frequent column before
> >> others, such as partition column date should be at the first for every
> >> query would contain it. Then how to change the order of
> rowkey_columns, or
> >> in other words, what decides the order of rowkey_columns?
> >>
> >
> >
>
--
Best regards,
Shaofeng Shi 史少锋
Re: Re: how to change the order of rowkey_columns
Posted by Dongpeng Wang <ap...@163.com>.
RowKey Sequence is fact table Column sequence.
apache_dev@163.com
From: 杨浩
Date: 2017-11-15 09:40
To: user
CC: dev
Subject: Re: how to change the order of rowkey_columns
Thanks for that
2017-11-14 22:50 GMT+08:00 Billy Liu <bi...@apache.org>:
> You could change the rowkey order by drag-and-drop from GUI directly.
>
> 2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
>
>> To speed up the query, we should position the frequent column before
>> others, such as partition column date should be at the first for every
>> query would contain it. Then how to change the order of rowkey_columns, or
>> in other words, what decides the order of rowkey_columns?
>>
>
>
Re: how to change the order of rowkey_columns
Posted by 杨浩 <ya...@gmail.com>.
Thanks for that
2017-11-14 22:50 GMT+08:00 Billy Liu <bi...@apache.org>:
> You could change the rowkey order by drag-and-drop from GUI directly.
>
> 2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
>
>> To speed up the query, we should position the frequent column before
>> others, such as partition column date should be at the first for every
>> query would contain it. Then how to change the order of rowkey_columns, or
>> in other words, what decides the order of rowkey_columns?
>>
>
>
Re: how to change the order of rowkey_columns
Posted by 杨浩 <ya...@gmail.com>.
Thanks for that
2017-11-14 22:50 GMT+08:00 Billy Liu <bi...@apache.org>:
> You could change the rowkey order by drag-and-drop from GUI directly.
>
> 2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
>
>> To speed up the query, we should position the frequent column before
>> others, such as partition column date should be at the first for every
>> query would contain it. Then how to change the order of rowkey_columns, or
>> in other words, what decides the order of rowkey_columns?
>>
>
>
Re: how to change the order of rowkey_columns
Posted by Billy Liu <bi...@apache.org>.
You could change the rowkey order by drag-and-drop from GUI directly.
2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
> To speed up the query, we should position the frequent column before
> others, such as partition column date should be at the first for every
> query would contain it. Then how to change the order of rowkey_columns, or
> in other words, what decides the order of rowkey_columns?
>
Re: how to change the order of rowkey_columns
Posted by Billy Liu <bi...@apache.org>.
You could change the rowkey order by drag-and-drop from GUI directly.
2017-11-14 10:52 GMT+08:00 杨浩 <ya...@gmail.com>:
> To speed up the query, we should position the frequent column before
> others, such as partition column date should be at the first for every
> query would contain it. Then how to change the order of rowkey_columns, or
> in other words, what decides the order of rowkey_columns?
>