Uploaded image for project: 'CDAP'
  1. CDAP
  2. CDAP-6860

improve cube performance when querying for more than one measure

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.3.6, 3.4.3
    • Fix Version/s: 3.5.0, 3.3.7, 3.4.4
    • Component/s: None
    • Labels:
      None
    • Release Notes:
      Improved performance in cube datasets when querying for more than one measure in a query. This will also improve metrics query performance.
    • Rank:
      1|hzzipb:

      Description

      currently in cube, when we query for more than one measure, we use "any" fuzzy key for measures. this is okay when there are less number of measures in an aggregation.
      however if an aggregation has a lot of measures, this becomes very inefficient and leads to time out when querying multiple measures in a single query.

      we can improve this by having adding multiple fuzzy pairs with fixed fuzzy keys for the measures queried.

        Attachments

          Activity

            People

            • Assignee:
              shankar Shankar Selvam
              Reporter:
              shankar Shankar Selvam
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: