Re: How to insert "Empty" timeuuid by Cql

[Vladimir Yudovin]

Hi,



what does it exactly mean 'empty timeuuid'?  UUID takes 16 bytes for storage, 
so it should be either null, or some value. Do you mean 'zero' UUID?



Best regards, Vladimir Yudovin, 

Winguzone - Hosted Cloud Cassandra
Launch your cluster in minutes.





---- On Wed, 19 Oct 2016 09:16:29 -0400coderhlj <coder...@gmail.com> 
wrote ----




Hi all,



We use Cassandra 2.1.11 in our product, and we update the Java Drive from 
Astyanax(Thrift API) to DataStax Java Driver(Cql) recently, but we encounter a 
difficult issue as following, please help us, thanks in advance.



Previously we were using Astyanax API, and we can insert empty timeuuid like 
below, but now we can only insert null timeuuid by cql command but not empty 
one. Is there any cql function to insert an empty timeuuid like by Astyanax?

And this cause a tough problem is that we can not delete the record by 
specifying the primary key, like:

delete from "Foo" where column1='test' and column2='accessState' and column3='' 
and column4=(need fill empty uuid here) IF EXISTS;



key              | column1      | column2 | column3 | column4 | value

-------------+-------------+---------+--------- 
+---------+----------------------

test by thrift | accessState |              |              |              | 0x5




key              | column1      | column2 | column3 | column4  | value

-------------+-------------+---------+---------+----------+----------------------

 test by cql   | accessState |              |             |  null         | 0x5






cqlsh:StorageOS> desc table "Foo";  



CREATE TABLE "Foo" (

  key text,

  column1 text,

  column2 text,

  column3 text,

  column4 timeuuid,

  value blob,

  PRIMARY KEY (key, column1, column2, column3, column4)

) WITH COMPACT STORAGE AND

  bloom_filter_fp_chance=0.010000 AND

  caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND

  comment='' AND

  dclocal_read_repair_chance=0.100000 AND

  gc_grace_seconds=432000 AND

  read_repair_chance=0.000000 AND

  default_time_to_live=0 AND

  speculative_retry='NONE' AND

  memtable_flush_period_in_ms=0 AND

  compaction={'class': 'SizeTieredCompactionStrategy'} AND

  compression={'sstable_compression': 'LZ4Compressor'};




------------------

Thanks,

Lijun Huang