[GitHub] [kylin] hit-lacus commented on issue #1070: KYLIN-4312 Specified cube when querying by API

[GitBox]

hit-lacus commented on issue #1070: KYLIN-4312 Specified cube when querying by 
API
URL: https://github.com/apache/kylin/pull/1070#issuecomment-575962251
 
 
   ## 需求背景
   
   1. 数据缺失
   比如A这个人 她想查abcf四个维度 ，B这个人她想查bcd这三个维度，指标都一样。但是A是在 1月3号建了Cube，B是在8号建的Cube。
   这时候我查bc这两个维度的时候就会命中B的cube ，那前面的时间就没有了
   
   2. 满足测试
   测试时无法测试特定的Cube，只能频繁地Enable Disable Cube
   
   ## 测试
   
   1. 为两个设置相同的Cube 分别构建Segment，但是Segment Range不同
   <img width="1228" alt="image" 
src="https://user-images.githubusercontent.com/14030549/71353852-3c591200-25b5-11ea-81b9-1996b6584b2b.png";>
   
   2. WebUI 查询
   
   命中`SimpleCube_02`
   <img width="1051" alt="image" 
src="https://user-images.githubusercontent.com/14030549/71354009-a1ad0300-25b5-11ea-9f10-8d1bb02eb6d9.png";>
   
   3. 强制切换Cube，使之命中 `SimpleCube_01`
   
   ```json
   {  
      "sql":"select part_dt, count(*) from KYLIN_SALES group by part_dt order 
by part_dt",
      "offset":0,
      "limit":50000,
      "acceptPartial":false,
      "project":"learn_kylin",
      "backdoorToggles":{"DEBUG_TOGGLE_HIT_CUBE":"SimpleCube_01"}
   }
   ```
   <img width="976" alt="image" 
src="https://user-images.githubusercontent.com/14030549/71354156-049e9a00-25b6-11ea-8d80-1907da838f04.png";>

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services