Hello,
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@127.0.0.1:9306/pilot/pil_assets’;
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.
Thanks,
Laurent