ContainsOperator and LikeOperator in cqlengine/operator.py inherit from EqualsOperator. This means the columns using those operators are being used to compute the partition keys. After they don't have to be part of the partition key so they should inherit from BaseWhereOperator
Just realized this is not true, only if the class is equal to EqualsOperator they are used to compute the primary keys not if it inherits.