You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Dmitri Smirnov <ds...@netflix.com> on 2010/11/08 20:21:58 UTC
Describe keyspace output
I have created a CF with the following:
create column family CFam with column_type = 'Super' and comparator =
'LongType' and subcomparator = 'UTF8Type' and comment = 'List of Tests
Super Family' and column_metadata=[{ column_name:cell,
validation_class:IntegerType}, { column_name:'created_by',
validation_class:UTF8Type },{ column_name:'creation_ts',
validation_class : LongType }, { column_name:'enabled', validation_class
: UTF8Type }, { column_name :'subcategory_id', validation_class :
LongType }, { column_name : 'update_ts', validation_class : LongType }]
What is the meaning of 2 lines below:
- Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
- A long is exactly 8 bytes: 4
> describe keyspace Kspace
Keyspace: Kspace:
Replication Factor: 4
Column Families:
ColumnFamily: CFam (Super)
"List of Tests Super Family"
Columns sorted by:
org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
Row cache size / save period: 0.0/0
Key cache size / save period: 200000.0/3600
Memtable thresholds: 1.1203125/239/60
GC grace seconds: 864000
Compaction min/max thresholds: 4/32
Column Metadata:
A long is exactly 8 bytes: 4
--
Dmitri Smirnov
Y!IM: ia_slepukhin
Re: Describe keyspace output
Posted by Jonathan Ellis <jb...@gmail.com>.
The extra line was fixed for http://issues.apache.org/jira/browse/CASSANDRA-1712
On Mon, Nov 8, 2010 at 5:09 PM, Dmitri Smirnov <ds...@netflix.com> wrote:
> On 11/08/2010 11:40 AM, Aaron Morton wrote:
>>
>> Dmitri,
>> Not exactly sure which two lines you are referring to to but...
>>
>> "Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType" - means
>> the column name on the second level of columns in your Super Column Family
>> will be sorted as Long integers.
>
> This is not what I expect because I say comparator = 'LongType' and
> subcomparator = 'UTF8Type'
>
> I think the above is stated in the below line where 2 types are mentioned
> together.
>
> Columns sorted by:
> org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
>
> this, of course, then raises a question about the below line because if
> true, it is not what I specified.
>
> Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
>
> thanks,
> Dmitri
>
>>
>> and "A long is exactly 8 bytes:" Looks like an error thrown when the
>> LongType is trying to convert a value toString(), in this case the value is
>> only 4 bytes long.
>>
>>
>> Were there any error log messages in the server when you ran this?
>>
>> Aaron
>>
>> On 09 Nov, 2010,at 08:21 AM, Dmitri Smirnov <ds...@netflix.com> wrote:
>>
>>> I have created a CF with the following:
>>>
>>> create column family CFam with column_type = 'Super' and comparator =
>>> 'LongType' and subcomparator = 'UTF8Type' and comment = 'List of Tests
>>> Super Family' and column_metadata=[{ column_name:cell,
>>> validation_class:IntegerType}, { column_name:'created_by',
>>> validation_class:UTF8Type },{ column_name:'creation_ts',
>>> validation_class : LongType }, { column_name:'enabled', validation_class
>>> : UTF8Type }, { column_name :'subcategory_id', validation_class :
>>> LongType }, { column_name : 'update_ts', validation_class : LongType }]
>>>
>>> What is the meaning of 2 lines below:
>>>
>>> - Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
>>>
>>> - A long is exactly 8 bytes: 4
>>> > describe keyspace Kspace
>>> Keyspace: Kspace:
>>> Replication Factor: 4
>>> Column Families:
>>> ColumnFamily: CFam (Super)
>>> "List of Tests Super Family"
>>> Columns sorted by:
>>>
>>> org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
>>> Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
>>> Row cache size / save period: 0.0/0
>>> Key cache size / save period: 200000.0/3600
>>> Memtable thresholds: 1.1203125/239/60
>>> GC grace seconds: 864000
>>> Compaction min/max thresholds: 4/32
>>> Column Metadata:
>>> A long is exactly 8 bytes: 4
>>>
>>> --
>>> Dmitri Smirnov
>>> Y!IM: ia_slepukhin
>>>
>
>
> --
> Dmitri Smirnov
> Y!IM: ia_slepukhin
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com
Re: Describe keyspace output
Posted by Dmitri Smirnov <ds...@netflix.com>.
On 11/08/2010 11:40 AM, Aaron Morton wrote:
> Dmitri,
> Not exactly sure which two lines you are referring to to but...
>
> "Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType" -
> means the column name on the second level of columns in your Super
> Column Family will be sorted as Long integers.
This is not what I expect because I say comparator = 'LongType' and
subcomparator = 'UTF8Type'
I think the above is stated in the below line where 2 types are
mentioned together.
Columns sorted by:
org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
this, of course, then raises a question about the below line because if
true, it is not what I specified.
Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
thanks,
Dmitri
>
> and "A long is exactly 8 bytes:" Looks like an error thrown when the
> LongType is trying to convert a value toString(), in this case the
> value is only 4 bytes long.
>
>
> Were there any error log messages in the server when you ran this?
>
> Aaron
>
> On 09 Nov, 2010,at 08:21 AM, Dmitri Smirnov <ds...@netflix.com> wrote:
>
>> I have created a CF with the following:
>>
>> create column family CFam with column_type = 'Super' and comparator =
>> 'LongType' and subcomparator = 'UTF8Type' and comment = 'List of Tests
>> Super Family' and column_metadata=[{ column_name:cell,
>> validation_class:IntegerType}, { column_name:'created_by',
>> validation_class:UTF8Type },{ column_name:'creation_ts',
>> validation_class : LongType }, { column_name:'enabled', validation_class
>> : UTF8Type }, { column_name :'subcategory_id', validation_class :
>> LongType }, { column_name : 'update_ts', validation_class : LongType }]
>>
>> What is the meaning of 2 lines below:
>>
>> - Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
>>
>> - A long is exactly 8 bytes: 4
>> > describe keyspace Kspace
>> Keyspace: Kspace:
>> Replication Factor: 4
>> Column Families:
>> ColumnFamily: CFam (Super)
>> "List of Tests Super Family"
>> Columns sorted by:
>> org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
>> Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
>> Row cache size / save period: 0.0/0
>> Key cache size / save period: 200000.0/3600
>> Memtable thresholds: 1.1203125/239/60
>> GC grace seconds: 864000
>> Compaction min/max thresholds: 4/32
>> Column Metadata:
>> A long is exactly 8 bytes: 4
>>
>> --
>> Dmitri Smirnov
>> Y!IM: ia_slepukhin
>>
--
Dmitri Smirnov
Y!IM: ia_slepukhin
Re: Describe keyspace output
Posted by Aaron Morton <aa...@thelastpickle.com>.
Dmitri,
Not exactly sure which two lines you are referring to to but...
"Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType" - means the column name on the second level of columns in your Super Column Family will be sorted as Long integers.
and "A long is exactly 8 bytes:" Looks like an error thrown when the LongType is trying to convert a value toString(), in this case the value is only 4 bytes long.
Were there any error log messages in the server when you ran this?
Aaron
On 09 Nov, 2010,at 08:21 AM, Dmitri Smirnov <ds...@netflix.com> wrote:
I have created a CF with the following:
create column family CFam with column_type = 'Super' and comparator =
'LongType' and subcomparator = 'UTF8Type' and comment = 'List of Tests
Super Family' and column_metadata=[{ column_name:cell,
validation_class:IntegerType}, { column_name:'created_by',
validation_class:UTF8Type },{ column_name:'creation_ts',
validation_class : LongType }, { column_name:'enabled', validation_class
: UTF8Type }, { column_name :'subcategory_id', validation_class :
LongType }, { column_name : 'update_ts', validation_class : LongType }]
What is the meaning of 2 lines below:
- Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
- A long is exactly 8 bytes: 4
> describe keyspace Kspace
Keyspace: Kspace:
Replication Factor: 4
Column Families:
ColumnFamily: CFam (Super)
"List of Tests Super Family"
Columns sorted by:
org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.UTF8Type
Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
Row cache size / save period: 0.0/0
Key cache size / save period: 200000.0/3600
Memtable thresholds: 1.1203125/239/60
GC grace seconds: 864000
Compaction min/max thresholds: 4/32
Column Metadata:
A long is exactly 8 bytes: 4
--
Dmitri Smirnov
Y!IM: ia_slepukhin