Lantao Jin

Why bucket table is not supported in Delta

16

Why bucket table is not supported in Delta? I have implemented bucket table in Delta, includes 1. create a bucket table using delta 2. convert a bucket table to delta...

### Description Remove a duplicated timestamp row in data type mapping table: L93 duplicates L89 ### Issues Resolved [List any issues this PR will resolve] ### Check List - [...

java.lang.NoSuchMethodError: sbt.UpdateConfiguration.copy$default$1()Lscala/Option

1

v0.2.6 sbt package ``` java.lang.NoSuchMethodError: sbt.UpdateConfiguration.copy$default$1()Lscala/Option; at sbt.dependencygraph.DependencyGraphSbtCompat$Implicits$RichUpdateConfiguration$.withMissingOk$extension(DependencyGraphSbtCompat.scala:12) at net.virtualvoid.sbt.graph.DependencyGraphSettings$$anonfun$baseSettings$3.apply(DependencyGraphSettings.scala:40) at net.virtualvoid.sbt.graph.DependencyGraphSettings$$anonfun$baseSettings$3.apply(DependencyGraphSettings.scala:40) at scala.Function1$$anonfun$compose$1.apply(Function1.scala:47) at sbt.EvaluateSettings$MixedNode.evaluate0(INode.scala:175) at sbt.EvaluateSettings$INode.evaluate(INode.scala:135) at sbt.EvaluateSettings$$anonfun$sbt$EvaluateSettings$$submitEvaluate$1.apply$mcV$sp(INode.scala:69) at sbt.EvaluateSettings.sbt$EvaluateSettings$$run0(INode.scala:78) at sbt.EvaluateSettings$$anon$3.run(INode.scala:74) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)...

[BUG] Unsupported function doesn't fail the query when the response format set to CSV or JSON

1

**What is the bug?** When unsupported function is included in a query, current execution engine has to fallback to legacy SQL engine to verify whether the function comes from OpenSearch...

[RFC] Support Percentile in PPL

3

**Is your feature request related to a problem?** This RFC is a part of this issue: https://github.com/opensearch-project/sql/issues/44 Currently, PPL can not answer question with percentile function. For example ``` "source=opensearch_dashboards_sample_data_ecommerce|...

### Description Currently, PPL can not answer question with percentile function. For example ``` "source=opensearch_dashboards_sample_data_ecommerce| stats percentile(taxless_total_price)" ``` returns `Unsupported aggregation function` `PERCENTILE` is a common aggregate function which has...

### Description Support nested aggregation. With this PR, follow SQL are able to exectue a nested aggregation query. ```SQL SELECT min(nested(pages.load_time, pages)) FROM logs WHERE response = 200; ``` And...

**Is your feature request related to a problem?** In order to interact with nested fields in an aggregation, a [nested aggregation](https://opensearch.org/docs/latest/aggregations/bucket/nested/) must be used. OpenSearch DSL query: ``` GET logs/_search...

SQL pagination should work with the `pretty` parameter

5

### Description 1. Refactoring `isSupported()` improves readability by clearly defining each condition and simplifying the overall logic. 2. `PRETTY` (plus `FORMAT`) parameters should be treated as supported in validating `Cursor`...

Union query result should work in JDBC format

2

### Description `Union` query only works with `csv` format, but without the '?format=csv' query parameter at the end of the POST call will throw `NullPointerException`. Reproduce: ``` PUT index001/_doc/1 {...