Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D1BA818586 for ; Mon, 30 Nov 2015 09:18:11 +0000 (UTC) Received: (qmail 87362 invoked by uid 500); 30 Nov 2015 09:18:11 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 87301 invoked by uid 500); 30 Nov 2015 09:18:11 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 87111 invoked by uid 99); 30 Nov 2015 09:18:11 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Nov 2015 09:18:11 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 48C742C1F61 for ; Mon, 30 Nov 2015 09:18:11 +0000 (UTC) Date: Mon, 30 Nov 2015 09:18:11 +0000 (UTC) From: "Stefania (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (CASSANDRA-9302) Optimize cqlsh COPY FROM, part 3 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-9302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15031474#comment-15031474 ] Stefania edited comment on CASSANDRA-9302 at 11/30/15 9:17 AM: --------------------------------------------------------------- I've rebased and implemented three more things: * tests with failure injection, in a fashion similar to CASSANDRA-9304 - pull request is [here|https://github.com/riptano/cassandra-dtest/pull/689]. * manual replica selection rather than relying on the driver TAR - we get better performance because we can batch by replica, not just by primary key. * ingest_rate parameter to control how many rows per second we feed to the worker processes - this is required by CASSANDRA-9303 but it made sense to change it here. was (Author: stefania): I've implemented three more things: * tests with failure injection, in a fashion similar to CASSANDRA-9304 - pull request is [here|https://github.com/riptano/cassandra-dtest/pull/689]. * manual replica selection rather than relying on the driver TAR - we get better performance because we can batch by replica, not just by primary key. * ingest_rate parameter to control how many rows per second we feed to the worker processes - this is required by CASSANDRA-9303 but it made sense to change it here. > Optimize cqlsh COPY FROM, part 3 > -------------------------------- > > Key: CASSANDRA-9302 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9302 > Project: Cassandra > Issue Type: Improvement > Components: Tools > Reporter: Jonathan Ellis > Assignee: Stefania > Priority: Critical > Fix For: 2.1.x > > > We've had some discussion moving to Spark CSV import for bulk load in 3.x, but people need a good bulk load tool now. One option is to add a separate Java bulk load tool (CASSANDRA-9048), but if we can match that performance from cqlsh I would prefer to leave COPY FROM as the preferred option to which we point people, rather than adding more tools that need to be supported indefinitely. > Previous work on COPY FROM optimization was done in CASSANDRA-7405 and CASSANDRA-8225. -- This message was sent by Atlassian JIRA (v6.3.4#6332)