Skip to content

[FEATURE] Mathematical and Trigonometric functions missing from new V2 engine #1190

@MitchellGale

Description

@MitchellGale

Missing Functions from V2 engine

Syntax from https://opensearch.org/docs/latest/search-plugins/sql/functions/.

Missing:

Can test by adding ifnull(null, true) to where clause which will run query in V2 engine.

opensearchsql> SELECT cosh(0.5) FROM calcs WHERE ifnull(null, true) LIMIT 1;                                                                                                                                                                                
{'reason': 'Invalid SQL query', 'details': 'unsupported method: ifnull', 'type': 'SqlParseException'}

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions