Andrew Carbonetto

@dharminfadia I'm unable to reproduce your scenario. Here's the query that I attempted: ``` opensearchsql> SELECT time1 as rawdate, timestamp(time1) as newdate from calcs; fetched rows / total rows =...

@dharminfadia you can use timestamp to convert a date to a timestamp. You need to explicitly convert dates to timestamps since the parser doesn't do any automatic conversion/casting. ``` SELECT...

@dai-chen @penghuo @GabeFernandez310 has pushed changes to the parser to accommodate index names that included non-SQL characters: https://github.com/Bit-Quill/opensearch-project-sql/pull/128 The current strategy uses state to save whether we're in a FROM...

@Shivacharangoud would you be able to provide the data or the response to the above queries and I can take a look?

note: also support `{d }`, `{dt }`, and `{t }` formats from ODFE driver

@dai-chen this issue can be closed as part of https://github.com/opensearch-project/sql/pull/1456 We now accept any field with `__` or `_` so long as the field is not reserved by OpenSearch.

We can include metadata fields in the parser language as part of this ticket and hardcode the field types in the expression analyzer. This will also work to fix the...

@dai-chen this issue can be closed as part of https://github.com/opensearch-project/sql/pull/1456

Closing this. Only bug remaining is the timezone issue: https://github.com/opensearch-project/sql/issues/1874

I know this is merged, but it seems to be causing fatal errors on the darwin-arm64-tar builds when running on m1 macs. ``` » ERROR][o.o.b.OpenSearchUncaughtExceptionHandler] [runTask-0] fatal error in thread...