SphinxQL reference

SphinxQL is our SQL dialect that exposes all of the search daemon functionality using a standard SQL syntax with a few Manticore-specific extensions. Everything available via the SphinxAPI is also available via SphinxQL but not vice versa; for instance, writes into RT indexes are only available via SphinxQL. This chapter documents supported SphinxQL statements syntax.

• ALTER syntax
• ATTACH INDEX syntax
• BEGIN, COMMIT, and ROLLBACK syntax
• BEGIN syntax
• CALL KEYWORDS syntax
• CALL QSUGGEST syntax
• CALL SNIPPETS syntax
• CALL SUGGEST syntax
• Comment syntax
• CREATE FUNCTION syntax
• CREATE PLUGIN syntax
• DELETE syntax
• DESCRIBE syntax
• DROP FUNCTION syntax
• DROP PLUGIN syntax
• FLUSH ATTRIBUTES syntax
• FLUSH HOSTNAMES syntax
• FLUSH LOGS syntax
• FLUSH RAMCHUNK syntax
• FLUSH RTINDEX syntax
• INSERT and REPLACE syntax
• List of SphinxQL reserved keywords
• Multi-statement queries
• OPTIMIZE INDEX syntax
• RELOAD INDEX syntax
• RELOAD INDEXES syntax
• RELOAD PLUGINS syntax
• REPLACE syntax
• ROLLBACK syntax
• SELECT syntax
  • Column list
  • EXIST()
  • SNIPPET()
  • REMOVE_REPEATS()
  • FROM
  • WHERE
  • GROUP BY
  • GROUP_CONCAT()
  • ZONESPANLIST()
  • WITHIN GROUP ORDER BY
  • HAVING
  • ORDER BY
  • LIMIT
  • OPTION
  • FACET
  • Subselects
• SELECT @@system_variable syntax
• SET syntax
• SET TRANSACTION syntax
• SHOW AGENT STATUS
• SHOW CHARACTER SET syntax
• SHOW COLLATION syntax
• SHOW DATABASES syntax
• SHOW INDEX SETTINGS syntax
• SHOW INDEX STATUS syntax
• SHOW META syntax
• SHOW PLAN syntax
• SHOW PLUGINS syntax
• SHOW PROFILE syntax
• SHOW STATUS syntax
• SHOW TABLES syntax
• SHOW THREADS syntax
• SHOW VARIABLES syntax
• SHOW WARNINGS syntax
• TRUNCATE RTINDEX syntax
• UPDATE syntax