Yury-Fridlyand

https://github.com/opensearch-project/sql/blob/b244f2e477476567ae70c139550abaa62316a251/opensearch/src/main/java/org/opensearch/sql/opensearch/request/system/OpenSearchDescribeIndexRequest.java#L46-L50 Issues I found there 1. There is no OpenSearch type `text_keyword` ([link](https://opensearch.org/docs/latest/opensearch/supported-field-types/string/)). I think this mapping should be removed and `OPENSEARCH_TEXT_KEYWORD` type should be renamed to `OPENSEARCH_KEYWORD`. 2. Why...

[FEATURE] Support more opensearch data types, like ranges

1

## Is your feature request related to a problem? Some of [OpenSearch data types](https://opensearch.org/docs/latest/opensearch/supported-field-types/index/) are not supported. V2 just ignores columns with them. * Range types: * `integer_range` * `long_range`...

[FEATURE] Add GH workflow which checks for license headers

1

## Is your feature request related to a problem? Developers sometime forget to add a license header to new files. This is not detected automatically. ## What solution would you...

Enhance support for CAST and/or CONVERT functions for more data types

3

**Is your feature request related to a problem? Please describe.** Functions `CAST` and `CONVERT` are not fully supported. A user should be able to convert data between the following types:...

## Is your feature request related to a problem? I discovered that in MySQL some functions' return type depends on arguments' values (not on their types❗) For example, [`DATE_ADD`](https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add) function...

**Is your feature request related to a problem?** In some cases, SQL engine returns very unclear error messages on error. **What solution would you like?** A clear and user-friendly error...

## How can one reproduce the bug? ``` opensearchsql> SELECT CAST(TIMESTAMP('2000-01-02 00:00:00') AS DATETIME); {'reason': 'Invalid SQL query', 'details': '', 'type': 'NullPointerException'} opensearchsql> SELECT CAST('2000-01-02 00:00:00' AS DATETIME); {'reason': 'Invalid...

## What is the bug? Prereq: a function which accepts a `DATE` and `DATETIME` as an argument: ```java private SerializableFunction[] get_date_add_signatures() { return new SerializableFunction[]{ impl(nullMissingHandling(DateTimeFunction::exprAddDateInterval), DATETIME, DATE, INTERVAL), impl(nullMissingHandling(DateTimeFunction::exprAddDateInterval),...

[FEATURE] Add option to specify custom argument description/list

2

## Is your feature request related to a problem? A error returned to user in case if argument(s) are missing or have wrong type(s) is not user-friendly and usually confusing....

## Is your feature request related to a problem? `TIMESTAMPADD` and `TIMESTAMPDIFF` functions [in mysql](https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_timestampadd) have unit as an argument. See also [`EXTRACT`](https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_extract) function. ## What solution would you like?...