== WHY ?? Probably the server-timestamp-uuid playing a role?! =
INSERT INTO test.test (k , v ) VALUES ( 1 ,[1]) ;
INSERT INTO test.test (k , v ) VALUES ( 1 ,[2]) ;
INSERT INTO test.test (k , v ) VALUES ( 1 ,[3]) ;
SELECT * FROM test.test ;
cqlsh> SELECT * FROM test.test ;
k | v
---+-
ying a
role?! =
INSERT INTO test.test (k , v ) VALUES ( 1 ,[1]) ;
INSERT INTO test.test (k , v ) VALUES ( 1 ,[2]) ;
INSERT INTO test.test (k , v ) VALUES ( 1 ,[3]) ;
SELECT * FROM test.test ;
cqlsh> SELECT * FROM test.test ;
*k* | *v*
---+-
ate: Monday, June 19, 2017 at 11:09 PM
To: "Thakrar, Jayesh" <jthak...@conversantmedia.com>, Subroto Barua
<sbarua...@yahoo.com.INVALID>, Zhongxiang Zheng
<zzh...@yahoo-corp.jp>
Cc: "user@cassandra.apache.org" <user@cassandra.apache.org>
Subjec
ECT * FROM test.test ;
k | v
---+-
1 | [3]
// = EXPECTED RESULT =
From: Subroto Barua
Date: Monday, June 19, 2017 at 11:09 PM
To: "Thakrar, Jayesh" , Subroto Barua
, Zhongxiang Zheng
Cc: "user@cassandra.apache.org"
Subject: Re: Question: Behavior of in
here is the response from Datastax support/dev:
In a list each item is its own cell. Append adds a new cell sorted at basically
"current server time uuid" prepend adds at "-current server time uuid". User
supplied time stamps are used for the cell timestamp when specified.
Inserting the entire
Subroto,
Cassandra docs say otherwise.
Writing list data is accomplished with a JSON-style syntax. To write a record
using INSERT, specify the entire list as a JSON array. Note: An INSERT will
always replace the entire list.
Maybe you can elaborate/shed some more light?
Thanks,
Jayesh
Lists
This is an expected behavior.
We learned this issue/feature at the current site (we use Dse 5.08)
Subroto
> On Jun 18, 2017, at 10:29 PM, Zhongxiang Zheng wrote:
>
> Hi all,
>
> I have a question about a behavior when insert a list with specifying
> timestamp.
>
> It is documented that "An
Hi all,
I have a question about a behavior when insert a list with specifying timestamp.
It is documented that "An INSERT will always replace the entire list."
https://github.com/apache/cassandra/blob/trunk/doc/cql3/CQL.textile#lists
However, When a list is inserted multiple times using same