Use functions in PPL


I am trying to implement functions in ppl query to get the desired output, but I get error as result. I am trying to use cast() function in PPL to convert the data type of field for querying purposes, but the execution ends due to “(”.

In the OpenSearch documentation, it is mentioned that PPL plugin supports all SQL functions, but unable to do so.

Can someone please guide me through the issue.

Thank you.

Hi, could you provide the query that is giving you the error?

I also posted an example of cast here that you can take a look CAST function not working on PPL - #2 by joshli

In addition, there is an example us using CAST in the OpenSearch documentation - Commands - OpenSearch documentation