This page describes how Pig interoperates with other platforms, such as HBase and Hive.
Pig and Cassandra
Starting with Pig 0.7, there is a LoadStoreFunc for Cassandra. Download the Cassandra src and it's currently in a contrib module (http://issuescassandra.apache.org/jira/browse/CASSANDRA-910A loader for loading Cassandra data into Pig. Works with Pig 0.7.0 (branched but not yet released as of 3/31/2010)download/). Details are found in the readme there. More hadoop support details are found here: http://wiki.apache.org/cassandra/HadoopSupport. A project that looks to ease integration between the two is Pygmalion: https://github.com/jeromatron/pygmalion/.
Pig and HBase
...