Uploaded image for project: 'Apache MADlib'
  1. Apache MADlib
  2. MADLIB-917

Path - window functions (multiple matches per partition, 1 window per match)

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v1.9
    • v1.9
    • Module: Utilities
    • None

    Description

      Story

      As a user, I want to define symbols so that I can define a regular expression of symbols to identify sequences of events that I care about.

      Partition:
      1) Multiple matches per partition in this story.

      2) Note that the match in the data might not span the whole partition, that is, that matched rows could just be a subset of the rows in the partition.

      Window:
      1) Limited to 1 window per partition.

      Other
      1) Club rows together in the case where there are multiple matches per partition, when doing aggregate/window functions. E.g., if doing sum of a revenue column, then sum all rows from all matches (as opposed to a separate sum for each match).

      Attachments

        1. path query3.sql
          4 kB
          Frank McQuillan
        2. Ecommerce data set for path test 3.csv
          2 kB
          Frank McQuillan

        Activity

          People

            riyer Rahul Iyer
            fmcquillan Frank McQuillan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: