incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: what tool will create noncql columnfamilies in cassandra 3a
Date Wed, 05 Feb 2014 13:57:55 GMT
I agree having two tools is no good. I ended up discussing this in the IRC
channel for a bit yesterday for this column family.



   1. create column family BrowserStuff
   2.   with column_type = 'Standard'
   3.   and comparator = 'UTF8Type'
   4.   and default_validation_class = 'UTF8Type'
   5.   and key_validation_class = 'UTF8Type'
   6.   and read_repair_chance = 0.2
   7.   and dclocal_read_repair_chance = 0.0
   8.   and populate_io_cache_on_flush = false
   9.   and gc_grace = 259200
   10.   and min_compaction_threshold = 4
   11.   and max_compaction_threshold = 32
   12.   and replicate_on_write = false
   13.   and compaction_strategy =
   'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
   14.   and caching = 'KEYS_ONLY'
   15.   and column_metadata = [
   16.     {column_name : 'st',
   17.     validation_class : UTF8Type},
   18.     {column_name : 'tld',
   19.     validation_class : IntegerType},
   20.     {column_name : 'lst',
   21.     validation_class : IntegerType},
   22.     {column_name : 'conn',
   23.     validation_class : IntegerType},
   24.     {column_name : 'ua',
   25.     validation_class : UTF8Type},
   26.     {column_name : 'dma',
   27.     validation_class : IntegerType},
   28.     {column_name : 'fst',
   29.     validation_class : IntegerType},
   30.     {column_name : 'zc',
   31.     validation_class : UTF8Type},
   32.     {column_name : 'co',
   33.     validation_class : UTF8Type},
   34.     {column_name : 'nc',
   35.     validation_class : IntegerType}]
   36.   and compression_options = {'chunk_length_kb' : '64',
   'sstable_compression' : 'org.apache.cassandra.io.compress.SnappyCompressor'
   };

AFAIK there is no way to create this EXACT column family definition from
CQL. CQL is missing a way to specify key_validation_class = 'UTF8Type'.
Asking users to create this column family from thrift is annoying. (I will
open a jira when I have time.)





On Wed, Feb 5, 2014 at 4:57 AM, Sylvain Lebresne <sylvain@datastax.com>wrote:

> > Cassandra 2.0.4 cli is informing me that it will no longer exist in the
> next major.
>
> I know you meant 3.0 by "next major" but just for the sake of not confusing
> anyone reading, the current plan is to remove the cassandra-cli in
> Cassandra
> 3.0 which will not be the next major release (the next major will be 2.1)
> but
> the one after that.
>
> > How will users adjust the meta data of non cql column families
>
> The rational for removing cassandra-cli is mainly that maintaining 2 fully
> featured command line interface is a waste of the project resources in the
> long
> run. It's just a tool using the thrift interface however and you'll still
> be
> able to adjust metadata through the thrift interface as before. As Patricia
> mentioned, there is even some existing interactive options like
> pycassaShell
> in the community.
>
> On top of that, for most day-to-day modifications (compaction strategy,
> compression options, caching, gc_grace, ...), cqlsh is as convenient as
> would the cli even for Thrift only users.
>
> --
> Sylvain
>
>
> On Wed, Feb 5, 2014 at 3:35 AM, Patricia Gorla <patricia@thelastpickle.com
> > wrote:
>
>> I am also curious as to how users will manage Thrift-based tables without
>> the cli.
>>
>> PyCassaShell comes to mind, as does using Thrift-based clients.
>>
>>
>> On Tue, Feb 4, 2014 at 9:53 AM, Edward Capriolo <edlinuxguru@gmail.com>wrote:
>>
>>> Cassandra 2.0.4 cli is informing me that it will no longer exist in the
>>> next major.
>>>
>>> How will users adjust the meta data of non cql column families and other
>>> cfs that do not fit into the cql model?
>>>
>>> --
>>> Sorry this was sent from mobile. Will do less grammar and spell check
>>> than usual.
>>>
>>
>>
>>
>> --
>> Patricia Gorla
>> @patriciagorla
>>
>> Consultant
>> Apache Cassandra Consulting
>> http://www.thelastpickle.com <http://thelastpickle.com>
>>
>
>

Mime
View raw message