Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6477

Materialized Views (was: Global Indexes)

Agile BoardAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Local indexes are suitable for low-cardinality data, where spreading the index across the cluster is a Good Thing. However, for high-cardinality data, local indexes require querying most nodes in the cluster even if only a handful of rows is returned.

      Attachments

        1. test-view-data.sh
          3 kB
          Alan Boudreault
        2. users.yaml
          0.8 kB
          Alan Boudreault

        Issue Links

        duplicates

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9826 Expose tuning parameters from CREATE TABLE to MV

        • Normal -
        • Resolved
        is related to

        Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-9917 MVs should validate gc grace seconds on the tables involved

        • Normal -
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-9967 Determine if a Materialized View is finished building, without having to query each node

        • Low -
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9928 Add Support for multiple non-primary key columns in Materialized View primary keys

        • Normal -
        • Open

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-8517 Make client-side Token Aware Balancing possible with Global Indexes

        • Normal -
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9826 Expose tuning parameters from CREATE TABLE to MV

        • Normal -
        • Resolved

        Task - A task that needs to be done. CASSANDRA-9927 Security for MaterializedViews

        • Normal -
        • Resolved
        relates to

        Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-12888 Incremental repairs broken for MVs and CDC

        • Normal -
        • Open

        New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-9779 Append-only optimization

        • Normal -
        • Open

        New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-9664 Allow MV's select statements to be more complex

        • Normal -
        • Resolved

        Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9415 Implicit use of Materialized Views on SELECT

        • Normal -
        • Resolved
        links to

        Web Link Design doc

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            carlyeks Carl Yeksigian Assign to me
            jbellis Jonathan Ellis
            Carl Yeksigian
            Joshua McKenzie
            Votes:
            9 Vote for this issue
            Watchers:
            57 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment