Thanks Stefania, we haven't tried before, and I think the version is not matched, we are still using, [cqlsh 4.1.1 | Cassandra 2.1.11 | CQL spec 3.1.1 | Thrift protocol 19.39.0]
On Thu, Oct 20, 2016 at 10:33 AM, Stefania Alborghetti < stefania.alborghe...@datastax.com> wrote: > Have you already tried using unset values? > > http://www.datastax.com/dev/blog/datastax-java-driver-3-0- > 0-released#unset-values > > They are only available starting with protocol version 4 however. > > On Thu, Oct 20, 2016 at 10:19 AM, Lijun Huang <coder...@gmail.com> wrote: > >> Hi Vladimir, >> >> Indeed, that's a little weird, I think it is like a empty string: '' but >> is a timeuuid value. We have many such records that inserted by Astyanax >> API, when we select it in cqlsh, it is like as below, note the column4 is >> timeuuid, it is not null or some value, just "empty". >> >> key | column1 | column2 | column3 | column4 | value >> ------------------+--------------------+------------+------------ >> +------------+---------------------- >> test by thrift | accessState | | | | >> 0x5 >> >> But when we use Cql, we couldn't set this empty value, it is null or >> explicit value, like below, >> >> key | column1 | column2 | column3 | column4 | value >> ------------------+-------------------+-------------+------- >> ------+--------------+---------------------- >> test by cql | accessState | | | null >> | 0x5 >> >> key | column1 | column2 | column3 | >> column4 | value >> -------------------+------------------+--------------+------ >> ------+----------------------------------------------------- >> ------+--------------------------------- >> test by cql | accessState | | | >> 4a528300-95cb-11e6-8650-0242f5eaa8c3| 0x5 >> >> I don't know whether you could understand now, if not I could provide >> some code related to Astyanax. Really appreciate your help. >> >> >> On Wed, Oct 19, 2016 at 9:53 PM, Vladimir Yudovin <vla...@winguzone.com> >> wrote: >> >>> 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 <https://winguzone.com?from=list> - Hosted Cloud >>> CassandraLaunch your cluster in minutes.* >>> >>> >>> ---- On Wed, 19 Oct 2016 09:16:29 -0400*coderhlj <coder...@gmail.com >>> <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 >>> >>> >>> >> >> >> -- >> Best regards, >> Lijun Huang >> > > > > -- > > > Stefania Alborghetti > > |+852 6114 9265| stefania.alborghe...@datastax.com > -- Best regards, Lijun Huang
