Re: duplicate rows for partition
Hi, I believe the "tDate" is stored with milliseconds precision which could explain why these duplicate dates are shown. Could you try running the following query: "SELECT userid, secondaryid, blobAsBigint(timestampAsBlob("tDate")), tid3, sid4, pid5, associate_degree FROM user_data;" The "tDate" column should be shown with different values at that point. Best Regards Marcus Olsson On ons, 2018-08-22 at 19:20 -0400, James Shaw wrote: 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 mailto: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 mailto: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 mailto: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 mailto: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 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+ | 0a5995672e3 | l34 | l34_listing | 123145979615694 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 | l34_listing | 123145979615694989 We did not had any node which was down longer than gc_grace_period. Thank you.
Re: duplicate rows for partition
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, 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: >> >>> 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 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 >>> 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+ | 0a5995672e3 | l34 >>> | l34_listing | 123145979615694 >>> 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 >>> | l34_listing | 123145979615694989 >>> >>> >>> We did not had any node which was down longer than gc_grace_period. >>> >>> >>> Thank you. >>> >> >> >
Re: duplicate rows for partition
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: > >> 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 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 >> 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+ | 0a5995672e3 | l34 >> | l34_listing | 123145979615694 >> 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 >> | l34_listing | 123145979615694989 >> >> >> We did not had any node which was down longer than gc_grace_period. >> >> >> Thank you. >> > >
Re: duplicate rows for partition
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, > 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 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 > 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+ | 0a5995672e3 | l34 | > l34_listing | 123145979615694 > 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 | > l34_listing | 123145979615694989 > > > We did not had any node which was down longer than gc_grace_period. > > > Thank you. >
Re: duplicate rows for partition
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 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 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+ | 0a5995672e3 | l34 | l34_listing | 123145979615694 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 | l34_listing | 123145979615694989 We did not had any node which was down longer than gc_grace_period. Thank you.
Re: duplicate rows for partition
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", "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+ | 0a5995672e3 | l34 | l34_listing | 123145979615694 090sdfdsf898 | ab984564 | 2018-08-04 07:59:59+ | 0a5995672e3 | l34 | l34_listing | 123145979615694989 We did not had any node which was down longer than gc_grace_period. Thank you.