Inserting SuperColumns from Java

["matthew@mustardgrain.com" <ma...@mustardgrain.com>]

Hello,
I'm working on a project in Java using Cassandra, and I'm trying to 
implement SuperColumns into the program. The problem is that I really 
don't know how to insert a SuperColumn into Cassandra. I can create the 
SuperColumn with the list of Columns but I really don't know where to go 
from there:       

        Column ageColumn = new Column("age".getBytes(), 
ageString.getBytes(), timestamp);
        Column emailAddressColumn = new Column("email".getBytes(), 
emailAddress.getBytes(), timestamp);
        Column firstNameColumn = new Column("firstName".getBytes(), 
firstName.getBytes(), timestamp);
        Column lastNameColumn = new Column("lastName".getBytes(), 
lastName.getBytes(), timestamp);
        List<Column> userColumnList = new ArrayList<Column>();
        userColumnList.add(ageColumn);
        userColumnList.add(emailAddressColumn);
        userColumnList.add(firstNameColumn);
        userColumnList.add(lastNameColumn);
        SuperColumn userInfo = new SuperColumn("user".getBytes(), 
userColumnList);

After this code I have an insert method, but at the moment the only 
thing I can get it to do with the SuperColumn is take the list and loop 
through and insert each of them:

      for (Column c : columnList) {
            ColumnPath cp = new ColumnPath(getColumnFamily(), 
superColumn.getBytes(), c.getName());
            client.insert("Keyspace1", id, cp, c.value, timestamp, 
ConsistencyLevel.ONE);
       }

I'm new at Cassandra so for all I know I'm barking up the wrong tree, 
but I'm trying to avoid making multiple calls to Cassandra to insert one 
atomic value. The goal for me is to have the values for a User inserted 
at once to avoid performance issues and data corruption.

Thanks,
    Matthew.

Re: Inserting SuperColumns from Java

[Jonathan Ellis <jb...@gmail.com>]

use batch_insert when you are inserting more than one simple column at a time.

On Fri, Dec 11, 2009 at 5:39 PM, matthew@mustardgrain.com
<ma...@mustardgrain.com> wrote:
> Hello,
> I'm working on a project in Java using Cassandra, and I'm trying to
> implement SuperColumns into the program. The problem is that I really don't
> know how to insert a SuperColumn into Cassandra. I can create the
> SuperColumn with the list of Columns but I really don't know where to go
> from there:
>       Column ageColumn = new Column("age".getBytes(), ageString.getBytes(),
> timestamp);
>       Column emailAddressColumn = new Column("email".getBytes(),
> emailAddress.getBytes(), timestamp);
>       Column firstNameColumn = new Column("firstName".getBytes(),
> firstName.getBytes(), timestamp);
>       Column lastNameColumn = new Column("lastName".getBytes(),
> lastName.getBytes(), timestamp);
>       List<Column> userColumnList = new ArrayList<Column>();
>       userColumnList.add(ageColumn);
>       userColumnList.add(emailAddressColumn);
>       userColumnList.add(firstNameColumn);
>       userColumnList.add(lastNameColumn);
>       SuperColumn userInfo = new SuperColumn("user".getBytes(),
> userColumnList);
>
> After this code I have an insert method, but at the moment the only thing I
> can get it to do with the SuperColumn is take the list and loop through and
> insert each of them:
>
>     for (Column c : columnList) {
>           ColumnPath cp = new ColumnPath(getColumnFamily(),
> superColumn.getBytes(), c.getName());
>           client.insert("Keyspace1", id, cp, c.value, timestamp,
> ConsistencyLevel.ONE);
>      }
>
> I'm new at Cassandra so for all I know I'm barking up the wrong tree, but
> I'm trying to avoid making multiple calls to Cassandra to insert one atomic
> value. The goal for me is to have the values for a User inserted at once to
> avoid performance issues and data corruption.
>
> Thanks,
>   Matthew.
>