IF YOU ARE A CLIENT LIBRARY WRITER please update this list as your libraries become compatible with the newest version of cassandra.
For older Thrift clients, see ClientOptionsThrift.
The StorageProxy API is available to JVM-based clients, but unless you really know that you need it you should probably be using a higher-level client listed above or, failing that, the Thrift API. The StorageProxy API is intended for internal use, and highly specialized use-cases.
Running Hadoop map/reduce jobs in Cassandra is described in HadoopSupport.