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 andWITH
query chaining- Joins of type: right, full, cross (cartesian)
LIMIT ALL
(specifically theALL
option)UNION
|INTERSECT
|EXCEPT
- GROUPING syntax for:
GROUPING SETS ( ( column [, ...] ) [, ...] )
CUBE ( column [, ...] )
*ROLLUP ( column [, ...] )
CAST
inWHERE
orSELECT
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.
Updated 5 months ago