[FEATURE] Calcite Engine Framework: Pushdown scripts

[LantaoJin]

Is your feature request related to a problem?
Framework work of the development feature of Calcite Engine.

What solution would you like?

1. Enable Script Pushdown
2. Eval expression could be pushdown by script pushdown feature.

Adding all duplicated open issues to its sub-issues list.

[qianheng-aws]

Solution we have currently, need POC to verify their feasibility.

---

Option1:
Client: RexNode -> Linq4j Expression -> Compile to Java Code -> Submit Java Code String to Script API
Server: Receive Java Code -> Java Code execution

RPOS: faster when handling big data
CONS: the step of compiling and execution requires more developing effort

---

Option2:
Client: RexNode -> Linq4j Expression -> Kyro serialization -> Submit byte string to Script API
Server: Receive byte string -> deserialize to Linq4j Expression -> invoke the evaluate API of Linq4j Expression

PROS: faster when handling small data, since saving the step of compile
CONS: introduce the dependency of Kyro both in opensearch core and sql plugin.

[model-collapse]

I am voting to a ultimate solution which can adaptively select between option1 and option2 according to the estimation of processing time. For short term, I think we might ASAP adding Kyro to core.