Peng Huo

Fix in #449

Thanks for raising the issue! Could you post one example for helping understand the use cases?

Try to upgrade main to 3.0 failed. https://github.com/opensearch-project/sql/pull/831. ``` > Could not find org.apache.lucene:lucene-core:9.4.0-snapshot-ddf0d0a. Searched in the following locations: - file:/home/runner/.m2/repository/org/apache/lucene/lucene-core/9.4.0-snapshot-ddf0d0a/lucene-core-9.4.0-snapshot-ddf0d0a.pom - https://aws.oss.sonatype.org/content/repositories/snapshots/org/apache/lucene/lucene-core/9.4.0-snapshot-ddf0d0a/lucene-core-9.4.0-snapshot-ddf0d0a.pom - https://repo.maven.apache.org/maven2/org/apache/lucene/lucene-core/9.4.0-snapshot-ddf0d0a/lucene-core-9.4.0-snapshot-ddf0d0a.pom ```

* 2.x branch is ready. * main branch is blocked. because of IT failed. https://github.com/opensearch-project/sql/actions/runs/3055823327/jobs/4929313950. Need investigate more, seems breaking change in core.

2.3.1. https://github.com/opensearch-project/sql/pull/894

manifest PR. https://github.com/opensearch-project/opensearch-build/pull/2766

Thanks for reporting issue. Currently we doesn't support use alias in where clause. One workaround should be ``` SELECT dest_city_name AS dc FROM all_flights WHERE dest_city_name IS NOT NULL ```

@ankurgupta4891 In https://github.com/opendistro-for-elasticsearch/sql/issues/1145, you mentioned, "I tried to give simple version of our use case but we need to get alias support with IS NOT NULL" Could you share your...

confirmed offline. Query is auto generated. ## Next Step We need to evaluate the tech solution. The challenge is that SQL statements is analyzed in predefined order of, FROM ->...

Add docs. https://github.com/opensearch-project/sql/pull/777