[KYLIN-3689] When the startTime is equal to the endTime in build request, the segment will build all data.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.4.0, v2.5.0
• Fix Version/s: v2.5.2
• Component/s: Job Engine, Metadata, Query Engine
• Assignee: Hongtao He
• Reporter: Hongtao He
• Created: 14/Nov/18 15:28
• Updated: 04/Dec/18 04:28
• Resolved: 26/Nov/18 03:55

Description

Hi all:

  We  know that kylin's build job often runs late at night, so calling kylin's restful API directly is a very common thing. In this scenario, if  the startTime is equal to the endTime,  something unexpected will happen. The  job calculates all partition data, so the query result is wrong.

  For example, when I send the following request to kylin.

curl -X PUT -H "Authorization: Basic XXXXXXX" -H 'Content-Type: application/json' -d '{"startTime":'1541894400000', "endTime":'1541894400000', "buildType":"BUILD"}' http://xxxxxx:xxxx/kylin/api/cubes/cube_name/build

then, the job will calculate all partition data. I find the backend interface of build lacks checksum data range, and the sql of generating the flat table is wrong. 

  I try to fix this bug, and the patch  is in the attachment.