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;