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:

    • 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
  • 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.