Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-53675

Enable columnar filters

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Done
    • Major
    • Morpheus
    • Morpheus
    • analytics

    Description

      One of the features of the new columnar format is that it keeps the min/max values for each column per mega leaf node (a multi-pages leaf node, which stores 15K tuples by default). For queries with predicates, the filters could be utilized to skip reading the columns of the tuples in a mega leaf node that do not satisfy those predicates.

      For example, in the following query:

      SELECT name, age, salary
      FROM Employee
      WHERE age BETWEEN 20 AND 30
      AND salary > 100000

      the columns name, age, and salary will be read if only the mega leaf node contains employees whose ages are between 20 and 30, and whose salary is greater than 100K

      Attachments

        Activity

          People

            wail.alkowaileet Wail Alkowaileet (Inactive)
            wail.alkowaileet Wail Alkowaileet (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty