Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-2088

Support intersect count for calculation of retention or conversion rates

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v1.6.0
    • Query Engine
    • None

    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.

      Attachments

        1. KYLIN-2088.patch
          16 kB
          Yerui Sun

        Activity

          People

            sunyerui Yerui Sun
            sunyerui Yerui Sun
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: