Jonathan, Please notice last rows with partition key values (w,v and t). they were inserted same way and has write time values
> On Jul 18, 2017, at 2:22 PM, Jonathan Haddad <j...@jonhaddad.com> wrote: > > This looks like expected behavior to me. You aren't inserting a value for b. > Since there's no value, there's also no writetime. > > On Tue, Jul 18, 2017 at 12:15 PM Nitan Kainth <ni...@bamlabs.com > <mailto:ni...@bamlabs.com>> wrote: > Hi, > > We see that null columns have writetime(column) populated for few columns and > shows null for few other. Is it any bug or something else? > > > CREATE KEYSPACE test WITH replication = {'class': 'NetworkTopologyStrategy', > 'us-east': '2'} AND durable_writes = true; > > CREATE TABLE test.t ( > a text PRIMARY KEY, > b 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.compaction.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 = 0 > 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.t (a ) values ('z’); > insert into test.t (a ) values ('w’); > insert into test.t (a ) values ('e’); > insert into test.t (a ) values ('r’); > insert into test.t (a ) values ('t’); > > select a,b, writetime (b) from test.t ; > > a | b | writetime(b) > ---+------+------------------ > z | null | null > a | null | null > c | null | null > e | null | null > r | null | null > d | null | 1500400745074499 > w | null | 1500400745074499 > v | null | 1500400745074499 > t | null | 1500400745074499 > x | y | 1500400626266371