CQL pushdown filter
Create an index for the Cassandra table.
For Pig pushdown filtering, the secondary index must have the same name as the column it is indexing.
Include the use_secondary option with a value of true in the url format for CqlStorage. The option name reflects the term that used to be used for a Cassandra index: secondary index. For example:
newdata = LOAD 'cql://ks/cf_300000_keys_50_cols?use_secondary=true' USING CqlStorage();