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.
>
