[KYLIN-1420] Query returns empty result on partition column's boundary condition

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.4.0
• Fix Version/s: v1.4.0
• Component/s: Query Engine
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 15/Feb/16 06:24
• Updated: 17/Mar/16 07:37
• Resolved: 01/Mar/16 10:22

Description

This issue is reported by an user. The cube has a "month_end_dt" column as the partition column. In the first segment, it built the data from 2015-01-01 to 2016-01-01; The second segment it built the data after 2016-01-01.

The queries which doesn't have filtering condition works as expected, such as:
select month_end_dt,count from fact_table group by month_end_dt order by month_end_dt;

The result set includes the records for each month;

But when filter on the month_end_date='2015-12-31' it is returning 0 records:
select month_end_dt, count from fact_table where month_end_dt='2015-12-31' group by month_end_dt

After doing some investigation, identify it is a bug in v2 query engine: In CubeSegmentScanner.getSegmentStartAndEnd(), it uses -1 as 'roundingFlag' for cubeSeg.getDateRangeEnd(), which may get a smaller value than the cubeSegment's end date; While in GTScanRangePlanner.newScanRange(), it still treat the value as a closed condition, that caused the query on boundary condition returns empty directly.