Re: duplicate rows for partition

2018-08-22 Thread James Shaw
can you run this: select associate_degree, writetime( associate_degree ) from user_data where Thanks, James On Wed, Aug 22, 2018 at 7:13 PM, James Shaw wrote: > can you run this: > select writetime( associate_degree ) from user_data where > see what are writetime > > On Wed, Aug 22,

Re: duplicate rows for partition

2018-08-22 Thread James Shaw
can you run this: select writetime( associate_degree ) from user_data where see what are writetime On Wed, Aug 22, 2018 at 7:03 PM, James Shaw wrote: > interesting. what are insert statement and select statement ? > > Thanks, > > James > > On Wed, Aug 22, 2018 at 6:55 PM, Gosar M > wrote:

Re: duplicate rows for partition

2018-08-22 Thread James Shaw
interesting. what are insert statement and select statement ? Thanks, James On Wed, Aug 22, 2018 at 6:55 PM, Gosar M wrote: > CREATE TABLE user_data ( > "userid" text, > "secondaryid" text, > "tDate" timestamp, > "tid3" text, > "sid4" text, > "pid5" text, > associat

Re: duplicate rows for partition

2018-08-22 Thread Gosar M
CREATE TABLE user_data (     "userid" text,     "secondaryid" text,     "tDate" timestamp,     "tid3" text,     "sid4" text,     "pid5" text,     associate_degree text   PRIMARY KEY (("userid", "secondaryid"),"tDate", "tid3", "sid4", "pid5")   WITH CLUSTERING ORDER BY ("tDate" ASC, "tid3" ASC, "si

Re: duplicate rows for partition

2018-08-22 Thread dinesh.jo...@yahoo.com.INVALID
What is the schema of the table? Could your include the output of DESCRIBE? Dinesh On Wednesday, August 22, 2018, 2:22:31 PM PDT, Gosar M wrote: Hello, Have a table with following partition and clustering keys partition key - ("userid", "secondaryid"), clustering key - "tDate", "tid3"

duplicate rows for partition

2018-08-22 Thread Gosar M
Hello, Have a table with following partition and clustering keys partition key - ("userid", "secondaryid"), clustering key - "tDate", "tid3", "sid4", "pid5" Data is inserted based on above partition and clustering key. For 1 record seeing 2 rows returned when queried by both partition and cluster

Re: Work in Progress - Awesome Cassandra Resources w/ Outline

2018-08-22 Thread Patrick Goliwas
If there is an interest within this thread and the community to include information about a growing segment of Cassandra-related tools for backup/recovery and data mobility, let me know and I can forward documentation for you to include in your guide. Sent via mobile Call/Text: (612) 281-0702

Re: Work in Progress - Awesome Cassandra Resources w/ Outline

2018-08-22 Thread Rahul Singh
Horia, Thanks! I added the links. I can look into contributing this to the blog.. I mainly curate this list to be a definitive guide to eventually all cassandra related things, which would include Datastax, Scylla, Yugabyte, Cosmos, etc. which may ore may not be related to Apache Cassandra per

Re: JBOD disk failure - just say no

2018-08-22 Thread Jonathan Haddad
We recently helped a team deal with some JBOD issues, they can be quite painful, and the experience depends a bit on the C* version in use. We wrote a blog post about it (published today): http://thelastpickle.com/blog/2018/08/22/the-fine-print-when-using-multiple-data-directories.html Hope this

Re: [Cassandra] nodetool compactionstats not showing pending task.

2018-08-22 Thread Oleksandr Shulgin
On Fri, May 5, 2017 at 1:20 PM Alain RODRIGUEZ wrote: > Sorry to hear the restart did not help. > Hi, We are hitting the same issue since a few weeks on version 3.0.16. Normally, restarting an affected node helps, but this is something we would like to avoid doing. What makes it worse for us i