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.