I thought I read somewhere that Pig has an output format that can write
to Cassandra but I am unable to find any documentation on this. Is this
possible and if so can someone please point me in the right direction.
Thanks

Yes. https://issues.apache.org/jira/browse/CASSANDRA-910 It seems it
was released in Cassandra 0.6

Ashutosh
On Thu, Mar 10, 2011 at 20:17, Mark <[EMAIL PROTECTED]> wrote:
> I thought I read somewhere that Pig has an output format that can write to
> Cassandra but I am unable to find any documentation on this. Is this
> possible and if so can someone please point me in the right direction.
> Thanks
>

Replying on here too since I noticed it was sent to the pig user list as well...

The pig output to cassandra was part of recently resolved CASSANDRA-1828.  It's usable and separate so you should be able to download 0.7-branch and build the jar and use it against a 0.7.3 cluster.  I've been using it against a 0.7.2 cluster.

http://svn.apache.org/repos/asf/cassandra/branches/cassandra-0.7/

To use it, check out the readme in the contrib/pig directory in the 0.7 branch.  One trivial example of copying one column family to another is:

rows = LOAD 'cassandra://Keyspace1/Standard1' USING CassandraStorage();
STORE rows INTO 'cassandra://Keyspace1/Standard2' USING CassandraStorage();

using the contrib/pig/pig_cassandra script (tx to brandon for that example).  Also make sure that Standard2 exists too.

If you have any other questions talk to jeromatron (me), driftx (brandon), or mvdir (eldon) in #cassandra or #hadoop-pig on IRC on freenode.

On Mar 10, 2011, at 10:17 PM, Mark wrote:

> I thought I read somewhere that Pig has an output format that can write to Cassandra but I am unable to find any documentation on this. Is this possible and if so can someone please point me in the right direction. Thanks