All Products
Search
Document Center

OpenSearch:Limits

Last Updated:Aug 21, 2026
  • DDL and DML statements that are not currently supported

  • ORDER BY must be used together with LIMIT

  • SELECT * is not supported when querying a child table with UNNEST

  • JOIN currently runs only on the Searcher node, so you must ensure the data distribution

  • UNION requires that the column names, column types, and number of columns match on both sides

  • Numerical analysis indexes do not support queries with "=". Use an expression such as WHERE QUERY('consign_time', '[1, 10]') instead.