[KYLIN-2088] Support intersect count for calculation of retention or conversion rates

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.6.0
• Component/s: Query Engine
• Assignee: Yerui Sun
• Reporter: Yerui Sun
• Created: 12/Oct/16 12:51
• Updated: 10/Dec/16 14:19
• Resolved: 16/Nov/16 22:30

Description

Retention or Conversion Rates is very important in data analyze.
It can be calculated from two dataset of two different value of one dimension. For example, we have an count distinct measure, like uv(dataset of uuid), and one dimension, like date, and the retention of uv between '20161015' and '20161016' is the intersection of two uv datasets.
Fortunately, we have implement dataset in Kylin, as bitmap, for precisely count distinct. Only an UDAF is needed to calculate intersection of two or more bitmaps.
I'll try on this and post patch later.