I am new in sphinx and mysql and trying to execute simple query as shown below
sql_query = \
(SELECT users.id AS uid, \
CONCAT_WS(' ', users.fname, users.lname, users.email) AS data \
FROM users) \
UNION ALL \
(SELECT documents.id AS diid, documents.description \
FROM documents);
But I am getting below error CONCAT_WS on indexing command
ERROR: unknown key name 'CONCAT_WS' in /etc/sphinxsearch/sphinx.conf line 12 col 26. FATAL: failed to parse config file '/etc/sphinxsearch/sphinx.conf'