Guian Gumpac

Enable ignored and disabled tests

1

### Description - Enabled ignored and disabled tests. - Created https://github.com/opensearch-project/sql/issues/922, https://github.com/opensearch-project/sql/issues/917, https://github.com/opensearch-project/sql/issues/912, https://github.com/opensearch-project/sql/issues/910 and attached them to disabled tests for traceability. - Removed irrelevant tests. ### Check List -...

[BUG] Test project_source_change_type_env should throw a SemanticCheckException

5

**What is the bug?** The test project_source_change_type_env does not throw a SemanticCheckException. **How can one reproduce the bug?** Steps to reproduce the behavior: 1. Run the test `project_source_change_type_env` in https://github.com/opensearch-project/sql/blob/2.x/core/src/test/java/org/opensearch/sql/analysis/AnalyzerTest.java...

**What is the bug?** JDBC version is hardcoded in multiple places. **How can one reproduce the bug?** Steps to reproduce the behavior: 1. Go to https://github.com/opensearch-project/sql/blob/2.x/sql-jdbc/src/main/java/org/opensearch/jdbc/internal/Version.java 2. Go to https://github.com/opensearch-project/sql/blob/2.x/sql-jdbc/build.gradle...

**What is the bug?** Failing legacy integration tests may need fixing. **How can one reproduce the bug?** Steps to reproduce the behavior: 1. Run the tests below and see failures:...

**What is the bug?** The test aggregation_cant_merge_indexScan_with_project fails when it is enabled. **How can one reproduce the bug?** Steps to reproduce the behavior: 1. Run the test `aggregation_cant_merge_indexScan_with_project` in https://github.com/opensearch-project/sql/blob/2.x/opensearch/src/test/java/org/opensearch/sql/opensearch/planner/logical/OpenSearchLogicOptimizerTest.java...

[BUG] Analyzer should report error for mismatch between select and group by items

1

**What is the bug?** Analyzer does not report a SemanticCheckException when there is a mismatch between select and group by items. **How can one reproduce the bug?** Steps to reproduce...

Support geopoint type for Tableau

1

### Description Supports geo_point by adding properties for lat and lon in order for Tableau/Power BI to access locations. This PR will only support the format `{"lat": number, "lon": number}`....