[FEATURE] Calcite Engine Framework: Support TINYINT/SMALLINT/INT/BIGINT type

[LantaoJin]

Is your feature request related to a problem?
In 3.0.0, we will unified the PPL data types.

What solution would you like?
Introduce the replacement data types as follow.

OpenSearch PPL Data Type	Spark PPL Data Type	Unified PPL Data Type
byte	tinyint	tinyint
short	smallint	smallint
integer	int	int
long	bigint	bigint

Ref #3339

[LantaoJin]

May no change required after #3339 completed, just open this for tracking.

[Swiddis]

Is this resolved by #3342? I see in the diff that it features changes to the OpenSearchTypeFactory.

[LantaoJin]

Is this resolved by #3342? I see in the diff that it features changes to the OpenSearchTypeFactory.

Yes.

sql/core/src/main/java/org/opensearch/sql/calcite/utils/OpenSearchTypeFactory.java

Line 69 in 4ba78d3

public static RelDataType convertExprTypeToRelDataType(ExprType fieldType, boolean nullable) {

is a convertor to convert PPL data type to Calcite Data type. So I think there is no additional effort to support TINYINT/SMALLINT/INT/BIGINT. But we may add more tests to close this issue.