InvalidRequest Error from server code 2200 Invalid query message Cannot execute this query as it might involve data filtering and thus may have unpredictable performance

Question

Hi Guys,

I am trying to fetch table from cassandra, but it shows me the below error.

$ select * from University.student where dept='ECE';
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot execute this query as it might involve data filtering and thus may have unpredictable performance. If you want to execute this query despite the performance unpredictability, use ALLOW FILTERING"

Can someone help me?
Thank You

Answer 1

Hi@akhtar,

You are trying to filter data from your table, but in cassandra you need index for that column. Without index, you can't able to filter that column.

Here is the command given bellow to create index of a particular column.

$ create index IndexName on University.student(dept);
$ select * from University.student where dept='ECE'; 

Follow the above steps, it will work.

Thank You