cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Bowland <cbowl...@gmail.com>
Subject Writing Data To A Super Column That Is In A Column Family With A Type Of Standard
Date Mon, 05 Mar 2012 03:24:01 GMT
Is it possible to mix both Standard and Super columns in the same
Column Family? One of our Perl developers seems to have this working,
but I have been using the Java Pelops client and have been unable to
make this happen.

I'm not asking how to do with Pelops as I'll bug those guys if it is
possible, but can standard and super columns be mixed in the same
column family?

Here's the script he was using (which looks like he is able to define
a column_type of super for some the columns but not others):

create column family users
    with comparator = UTF8T
    and key_validation_class=UTF8TYpe
    and compression_options = { sstable_compression:SnappyCompressor,
chunk_length_kb:64}
    and column_metadata = [
    { column_name: FirstName, validation_class : UTF8Type},
    { column_name: LastName, validation_class : UTF8Type},
    { column_name: FavStore, validation_class : IntegerType},
    { column_type: super, column_name: HomeAddress
    , column_metadata = [
      { column_name: Street, validation_class : UTF8Type},
      { column_name: State, validation_class : UTF8Type},
      { column_name: Zip, validation_class : LongType} ] },
    { column_type: super, column_name: WorkAddress
    , column_metadata = [
    { column_name: Street, validation_class : UTF8Type},
    { column_name: State, validation_class : UTF8Type},
    { column_name: Zip, validation_class : LongType} ] },
    { column_type: super, column_name: Favorites }
    ];

And here's the CLI output which for the column_types of super
indicates a hash value instead of a scaler.

list users;
Using default limit of 100
-------------------
RowKey: bobjones
=> (column=FavStore, value=59580595188280, timestamp=1330696438)
=> (column=Favorites, value=HASH(0x3618bc0), timestamp=1330696438)
=> (column=FirstName, value=Bob, timestamp=1330696438)
=> (column=HomeAddress, value=HASH(0x3618b30), timestamp=1330696438)
=> (column=LastName, value=Jones, timestamp=1330696438)
=> (column=WorkAddress, value=HASH(0x3619688), timestamp=1330696438)


Thanks in advance.

cb

-- 
Christopher Bowland
cbowland@gmail.com

Mime
View raw message