Using SUGGEST and QSUGGEST

General Discussions - English
1

Hi,

I just installed Manticore 2.5.1 and trying out the SUGGEST and QSUGGEST features.

mysql> CALL suggest('humalog ', ‘idx1p0’);
ERROR 1064 (42000): no such builtin procedure SUGGEST

I have a distributed index (idx1p0 is just one of the parts), do I need to use the aggregated index name or each of the parts ?

Any ideas why I am getting this error (no built-in procedure) ?

Thanks
r

2

SUGGEST/QSUGGEST lookup over the dictionary index, right now they only operate on a single index. Maybe add a feature request ( here or make a github ticket) for distributed index support (just like CALL KEYWORDS has now).

Regarding your error, are you sure you connect to Manticore 2.5.1? Maybe you are still connecting to an older version of Sphinx. When 'mysql -Pport -hhost" what does the welcome string says? Does CALL QSUGGEST works?

3

Hi adrian,

I was running 2 instances in some way, following the upgrade to Manticore I still had a few things to fix,
The funny thing was that the welcome string was correct and returned I was running 2.5.1

I will make a feature request

Thanks
r