[ 
https://issues.apache.org/jira/browse/CASSANDRA-10876?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16498508#comment-16498508
 ] 

Tania S Engel commented on CASSANDRA-10876:
-------------------------------------------

In 3.11.1 we still see these warnings even when we are inserting into multiple 
tables with the same partition key. The comment above from Patrick seems to 
indicate a partition key is for one keyspace.table. But I thought a partition 
key was a value that hashed to the same value. Is it still a burden on the 
coordinator worthy of a warning if we do a batch insert to 4 tables with the 
same partition key ({color:#333333}Day{color})? For example if we do a batch 
insert into these 2 tables, is that considered a single partition insert and if 
so why is there a warning?

CREATE TABLE Log_User (Day timestamp, LogTime timeuuid, 
{color:#333333}UserID{color} int)  PRIMARY KEY ({color:#333333}Day {color}, 
UserID, LogTime)

CREATE TABLE Log_Event( Day timestamp, LogTime timeuuid, EventID  int) 
{color:#333333}PRIMARY KEY ({color}{color:#333333}Day {color}{color:#333333}, 
EventID , LogTime){color}

> Alter behavior of batch WARN and fail on single partition batches
> -----------------------------------------------------------------
>
>                 Key: CASSANDRA-10876
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10876
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Patrick McFadin
>            Assignee: Sylvain Lebresne
>            Priority: Minor
>              Labels: lhf
>             Fix For: 3.6
>
>         Attachments: 10876.txt
>
>
> In an attempt to give operator insight into potentially harmful batch usage, 
> Jiras were created to log WARN or fail on certain batch sizes. This ignores 
> the single partition batch, which doesn't create the same issues as a 
> multi-partition batch. 
> The proposal is to ignore size on single partition batch statements. 
> Reference:
> [CASSANDRA-6487|https://issues.apache.org/jira/browse/CASSANDRA-6487]
> [CASSANDRA-8011|https://issues.apache.org/jira/browse/CASSANDRA-8011]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to