Re: How to insert "Empty" timeuuid by Cql

[Stefania Alborghetti]

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  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  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 
>>> 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  - Hosted Cloud
 CassandraLaunch your cluster in minutes.*


  On Wed, 19 Oct 2016 09:16:29 -0400*coderhlj >* 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.01 AND
   caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
   comment='' AND
   dclocal_read_repair_chance=0.10 AND
   gc_grace_seconds=432000 AND
   read_repair_chance=0.00 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,
>>> 

Re: How to insert "Empty" timeuuid by Cql

[Lijun Huang]

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  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 
>> 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  - Hosted Cloud
>>> CassandraLaunch your cluster in minutes.*
>>>
>>>
>>>  On Wed, 19 Oct 2016 09:16:29 -0400*coderhlj >> >* 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.01 AND
>>>   caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
>>>   comment='' AND
>>>   dclocal_read_repair_chance=0.10 AND
>>>   gc_grace_seconds=432000 AND
>>>   read_repair_chance=0.00 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

Re: How to insert "Empty" timeuuid by Cql

[Stefania Alborghetti]

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  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 
> 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  - Hosted Cloud
>> CassandraLaunch your cluster in minutes.*
>>
>>
>>  On Wed, 19 Oct 2016 09:16:29 -0400*coderhlj > >* 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.01 AND
>>   caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
>>   comment='' AND
>>   dclocal_read_repair_chance=0.10 AND
>>   gc_grace_seconds=432000 AND
>>   read_repair_chance=0.00 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

Re: How to insert "Empty" timeuuid by Cql

[Lijun Huang]

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 
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  - Hosted Cloud
> CassandraLaunch your cluster in minutes.*
>
>
>  On Wed, 19 Oct 2016 09:16:29 -0400*coderhlj  >* 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.01 AND
>   caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
>   comment='' AND
>   dclocal_read_repair_chance=0.10 AND
>   gc_grace_seconds=432000 AND
>   read_repair_chance=0.00 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

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.01 AND

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

  comment='' AND

  dclocal_read_repair_chance=0.10 AND

  gc_grace_seconds=432000 AND

  read_repair_chance=0.00 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

How to insert "Empty" timeuuid by Cql

[coderhlj]

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.01 AND
  caching='{"keys":"ALL", "rows_per_partition":"NONE"}' AND
  comment='' AND
  dclocal_read_repair_chance=0.10 AND
  gc_grace_seconds=432000 AND
  read_repair_chance=0.00 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