2013-10-10

Pig, Hive & Cassandra Auth

For Pig, Use the following syntax:
R = LOAD 'cql://username:password@KeySpace/Table' USING CqlStorage();


For Hive, Use the following syntax:
hive> set cassandra.input.keyspace.username=username;
hive> set cassandra.input.keyspace.passwd=password;

Tested on DataStax Enterprise 3.1.3