incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raihan Jamal <jamalrai...@gmail.com>
Subject How to create multiple column families using some script?
Date Thu, 26 Sep 2013 20:18:44 GMT
I have to create Multiple Column Families in my keyspace. One way is to
create the column families one by one.. But in my case, I have around 100
column families so I cannot do it one by one... So is there any way, I can
create multiple column families through some sort of script which can
create multiple column families for me in one short?

    create column family USER_DATA_SECOND_1
    with comparator = 'UTF8Type'
    and key_validation_class = 'CompositeType(DateType,UTF8Type)'
    and default_validation_class = 'BytesType'
    and gc_grace = 86400

    create column family USER_DATA_SECOND_2
    with comparator = 'UTF8Type'
    and key_validation_class = 'CompositeType(DateType,UTF8Type)'
    and default_validation_class = 'BytesType'
    and gc_grace = 86400

    create column family USER_DATA_SECOND_3
    with comparator = 'UTF8Type'
    and key_validation_class = 'CompositeType(DateType,UTF8Type)'
    and default_validation_class = 'BytesType'
    and gc_grace = 86400

    ....
    ....
    ....

    create column family USER_DATA_SECOND_100
    with comparator = 'UTF8Type'
    and key_validation_class = 'CompositeType(DateType,UTF8Type)'
    and default_validation_class = 'BytesType'
    and gc_grace = 86400
And also after creating these multiple column families.. Suppose if I need
to drop all these column families again then how to do that using some
script again?

Below is the way, I am creating the column families now from my local
machine to my staging cassandra server one by one, which is not what I
want..

    C:\Apache Cassandra\apache-cassandra-1.2.3\bin>cassandra-cli -h
sc-cdbhost01.vip.slc.qa.host.com
    Starting Cassandra Client
    Connected to: "Staging Cluster cass01" on
sc-cdbhost01.vip.slc.qa.host.com/9160
    Welcome to Cassandra CLI version 1.2.3

    Type 'help;' or '?' for help.
    Type 'quit;' or 'exit;' to quit.

    [default@unknown] use profileks;
    Authenticated to keyspace: profileks
    [default@profileks] create column family USER_DATA_SECOND_1
    ...     with comparator = 'UTF8Type'
    ...     and key_validation_class = 'CompositeType(DateType,UTF8Type)'
    ...     and default_validation_class = 'BytesType'
    ...     and gc_grace = 86400;
    27fe1848-c7de-3994-9289-486a9bbbf344
    [default@profileks]

Can anyone help me whether this is possible to create multiple column
families through some sort of script and then drop those column families as
well through some sort of script?

Mime
View raw message