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 <jxys...@gmail.com> wrote: > interesting. what are insert statement and select statement ? > > Thanks, > > James > > On Wed, Aug 22, 2018 at 6:55 PM, Gosar M <koolja...@yahoo.com.invalid> > wrote: > >> 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, "sid4" ASC, "pid5" >> ASC) >> >> >> >> On Wednesday, 22 August 2018, 15:08:03 GMT-7, >> dinesh.jo...@yahoo.com.INVALID <dinesh.jo...@yahoo.com.INVALID> wrote: >> >> >> 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 >> <koolja...@yahoo.com.INVALID> wrote: >> >> >> 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 clustering >> key. >> >> >> userid | secondaryid | tdate | tid3 | sid4 >> | pid5 | associate_degree >> ------------------------------------------+---------------- >> -------------------------------------------------+ >> 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+0000 | 0a5995672e3 | l34 >> | l34_listing | 123145979615694 >> 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+0000 | 0a5995672e3 | l34 >> | l34_listing | 123145979615694989 >> >> >> We did not had any node which was down longer than gc_grace_period. >> >> >> Thank you. >> > >