Hi DuyHai, Could you please explain in what case C* will error based on documented statement:
You can set a default TTL for an entire table by setting the table's default_time_to_live <https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#tabProp__cqlTableDefaultTTL> property. If you try to set a TTL for a specific column that is longer than the time defined by the table TTL, Cassandra returns an error. On Wed, Jul 11, 2018 at 2:34 PM, DuyHai Doan <doanduy...@gmail.com> wrote: > default_time_to_live > <https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#tabProp__cqlTableDefaultTTL> > property applies if you don't specify any TTL on your CQL statement > > However you can always override the default_time_to_live > <https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#tabProp__cqlTableDefaultTTL> > property by specifying a custom value for each CQL statement > > The behavior is correct, nothing wrong here > > On Wed, Jul 11, 2018 at 7:31 PM, Nitan Kainth <nitankai...@gmail.com> > wrote: > >> Hi, >> >> As per document: https://docs.datastax.com/en/cql/3.3/cql/cql_ >> using/useExpireExample.html >> >> >> - >> >> You can set a default TTL for an entire table by setting the table's >> default_time_to_live >> >> <https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlCreateTable.html#tabProp__cqlTableDefaultTTL> >> property. If you try to set a TTL for a specific column that is >> longer than the time defined by the table TTL, Cassandra returns an error. >> >> >> When I tried to test this statement, i found, we can insert data with TTL >> greater than default_time_to_live. Is the document needs correction, or am >> I mis-understanding it? >> >> CREATE TABLE test ( >> >> name text PRIMARY KEY, >> >> description text >> >> ) WITH bloom_filter_fp_chance = 0.01 >> >> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'} >> >> AND comment = '' >> >> AND compaction = {'class': 'org.apache.cassandra.db.compa >> ction.SizeTieredCompactionStrategy', 'max_threshold': '32', >> 'min_threshold': '4'} >> >> AND compression = {'chunk_length_in_kb': '64', 'class': ' >> org.apache.cassandra.io.compress.LZ4Compressor'} >> >> AND crc_check_chance = 1.0 >> >> AND dclocal_read_repair_chance = 0.1 >> >> AND default_time_to_live = 240 >> >> AND gc_grace_seconds = 864000 >> >> AND max_index_interval = 2048 >> >> AND memtable_flush_period_in_ms = 0 >> >> AND min_index_interval = 128 >> >> AND read_repair_chance = 0.0 >> >> AND speculative_retry = '99PERCENTILE'; >> >> insert into test (name, description) values ('name5', 'name >> description5') using ttl 360; >> >> select * from test ; >> >> >> name | description >> >> -------+------------------- >> >> name5 | name description5 >> >> >> SELECT TTL (description) from test; >> >> >> ttl(description) >> >> ------------------ >> >> 351 >> >> Can someone please clear this for me? >> >> >> >> >> >> >