kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xiaoxiang Yu <>
Subject Re: cube-rowkey排序咨询
Date Tue, 11 Jun 2019 02:45:33 GMT
Hi, wangfx

Kylin converts sql query to two parameters(Start_key and end_key) in the range Scan operation
in HBase.
The well-designed Rowkey will more effectively complete the query filtering and positioning
of the data, reduce the number of IO, improve the query speed, the order of the dimension
in the Rowkey, and have a significant impact on the query performance.

The following 2 principles need to be combined when adjusting the order of Rowkey: ·
1. Dimensions that are used as filter criteria in a query are placed in front of the non-filtered
conditional dimension ·
2. Dimensions with a higher cardinality, before the lower cardinality dimension.

So, in your situation, I suggest the order should be :a,b,c,d.(If you have only four dimensions).

And this link may help,

Best wishes,
Xiaoxiang Yu 

在 2019/6/11 09:56,“wangfx”<> 写入:


View raw message