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

Reject default_time_to_live option when creating or altering MVs

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 3.0.11, 3.10
    • Component/s: None
    • Labels:
    • Severity:
      Low

      Description

      Hi,

      By default, materialized views are using the TTL of primary table, irrespective of the configured value provided in materialized view creation.

      For eg:

      table:

      CREATE TABLE test2(id text, date text, col1 text,col2 text, PRIMARY KEY(id,date)) WITH default_time_to_live = 60 AND CLUSTERING ORDER BY (date DESC);

      CREATE MATERIALIZED VIEW test3_view AS
      SELECT id, date, col1
      FROM test3
      WHERE id IS NOT NULL AND date IS NOT NULL
      PRIMARY KEY(id,date) WITH default_time_to_live = 30;

      The queries are accepted in CQL. As per the detail, it should use 30 seconds for Materialized view and 60 seconds for parent table.
      But, it is always 60 seconds (as the parent table)

      case 1:
      parent table and materialized view with different TTL
      MV will always have the TTL of parent.

      case 2:
      Parent table without TTL but materialized view with TTL
      MV does not have the TTL even though the configuration has been accepted in the table creation.

      Expected:
      Either the TTL configuration should not be accepted in the materialized view creation, if it is of no value.

      Or

      TTL has to be applied differently for both Materialized View and Table if the configuration is added.

      If no configuration, TTL has to be taken from the parent table.

        Attachments

        1. 12868-trunk.txt
          7 kB
          Sundar Srinivasan

          Issue Links

            Activity

              People

              • Assignee:
                krishnasun Sundar Srinivasan
                Reporter:
                srini.daruna Srinivasarao Daruna
                Authors:
                Sundar Srinivasan
                Reviewers:
                Sylvain Lebresne
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: