You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Ramesh Natarajan <ra...@gmail.com> on 2012/01/17 18:51:18 UTC
specifying initial cassandra schema
I usually start cassandra and then use cassandra-cli to import a
schema. Is there any automated way to load a fixed schema when
cassandra starts automatically?
I have a test setup where i run cassandra on a single node. I have a
OS image packaged with cassandra and it automatically starts cassandra
as a part of OS boot up.
I saw some old references to specify schema in cassandra.yaml. Is
this still supported in Cassandra 1.x? Are there any examples?
thanks
Ramesh
Re: specifying initial cassandra schema
Posted by Ramesh Natarajan <ra...@gmail.com>.
Thanks and appreciate the responses. Will look into this.
thanks
Ramesh
On Wed, Jan 18, 2012 at 2:27 AM, aaron morton <aa...@thelastpickle.com> wrote:
> check the command line help for cassandra-cli, you can pass it a file name.
>
> e.g. cassandra --host localhost --file schema.txt
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 18/01/2012, at 9:35 AM, Carlos Pérez Miguel wrote:
>
> Hi Ramesh
>
> You can use the schematool command. I am using it for the same
> purposes in Cassandra 0.7.9.
>
> I use the following line in my cassandra startup script:
>
> $CASSANDRA_HOME/bin/schematool HOSTNAME 8080 import
>
> where HOSTNAME is the hostname of your test machine. It will import
> the schema from your cassandra.yaml file.
> If you execute it and there is already a schema in the cassandra
> cluster, you'll get a exception from schematool but no impact to the
> cluster.
>
> Bye
>
> Carlos Pérez Miguel
>
>
>
> 2012/1/17 Ramesh Natarajan <ra...@gmail.com>:
>
> I usually start cassandra and then use cassandra-cli to import a
>
> schema. Is there any automated way to load a fixed schema when
>
> cassandra starts automatically?
>
>
> I have a test setup where i run cassandra on a single node. I have a
>
> OS image packaged with cassandra and it automatically starts cassandra
>
> as a part of OS boot up.
>
>
> I saw some old references to specify schema in cassandra.yaml. Is
>
> this still supported in Cassandra 1.x? Are there any examples?
>
>
> thanks
>
> Ramesh
>
>
Re: specifying initial cassandra schema
Posted by aaron morton <aa...@thelastpickle.com>.
check the command line help for cassandra-cli, you can pass it a file name.
e.g. cassandra --host localhost --file schema.txt
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 18/01/2012, at 9:35 AM, Carlos Pérez Miguel wrote:
> Hi Ramesh
>
> You can use the schematool command. I am using it for the same
> purposes in Cassandra 0.7.9.
>
> I use the following line in my cassandra startup script:
>
> $CASSANDRA_HOME/bin/schematool HOSTNAME 8080 import
>
> where HOSTNAME is the hostname of your test machine. It will import
> the schema from your cassandra.yaml file.
> If you execute it and there is already a schema in the cassandra
> cluster, you'll get a exception from schematool but no impact to the
> cluster.
>
> Bye
>
> Carlos Pérez Miguel
>
>
>
> 2012/1/17 Ramesh Natarajan <ra...@gmail.com>:
>> I usually start cassandra and then use cassandra-cli to import a
>> schema. Is there any automated way to load a fixed schema when
>> cassandra starts automatically?
>>
>> I have a test setup where i run cassandra on a single node. I have a
>> OS image packaged with cassandra and it automatically starts cassandra
>> as a part of OS boot up.
>>
>> I saw some old references to specify schema in cassandra.yaml. Is
>> this still supported in Cassandra 1.x? Are there any examples?
>>
>> thanks
>> Ramesh
Re: specifying initial cassandra schema
Posted by Carlos Pérez Miguel <cp...@gmail.com>.
Hi Ramesh
You can use the schematool command. I am using it for the same
purposes in Cassandra 0.7.9.
I use the following line in my cassandra startup script:
$CASSANDRA_HOME/bin/schematool HOSTNAME 8080 import
where HOSTNAME is the hostname of your test machine. It will import
the schema from your cassandra.yaml file.
If you execute it and there is already a schema in the cassandra
cluster, you'll get a exception from schematool but no impact to the
cluster.
Bye
Carlos Pérez Miguel
2012/1/17 Ramesh Natarajan <ra...@gmail.com>:
> I usually start cassandra and then use cassandra-cli to import a
> schema. Is there any automated way to load a fixed schema when
> cassandra starts automatically?
>
> I have a test setup where i run cassandra on a single node. I have a
> OS image packaged with cassandra and it automatically starts cassandra
> as a part of OS boot up.
>
> I saw some old references to specify schema in cassandra.yaml. Is
> this still supported in Cassandra 1.x? Are there any examples?
>
> thanks
> Ramesh