[
https://issues.apache.org/jira/browse/CASSANDRA-12620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15722612#comment-15722612
]
Brice Dutheil edited comment on CASSANDRA-12620 at 12/5/16 4:11 PM:
--------------------------------------------------------------------
[~blerer] We have rollbacked an environment. I'm not sure I can upload the dump
(maybe in private). But here's another primary key that is *expired* before and
after the upgrade :
For information 1479813209 : Tue, 22 Nov 2016 11:13:29 GMT
{code:title=sstable2json / DSE 4.8.6 / Cassandra 2.1.13}
{"key": "1c5598b3-70de-4ba5-a9ec-a57a61d3f494",
"cells": [["",1479813209,1479813209820000,"d"],
["field1",1479813209,1479813209820000,"d"],
["field2",1479813209,1479813209820000,"d"],
["field3",1479813209,1479813209820000,"d"],
["field4",1479813209,1479813209820000,"d"],
["field5",1479813209,1479813209820000,"d"],
["field7:_","scopes:!",1479813209819999,"t",1479813209],
["field7:41444d494e5f4150504c49434154494f4e",1479813209,1479813209820000,"d"],
["field7:41444d494e5f434154414c4f475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f434154414c4f475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f5452414e53414354494f4e535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f454e41424c494e475f5041434b",1479813209,1479813209820000,"d"],
["field7:41444d494e5f464f524249445f4d534953444e5f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f464f524249445f4d534953444e5f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f434845434b",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f4f464645525f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f4f464645525f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5041434b5f50524943494e475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5041434b5f50524943494e475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f504152544e45525f50524f564953494f4e494e475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f504152544e45525f50524f564953494f4e494e475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f50524f4d4f54494f4e5f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f50524f4d4f54494f4e5f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5245504f52545f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f53434f5045535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f534d535f53454e44",1479813209,1479813209820000,"d"],
["field7:41444d494e5f555345525f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f555345525f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f56414c49444154494f4e5f53454e44",1479813209,1479813209820000,"d"],
["field7:41444d494e5f564f4943455f44455354494e4154494f4e5f42554e444c45535f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f434c49454e545f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f434c49454e545f5752495445",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f47524f55505f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f47524f55505f5752495445",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f555345525f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f555345525f5752495445",1479813209,1479813209820000,"d"],
["field6",1479813209,1479813209820000,"d"],
["field8",1479813209,1479813209820000,"d"]]},
{code}
{code:title=sstabledump / DSE 5.0.4 / Cassandra 3.0.10}
{
"partition" : {
"key" : [ "1c5598b3-70de-4ba5-a9ec-a57a61d3f494" ],
"position" : 0
},
"rows" : [
{
"type" : "row",
"position" : 50,
"liveness_info" : { "tstamp" : "2016-11-22T11:13:29.820Z" },
"cells" : [
{ "name" : "field1", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field2", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field3", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field4", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field5", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field6", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field8", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field7", "deletion_info" : { "marked_deleted" :
"2016-11-22T11:13:29.819999Z", "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_APPLICATION" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CATALOG_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CATALOG_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_TRANSACTIONS_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_ENABLING_PACK" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_FORBID_MSISDN_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_FORBID_MSISDN_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_CHECK" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_WRITE" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_OFFER_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" }
{ "name" : "field7", "path" : [ "ADMIN_OFFER_WRITE" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PACK_PRICING_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PACK_PRICING_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PARTNER_PROVISIONING_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PARTNER_PROVISIONING_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PROMOTION_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PROMOTION_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_REPORT_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_SCOPES_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_SMS_SEND" ], "deletion_info" : {
"local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_USER_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_USER_WRITE" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_VALIDATION_SEND" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_VOICE_DESTINATION_BUNDLES_READ"
], "deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_CLIENT_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_CLIENT_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_GROUP_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_GROUP_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_USER_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_USER_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } }
]
}
]
},
{code}
*Edit:* the sstable2json has been done *after* a repair.
was (Author: bric3):
[~blerer] We have rollbacked an environment. I'm not sure I can upload the dump
(maybe in private). But here's another primary key that is *expired* before and
after the upgrade :
For information 1479813209 : Tue, 22 Nov 2016 11:13:29 GMT
{code:title=sstable2json / DSE 4.8.6 / Cassandra 2.1.13}
{"key": "1c5598b3-70de-4ba5-a9ec-a57a61d3f494",
"cells": [["",1479813209,1479813209820000,"d"],
["field1",1479813209,1479813209820000,"d"],
["field2",1479813209,1479813209820000,"d"],
["field3",1479813209,1479813209820000,"d"],
["field4",1479813209,1479813209820000,"d"],
["field5",1479813209,1479813209820000,"d"],
["field7:_","scopes:!",1479813209819999,"t",1479813209],
["field7:41444d494e5f4150504c49434154494f4e",1479813209,1479813209820000,"d"],
["field7:41444d494e5f434154414c4f475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f434154414c4f475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f5452414e53414354494f4e535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f435245444954535f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f454e41424c494e475f5041434b",1479813209,1479813209820000,"d"],
["field7:41444d494e5f464f524249445f4d534953444e5f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f464f524249445f4d534953444e5f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f434845434b",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f484f54425f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f4f464645525f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f4f464645525f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5041434b5f50524943494e475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5041434b5f50524943494e475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f504152544e45525f50524f564953494f4e494e475f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f504152544e45525f50524f564953494f4e494e475f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f50524f4d4f54494f4e5f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f50524f4d4f54494f4e5f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f5245504f52545f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f53434f5045535f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f534d535f53454e44",1479813209,1479813209820000,"d"],
["field7:41444d494e5f555345525f52454144",1479813209,1479813209820000,"d"],
["field7:41444d494e5f555345525f5752495445",1479813209,1479813209820000,"d"],
["field7:41444d494e5f56414c49444154494f4e5f53454e44",1479813209,1479813209820000,"d"],
["field7:41444d494e5f564f4943455f44455354494e4154494f4e5f42554e444c45535f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f434c49454e545f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f434c49454e545f5752495445",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f47524f55505f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f47524f55505f5752495445",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f555345525f52454144",1479813209,1479813209820000,"d"],
["field7:415554485f41444d494e5f555345525f5752495445",1479813209,1479813209820000,"d"],
["field6",1479813209,1479813209820000,"d"],
["field8",1479813209,1479813209820000,"d"]]},
{code}
{code:title=sstabledump / DSE 5.0.4 / Cassandra 3.0.10}
{
"partition" : {
"key" : [ "1c5598b3-70de-4ba5-a9ec-a57a61d3f494" ],
"position" : 0
},
"rows" : [
{
"type" : "row",
"position" : 50,
"liveness_info" : { "tstamp" : "2016-11-22T11:13:29.820Z" },
"cells" : [
{ "name" : "field1", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field2", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field3", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field4", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field5", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field6", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field8", "deletion_info" : { "local_delete_time" :
"2016-11-22T11:13:29Z" } },
{ "name" : "field7", "deletion_info" : { "marked_deleted" :
"2016-11-22T11:13:29.819999Z", "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_APPLICATION" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CATALOG_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CATALOG_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_TRANSACTIONS_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_CREDITS_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_ENABLING_PACK" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_FORBID_MSISDN_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_FORBID_MSISDN_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_CHECK" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_HOTB_WRITE" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_OFFER_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" }
{ "name" : "field7", "path" : [ "ADMIN_OFFER_WRITE" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PACK_PRICING_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PACK_PRICING_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PARTNER_PROVISIONING_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PARTNER_PROVISIONING_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PROMOTION_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_PROMOTION_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_REPORT_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_SCOPES_READ" ], "deletion_info"
: { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_SMS_SEND" ], "deletion_info" : {
"local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_USER_READ" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_USER_WRITE" ], "deletion_info" :
{ "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_VALIDATION_SEND" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "ADMIN_VOICE_DESTINATION_BUNDLES_READ"
], "deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_CLIENT_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_CLIENT_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_GROUP_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_GROUP_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_USER_READ" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } },
{ "name" : "field7", "path" : [ "AUTH_ADMIN_USER_WRITE" ],
"deletion_info" : { "local_delete_time" : "2016-11-22T11:13:29Z" } }
]
}
]
},
{code}
> Resurrected empty rows on update to 3.x
> ---------------------------------------
>
> Key: CASSANDRA-12620
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12620
> Project: Cassandra
> Issue Type: Bug
> Reporter: Collin Sauve
> Assignee: Benjamin Lerer
>
> We had the below table on C* 2.x (dse 4.8.4, we assume was 2.1.15.1423
> according to documentation), and were entering TTLs at write-time using the
> DataStax C# Driver (using the POCO mapper).
> Upon upgrade to 3.0.8.1293 (DSE 5.0.2), we are seeing a lot of rows that:
> * should have been TTL'd
> * have no non-primary-key column data
> {code}
> CREATE TABLE applicationservices.aggregate_bucket_event_v3 (
> bucket_type int,
> bucket_id text,
> date timestamp,
> aggregate_id text,
> event_type int,
> event_id text,
> entities list<frozen<tuple<int, text>>>,
> identity_sid text,
> PRIMARY KEY ((bucket_type, bucket_id), date, aggregate_id, event_type,
> event_id)
> ) WITH CLUSTERING ORDER BY (date DESC, aggregate_id ASC, event_type ASC,
> event_id ASC)
> AND bloom_filter_fp_chance = 0.1
> AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
> AND comment = ''
> AND compaction = {'class':
> 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
> AND compression = {'chunk_length_in_kb': '64', 'class':
> 'org.apache.cassandra.io.compress.LZ4Compressor'}
> AND crc_check_chance = 1.0
> AND dclocal_read_repair_chance = 0.1
> AND default_time_to_live = 0
> AND gc_grace_seconds = 864000
> AND max_index_interval = 2048
> AND memtable_flush_period_in_ms = 0
> AND min_index_interval = 128
> AND read_repair_chance = 0.0
> AND speculative_retry = '99PERCENTILE';
> {code}
> {code}
> {
> "partition" : {
> "key" : [ "0", "26492" ],
> "position" : 54397932
> },
> "rows" : [
> {
> "type" : "row",
> "position" : 54397961,
> "clustering" : [ "2016-09-07 23:33Z", "3651664", "0",
> "773665449947099136" ],
> "liveness_info" : { "tstamp" : "2016-09-07T23:34:09.758Z", "ttl" :
> 172741, "expires_at" : "2016-09-09T23:33:10Z", "expired" : false },
> "cells" : [
> { "name" : "identity_sid", "value" : "p_tw_zahidana" },
> { "name" : "entities", "deletion_info" : { "marked_deleted" :
> "2016-09-07T23:34:09.757999Z", "local_delete_time" : "2016-09-07T23:34:09Z" }
> },
> { "name" : "entities", "path" : [
> "936e17e1-7553-11e6-9b92-29a33b5827c3" ], "value" :
> "0:https\\://www.youtube.com/watch?v=pwAJAssv6As" },
> { "name" : "entities", "path" : [
> "936e17e2-7553-11e6-9b92-29a33b5827c3" ], "value" : "2:youtube" }
> ]
> },
> {
> "type" : "row",
> },
> {
> "type" : "row",
> "position" : 54397177,
> "clustering" : [ "2016-08-17 10:00Z", "6387376", "0",
> "765850666296225792" ],
> "liveness_info" : { "tstamp" : "2016-08-17T11:26:15.917001Z" },
> "cells" : [ ]
> },
> {
> "type" : "row",
> "position" : 54397227,
> "clustering" : [ "2016-08-17 07:00Z", "6387376", "0",
> "765805367347601409" ],
> "liveness_info" : { "tstamp" : "2016-08-17T08:11:17.587Z" },
> "cells" : [ ]
> },
> {
> "type" : "row",
> "position" : 54397276,
> "clustering" : [ "2016-08-17 04:00Z", "6387376", "0",
> "765760069858365441" ],
> "liveness_info" : { "tstamp" : "2016-08-17T05:58:11.228Z" },
> "cells" : [ ]
> },
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
