[KYLIN-4314] Support union in intersect_count() function

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: v3.1.0, v2.6.6
• Component/s: Query Engine
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 26/Dec/19 01:38
• Updated: 31/Jul/20 12:12
• Resolved: 29/Apr/20 07:27

Description

The current version of "intersect_count" only support "intersect" operation. While in some cases, we may union some collections(bitmaps) first, and then intersect with other collections. For example:

 

intersect_count(user_id, page_id, array['search', 'view', 'order']);

– this calculation how many users did "search", and then "view", and then make the "order".

 

intersect_count(user_id, page_id, array['search|view', 'order']);

– this calculation how many users did "search" or "view" (any of them) , and then make the "order".

 

Issue Links

• links to: GitHub Pull Request #1088