cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Inserting SuperColumns from Java
Date Sat, 12 Dec 2009 00:27:46 GMT
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
<matthew@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.
>

Mime
View raw message