[KYLIN-5831] Enhance SCD2, history table supports left-closed and right-closed time interval

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 5.0.0
• Component/s: Spark Engine
• Assignee: Zhimin Wu
• Reporter: Zhimin Wu
• Created: 10/Apr/24 03:00
• Updated: 12/Apr/24 08:24
• Resolved: 10/Apr/24 06:32

Description

Current SCD2 only support { >= and < }join condition.

After this issue we support { >=, < }, {>=, <=}, { >, <=} join condition.