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 05EA176C7 for ; Sun, 11 Dec 2011 08:30:30 +0000 (UTC) Received: (qmail 12490 invoked by uid 500); 11 Dec 2011 08:30:28 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 11972 invoked by uid 500); 11 Dec 2011 08:30:24 -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 11964 invoked by uid 99); 11 Dec 2011 08:30:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 11 Dec 2011 08:30:23 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.83.44] (HELO mail-ee0-f44.google.com) (74.125.83.44) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 11 Dec 2011 08:30:17 +0000 Received: by eeke49 with SMTP id e49so783333eek.31 for ; Sun, 11 Dec 2011 00:29:55 -0800 (PST) Received: by 10.213.10.205 with SMTP id q13mr2653794ebq.119.1323592194906; Sun, 11 Dec 2011 00:29:54 -0800 (PST) Received: from mvapc ([80.179.102.198]) by mx.google.com with ESMTPS id a60sm57655693eeb.4.2011.12.11.00.29.53 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 11 Dec 2011 00:29:54 -0800 (PST) From: "Michael Vaknine" To: References: <001f01ccb575$7fdca730$7f95f590$@com> In-Reply-To: Subject: RE: Schematool Date: Sun, 11 Dec 2011 10:29:49 +0200 Message-ID: <00a701ccb7df$0cf14430$26d3cc90$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A8_01CCB7EF.D07A1430" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acy1jy767c+i7R29Tb+9YER/NmdvigCSEroQ Content-Language: en-us This is a multi-part message in MIME format. ------=_NextPart_000_00A8_01CCB7EF.D07A1430 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I have a keyspace called Index. I am trying to create it when I create a new cluster from the script that was created on the old cluster. create keyspace Index with placement_strategy = 'SimpleStrategy' and strategy_options = {replication_factor : 3 and durable_writes = true; I get an error [default@City] create keyspace Index ... with placement_strategy = 'SimpleStrategy' ... and strategy_options = {replication_factor : 3} ... and durable_writes = true; Syntax error at position 16: mismatched input 'Index' expecting set null My question is Is Index a reserved word? How can I create this keyspace? I tried 'Index' and "Index" but I still get the error and I am not able to create it. Thanks Michael From: Alain RODRIGUEZ [mailto:arodrime@gmail.com] Sent: Thursday, December 08, 2011 11:52 AM To: user@cassandra.apache.org Subject: Re: Schematool You should be able to use the CLI "show schema yourkeyspace" if your cassandra is recent enough ( >= 0.8 if I remember well. I think it is better if you are in 0.8.7 because this command was fixed a couple of times in 8.6 and 8.7). You can put the "show schema" command into a file and call it with : "cassandra-cli -h yourhost -f yourfile > 20111208schema" then open your output file and remove the 2 or 3 useless lines that are written before "create yourkeyspace". Hope this will be helpful. Alain 2011/12/8 Michael Vaknine Hi, Since schematool has been removed from Cassandra is there a way to extract the schema from a working cluster in order to create a new empty cluster? Thanks Michael ------=_NextPart_000_00A8_01CCB7EF.D07A1430 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I have a keyspace called Index.

 

I am trying to create it when I create a new cluster from the script = that was created on the old cluster.

 

create keyspace Index

with placement_strategy =3D 'SimpleStrategy'

and strategy_options =3D {replication_factor : = 3

and durable_writes =3D true;

 

I get an error

 

[default@City] create keyspace Index

...       with placement_strategy =3D = 'SimpleStrategy'

...       and strategy_options =3D = {replication_factor : 3}

...       and durable_writes =3D = true;

Syntax error at position 16: mismatched input 'Index' expecting set = null

 

My question is

Is Index a reserved word?

How can I create this keyspace? I tried 'Index' and "Index" = but I still get the error and I am not able to create = it.

 

Thanks

Michael

 

From:= = Alain RODRIGUEZ [mailto:arodrime@gmail.com]
Sent: Thursday, = December 08, 2011 11:52 AM
To: = user@cassandra.apache.org
Subject: Re: = Schematool

 

You should be able to use the CLI "show schema = yourkeyspace" if your cassandra is recent enough ( >=3D 0.8 if I = remember well. I think it is better if you are in 0.8.7 because this = command was fixed a couple of times in 8.6 and = 8.7).

 

You can put the "show schema" command into a = file and call it with : "cassandra-cli -h yourhost -f yourfile > = 20111208schema" then open your output file and remove the 2 or 3 = useless lines that are written before "create = yourkeyspace".

 

Hope this will be helpful.

 

Alain

 

2011/12/8 Michael Vaknine <michaelv@citypath.com><= /o:p>

Hi,

Since schematool has been = removed from Cassandra is there a way to extract
the schema from a = working cluster in order to create a new empty = cluster?

Thanks
Michael

 

------=_NextPart_000_00A8_01CCB7EF.D07A1430--