IS NOT NULL with alias throws SemanticCheckException

[ankurgupta4891]

Using IS NOT NULL with alias throws SemanticCheckException.

Example query:

SELECT dest_city_name AS dc
FROM all_flights
WHERE dc IS NOT NULL

Error:

Caused by: org.opensearch.jdbc.protocol.http.HttpException: HTTP Code: 400. Message: Bad Request. Raw response received: {
  "error": {
    "reason": "Invalid SQL query",
    "details": "can't resolve Symbol(namespace=FIELD_NAME, name=dc) in type env",
    "type": "SemanticCheckException"
  },
  "status": 400
}

[penghuo]

Could you try this?

SELECT dest_city_name AS dc
FROM all_flights
WHERE dest_city_name IS NOT NULL

dc is output symbol, only symbol defined in all_flights visible to SQL engine when analyze WHERE statement, so exception throw.

[anirudha]

@ankurgupta4891 pls create issues in this repo : https://github.com/opensearch-project/sql

[ankurgupta4891]

@anirudha I created this issue under opensearch-project/sql repo -> opensearch-project/sql#292

@penghuo Yes it works when I use actual symbol name. I tried to give simple version of our use case but we need to get alias support with IS NOT NULL check. Is it not possible to process output symbol to get actual symbol?