Peng Huo comments

Results 106 comments of


                                            Peng Huo

[BUG] Query with UNION operator fails with NullPointerException

could u share the index mapping. ``` PUT index001/_doc/1 { "query_id" : "1" } PUT index002/_doc/1 { "query_id" : "1" } POST /_plugins/_sql?format=csv { "query": "select query_id from index001 UNION...

[FEATURE]Adding an HTTP GET endpoint for OpenSearch's PPL

+1. Direct Linking to Specific Queries is really usefull.

[BUG] Observability-Metrics fails to render page with Prometheus data source metric selected

@vamsi-amazon please take a look.

[BUG] specifying fetch_size in REST API causes issue with aliases

it is bug in legacy engine(v1) add fetch_size, query execution fallback to legacy engine (v1),

[FEATURE] - Support pagination for PPL and SQL query

relate to https://github.com/opensearch-project/sql/issues/947

Support to use SQL (SQL queries) and PPL to save as reports (then schedule for alerts and use it for dashboard panels)

Questions, what is SFW? Are u propose alerting integration with SQL?

[BUG] simple joins on keywords don't seem to work

this is a bug when handing string with ., https://github.com/opensearch-project/sql/blob/main/legacy/src/main/java/org/opensearch/sql/legacy/utils/StringUtils.java#L93 to migrate the issue, is it possible to remove `.` from index name

[FEATURE] Exclude files in s3 data source

file metadata path is Spark SQL existing feature, no extra grammer change required. for example ``` SELECT _metadata.file_name, count(*) FROM alb_logs WHERE _metadata.file_path like '%2023/11/09%' GROUP BY _metadata.file_name ```

[FEATURE] Handle epoch field in string format

Related to PR, https://github.com/opensearch-project/sql/pull/1664/ Using `strict_date_optional_time||epoch_millis` as default format instead of `""` https://github.com/opensearch-project/sql/pull/1664/files#diff-81e2e0d0405360026791ecce8e594e933fce50f3dc697217003f1b914dc2cff5R166

[FEATURE] Track query state in plugin with calling EMR-S jobRun API

## Queries Journey Based on job types, we categorize queries into three main types: 1. Interactive jobs. e.g. create table 2. Batch jobs. e.g. refresh table 3. Streaming jobs. e.g....