Peng Huo

### Requirements: * EMR-S application associate with the session could be upgraded. * Upgrade should not impact running/waiting interactive query. * Upgrade should not impact streaming query. ### Opt-1 Client...

* close session * list sessions * recovery session

Add session and statement state for all query types

2

### Description 1. create session and statement for all the queryType. ### Issues Resolved https://github.com/opensearch-project/sql/issues/2401 ### Check List - [x] New functionality includes testing. - [ ] All tests pass,...

**Is your feature request related to a problem?** In https://github.com/opensearch-project/sql/blob/main/docs/user/interfaces/asyncqueryinterface.rst#async-query-interface-endpoints [Async Query Cancellation API](https://github.com/opensearch-project/sql/blob/main/docs/user/interfaces/asyncqueryinterface.rst#id5) If security plugin is enabled, this API can only be invoked by users with permission `cluster:admin/opensearch/ql/jobs/delete`....

**Is your feature request related to a problem?** https://github.com/opensearch-project/opensearch-spark/issues/324 **What solution would you like?** Submit interactive and streaming query separately with different spark.dynamicAllocation.maxExecutors configurations. **What alternatives have you considered?** n/a...

**What is the bug?** Reporting CSV does not work when indices is in remote cluster **Why reporting failed?** Reporting required mapping and setting of index to generate CSV file. But...

### **1.1. Current State** OpenSearch SQL currently faces several challenges. Notably, there is no comprehensive OpenSearch SQL specification, causing discrepancies with the widely-adopted Spark SQL. This lack of standardization hampers...

[BUG] DROP INDEX cancel FlintREPL job

1

**What is the bug?** User submit DROP INDEX query, plugin cancel FlintREPL job. The imapct is if user submit query in same session, submitted query will in waiting state forever....

[BUG] COUNT with aggregation return multiple rows with null value

2

**What is the bug?** curl --request POST \ --url http://localhost:9200/_plugins/_sql?format=jdbc \ --header 'content-type: application/json' \ --data '{"query": "select count(*) from test00001 where status != 200"}' the result include multiple rows...

[Feature Request] Support BloomFilter field type in OpenSearch

10

### Descriptioin The feature request is to support the Bloom Filter field type to optimize index storage. The use case for this feature is to create skipping indexes for raw...