Unsupported SQL Syntax

📘

SELECT Statements

Currently, the ChaosSearch database connection supports only SELECT statements against the Refinery views and content.

The SQL Analytics API does not currently support the following statements or syntax:

• Within the SELECT syntax:

  • WITH clause support and WITH query chaining
  • Joins of type: left, right, full, cross (cartesian)
  • The ALL option used in LIMIT ALL syntax
  • UNION or INTERSECT or EXCEPT
  • GROUPING syntax for:
    • GROUPING SETS ( ( column [, ...] ) [, ...] )
    • CUBE ( column [, ...] )
    • ROLLUP ( column [, ...] )
  • CAST in WHERE or SELECT list
  • [ NULLS { FIRST | LAST } ]
  • [ OFFSET count [ { ROW | ROWS } ] ]
  • approx_distinct()
  • SQL constants such as NOW, CURRENT_DATE, CURRENT_TIME
  • Subquery syntax that uses WHERE EXISTS or WHERE foo IN
  • COUNT DISTINCT alongside other aggregations

• Data manipulation language (DML) commands to change ChaosSearch index data such as INSERT, UPDATE, DELETE statements

• Data definition language (DDL) commands to manage ChaosSearch index-related objects such as views (tables) with ALTER, CREATE, DROP statements

• Stored Procedures, or user-defined functions

• Show command variants such as: SHOW CREATE MATERIALIZED VIEW, SHOW CREATE SCHEMA, SHOW CREATE TABLE, SHOW CREATE VIEW, SHOW FUNCTIONS, SHOW GRANTS, SHOW ROLE GRANTS, SHOW ROLES, SHOW SESSION, SHOW STATS

• For the SHOW columns from view LIKE 'pattern', the pattern filter is not supported.

• The date and time functions current_date, current_time, localtime, and localtimestamp. Note that now() and current_timestamp return epoch timestamps in milliseconds.

• Any functions not listed in the SQL Functions Support Reference

• Any other SQL syntax not specified in these topics.