You're correct, cassandra 2.1 is still using protocol version 3. You need at least version 2.2.
On Thu, Oct 20, 2016 at 11:18 AM, Lijun Huang <coder...@gmail.com> wrote: > 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 > -- Stefania Alborghetti |+852 6114 9265| stefania.alborghe...@datastax.com
