Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9FC0F18E7E for ; Tue, 30 Jun 2015 17:27:41 +0000 (UTC) Received: (qmail 54685 invoked by uid 500); 30 Jun 2015 17:27:38 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 54644 invoked by uid 500); 30 Jun 2015 17:27:38 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 54634 invoked by uid 99); 30 Jun 2015 17:27:38 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Jun 2015 17:27:38 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id CBCC6180348 for ; Tue, 30 Jun 2015 17:27:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 8i4Yd2E3r_r1 for ; Tue, 30 Jun 2015 17:27:31 +0000 (UTC) Received: from mail-ob0-f178.google.com (mail-ob0-f178.google.com [209.85.214.178]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id AF48F21048 for ; Tue, 30 Jun 2015 17:27:30 +0000 (UTC) Received: by obbkm3 with SMTP id km3so11298241obb.1 for ; Tue, 30 Jun 2015 10:26:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=iVM/9UnF35/kR5rXH7t0vTBNLpUgrRrJRZDW9K7ApIg=; b=EvWxmaiWUCOHwYVYoL6s4bIw1loeohF40Zf2Zr9RHke+a2Fn4IMLIbyTYvYtyTM5H7 KSaEnwd99hUhazxiYBFYHSWOTt1y8mlm6xm9ylgs/PFGFqNYKAUB7+8Z79PUKDFHsz7Z ccCGmCsepOgihdW2own5Mb7J29pe/pPi+w7GksCEF+419QxvPM7Jy6iAtBwHzZ8p2mpd 548KMDbHW+rUm1zHG2k5WZqheGX8Y6JutnS4hVSJDMW9jp9U7rmdxQMpcfPjgMzyUbzr MOGNdLDbhIN8/rgr6pZzeEdljJkxE5CEaNadmtFfcfm0fEIwriS922Ul9WK8A6lcwsYa eSeQ== MIME-Version: 1.0 X-Received: by 10.60.40.101 with SMTP id w5mr21544968oek.39.1435685204521; Tue, 30 Jun 2015 10:26:44 -0700 (PDT) Received: by 10.202.203.17 with HTTP; Tue, 30 Jun 2015 10:26:44 -0700 (PDT) In-Reply-To: References: Date: Tue, 30 Jun 2015 13:26:44 -0400 Message-ID: Subject: Re: Migrate table data to another table From: John Sanda To: user Content-Type: multipart/alternative; boundary=089e013cba529ffc360519bf82e6 --089e013cba529ffc360519bf82e6 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable You might want to take a look at CQLSSTableWriter[1] in the Cassandra source tree. http://www.datastax.com/dev/blog/using-the-cassandra-bulk-loader-updated On Tue, Jun 30, 2015 at 1:18 PM, Umut Kocasara=C3=A7 wrote: > Hi, > I want to change clustering order column of my table. As far as i know it > is not possible to use alter command so i have created new table and i > would like to move data from old table to this one. > > I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is > there any easy method to move data except "Copy" command. > > Thanks > > Umut > --=20 - John --089e013cba529ffc360519bf82e6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
You might want to take a look at CQLSSTableWriter[1] in th= e Cassandra source tree.


On Tue, Jun 30, 2015 = at 1:18 PM, Umut Kocasara=C3=A7 <ukocasarac@gmail.com> wr= ote:
Hi,
I want to change clustering order column of my table. As far = as i know it is not possible to use alter command so i have created new tab= le and i would like to move data from old table to this one.

= I am using Cassandra 2.0.7 and there is almost 100GB data on table. Is ther= e any easy method to move data except "Copy" command.

Thanks

Umut



--

- John
--089e013cba529ffc360519bf82e6--