SQL support

更新时间:
复制 MD 格式

OpenSearch supports SQL query statements for data retrieval and analysis, and provides user-defined functions (UDFs), user-defined aggregate functions (UDAFs), and table-valued functions (TVFs) to extend SQL capabilities.

Function overview

  • SQL query statements fetch, process, and analyze data from relational databases. The modular syntax supports data filtering, joins, aggregation, and sorting. For more information about SQL query syntax and its limitations, see SQL query statement syntax.

  • User-defined functions extend SQL capabilities by encapsulating complex logic for reuse. For more information about UDFs, UDAFs, and TVFs in OpenSearch, see User-defined functions.