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:

  • SELECT COUNT(DISTINCT(column)) -- COUNT(DISTINCT()) is not yet supported.
  • WITH clause support and WITH query chaining
  • Joins of type: right, full, cross (cartesian)
  • LIMIT ALL (specifically the ALL option)
  • UNION | INTERSECT | 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

• 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, user-defined functions

• SHOW FUNCTIONS

• Any other SQL syntax not specified in these topics.