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 <jxys...@gmail.com> wrote: > 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. >>> >> >> >