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 D790C10255 for ; Fri, 27 Sep 2013 16:06:20 +0000 (UTC) Received: (qmail 48374 invoked by uid 500); 27 Sep 2013 16:06:16 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 48310 invoked by uid 500); 27 Sep 2013 16:06:14 -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 47980 invoked by uid 99); 27 Sep 2013 16:06:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Sep 2013 16:06:12 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of y2klyf@gmail.com designates 209.85.217.169 as permitted sender) Received: from [209.85.217.169] (HELO mail-lb0-f169.google.com) (209.85.217.169) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Sep 2013 16:06:07 +0000 Received: by mail-lb0-f169.google.com with SMTP id z5so2461362lbh.28 for ; Fri, 27 Sep 2013 09:05:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:date:message-id:subject:from:to:content-type; bh=tD/7ZGgzcZ4R8MhkGURnxEGke1Rosw1geec+8HLCuHg=; b=zEFADQ5ld++t6I+53Kd0XvA1YBx8WJkpxpv8f+RFQuahSUDg2WD6+kBo6aqlOzJTS0 J7CStHtzmfrWvJtjmauQ40JuRztovgjVb/JjJ8yWWugmMwZq1oUaugnRlXUv411fknFk MOGEz2kn49AfRgWgGCaScvYzUmu9zjgCxmr7NacN4ZVSdI01bFPHcRXQ4RhdIIUgwDD/ nG8rtYdRxa/17qsQdfL4HpcKlC4Uae33gd662PJSrlCjud/qSyVAwun2cjajCjspjy/z HX2Pp5njsYu9r5u+NWbHrRR7V/KwHZZT5Z+/nBnl31OOB0iq1wAtQ58xURi2XMqUIE6m DLSw== MIME-Version: 1.0 X-Received: by 10.152.10.99 with SMTP id h3mr6245065lab.13.1380297944278; Fri, 27 Sep 2013 09:05:44 -0700 (PDT) Sender: y2klyf@gmail.com Received: by 10.114.28.134 with HTTP; Fri, 27 Sep 2013 09:05:44 -0700 (PDT) Date: Fri, 27 Sep 2013 09:05:44 -0700 X-Google-Sender-Auth: xby4OnJujCaSPWZVOwely9KI7co Message-ID: Subject: changing the primary key type of a table From: Jimmy Lin To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a1132f26aa72a9f04e75fa8a2 X-Virus-Checked: Checked by ClamAV on apache.org --001a1132f26aa72a9f04e75fa8a2 Content-Type: text/plain; charset=ISO-8859-1 hi, we have a table that its primary key is uuid type. Now we decide that we need to use text type as it is more flexible for our application. #1 is there any downside using text as primary key? any performance impact on the partition ? #2 There is no way to alter a table's primary key with a cql command, that is what i have read, migrating to a new table seems to be the only way. Is there any good recommendation how to do this? cqlsh copy or jsonsttable seems like will all result in same datatype as before. thanks --001a1132f26aa72a9f04e75fa8a2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
hi,
we have a table that its primary key=A0= is uuid type. Now we decide that we need to use text type as it is more fle= xible for our application.
=A0
#1
is there an= y downside using text as primary key? any performance impact on the partiti= on ?=A0
=A0
#2
There is no way to alter a table's prim= ary key with a cql command, that is what i have read, migrating to a new ta= ble seems to be the only way.
Is there any good recommendation ho= w to do this? cqlsh copy or jsonsttable seems like will all result in same = datatype as before.
=A0
thanks
=A0
--001a1132f26aa72a9f04e75fa8a2--