Smile CDR v2024.05.PRE
On this page:

36.4.1SQL Syntax Limitations

 

The following known limitations apply to the HFQL SQL syntax. These limitations are not considered permanent or unsolvable, but were implemented for practical reasons. Please get in touch if you have use cases that they are restricting, or if you would like to help address them.

  • When using GROUP BY expressions, the query will fail if more than 10000 unique values are found to group by.

  • When using ORDER BY expressions, the query will fail if more than 10000 values are found to order by.

36.4.2Syntax Limitations

 
  • Expressions with WHERE clauses do not support parentheses or OR statements, only AND statements.

  • JOIN statements are not supported.

  • Comments are not currently supported