Unsupported SQL Syntax

Review this topic for syntax that is not currently supported for use with SQL Analytics.

📘

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.