zhangayqian commented on pull request #1003:
URL: https://github.com/apache/kylin/pull/1003#issuecomment-640413476


   ## Design test cases
   
   ### Prepare test env
   - bin/download-flink.sh
   - bin/sample.sh
   - bin/kylin.sh start
   
   ### Case-1
   Build segment:
   - Modify build engine of `kylin_sales_cube` to FLINK;
   - Build two segment `2012-01-01~2012-02-01` and `2012-02-01~2012-03-01`
   ### Case-2
   Merge segment:
   - Build two segment `2012-01-01~2012-02-01` and `2012-02-01~2012-03-01`
   ### Case-3
   Query:
   - Query-1
   ```
   select PART_DT, sum(price), count(distinct SELLER_ID)
   from kylin_sales
   join kylin_cal_dt
   on kylin_sales.PART_DT = kylin_cal_dt.CAL_DT
   where PART_DT > '2012-01-15'
   group by PART_DT
   ```
   - Query-2
   ```
   select SELLER_ID, sum(price)
   from kylin_sales
   group by SELLER_ID
   order by sum(price) desc
   limit 10
   ```
   


----------------------------------------------------------------
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:
[email protected]


Reply via email to