Unclear what functions are implemented by PPL [DOC]

[smacrakis]

What do you want to do?

• [ X] Request a change to existing documentation
• Add new documentation
• Report a technical problem with the documentation
• Other

Tell us about your request. Provide a summary of the request.

The page https://opensearch.org/docs/latest/search-plugins/sql/functions/ has a list of "common functions shared across the SQL and PPL languages". But in fact some of these are not available in PPL, for example: add, divide, expm1, modulus, etc. I don't know if any aren't supported in SQL. It would be good to annotate the list to show which are available in SQL and which in PPL.

Also, the "Example" column shows all the functions called with "SELECT", which only applies to SQL. I suggest removing the "SELECT" keyword.

*Version: List the OpenSearch version to which this issue applies, e.g. 2.14, 2.12--2.14, or all.

2.15

What other resources are available? Provide links to related issues, POCs, steps for testing, etc.

[hdhalter]

Thanks, @smacrakis. Do you know who can help identify which ones are only supported in SQL?

[smacrakis]

I don't know, but Ani (jadhanir@) should know who knows.