Migrate from SPHINX Engine to FEDERATED


I created a table in mysql linked to one index in Manticore:

id int(10) unsigned NOT NULL,
year int(11) NOT NULL,
rating float DEFAULT NULL,
query varchar(1024) NOT NULL,
KEY query (query)
) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CONNECTION=‘mysql://root@’;

where pil_assets is my index.

When I try to do a query I am getting the following error:

The table data couldn’t be loaded presumably due to used filter clause.

MySQL said: There was a problem processing the query on the foreign data source. Data source error: error: 1064 'index pil_assets: parse error: P09: syntax error

I am not sure where to go from there. I am trying to replace the sphinx engine that works pretty well for FEDERATED engine.