cassandra: query with index expression doesn't work

Question

I'm trying to get data from Cassandra with this query:

$cf=new ColumnFamily($data->cp,'ips');
$index[]=CassandraUtil::create_index_expression('c',1,'EQ');
$index[]=CassandraUtil::create_index_expression('begin_ip',1599147740,'GTE');
$index[]=CassandraUtil::create_index_expression('end_ip',1599147740,'LTE');
$index_clause = CassandraUtil::create_index_clause($index);
$rows=$cf->get_indexed_slices($index_clause);
foreach($rows AS $key=>$row)
{
    $result[]=$row;
}
var_dump($result);

But the result is null. I'm definitely sure that there is a row in cf ips which absolutely answers this query.

Validation class for all columns is IntegerType.

In cassandra-cli the equal query:

get ips where c = int('1') and 
    begin_ip <= int('1599147740') and
    end_ip >= int('1599147740');

also gets null.

What am I doing wrong?

Answer 1

First, have you created an index on the 'c' column?

Second, you'll need to use 'cassandra_IndexOperator::EQ' and similar for the expression operator instead of a string.