sphinx search problem

group by and count doesn't work in sphinx search v 2.0.1B, why?

mysql> select count(*) from my_index group by myattr;
ERROR 1064 (42000)开发者_运维技巧: sphinxql: syntax error, unexpected FROM, expecting IDENT near 'from my_index group by myattr'

just group by without the count works though.

Try this.

select count(*) as cnt from my_index group by myattr;