You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by ge...@apache.org on 2024/07/30 20:23:25 UTC
(spark) branch branch-3.5 updated: [SPARK-49054][SQL][3.5] Column default value should support current_* functions
This is an automated email from the ASF dual-hosted git repository.
gengliang pushed a commit to branch branch-3.5
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.5 by this push:
new 268c13e32d07 [SPARK-49054][SQL][3.5] Column default value should support current_* functions
268c13e32d07 is described below
commit 268c13e32d0737cf9f7fc8f61b34dbad7bdeb8e8
Author: Gengliang Wang <ge...@apache.org>
AuthorDate: Tue Jul 30 13:23:09 2024 -0700
[SPARK-49054][SQL][3.5] Column default value should support current_* functions
### What changes were proposed in this pull request?
This is a regression between Spark 3.5.0 and Spark 4.
The following queries work on Spark 3.5.0 while fails on latest master branch:
```
CREATE TABLE test_current_user(i int, s string) USING parquet;
ALTER TABLE test_current_user ALTER COLUMN s SET DEFAULT current_user()
```
```
CREATE TABLE test_current_user(i int, s string default current_user()) USING parquet
INSERT INTO test_current_user (i) VALUES ((0));
```
This PR is to complete fixing this by eagerly executing finish-analysis and constant-folding rules before checking whether the expression is foldable and resolved.
### Why are the changes needed?
Bug fix
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
New UTs
### Was this patch authored or co-authored using generative AI tooling?
No
Closes #47538 from gengliangwang/pickFinishAnlysis.
Authored-by: Gengliang Wang <ge...@apache.org>
Signed-off-by: Gengliang Wang <ge...@apache.org>
---
.../catalyst/util/ResolveDefaultColumnsUtil.scala | 11 +++++++++--
.../spark/sql/ResolveDefaultColumnsSuite.scala | 21 +++++++++++++++++++++
2 files changed, 30 insertions(+), 2 deletions(-)
diff --git a/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/util/ResolveDefaultColumnsUtil.scala b/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/util/ResolveDefaultColumnsUtil.scala
index f55fa2d8f5e8..0d947258e655 100644
--- a/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/util/ResolveDefaultColumnsUtil.scala
+++ b/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/util/ResolveDefaultColumnsUtil.scala
@@ -26,7 +26,7 @@ import org.apache.spark.sql.catalyst.analysis._
import org.apache.spark.sql.catalyst.catalog.{CatalogDatabase, InMemoryCatalog, SessionCatalog}
import org.apache.spark.sql.catalyst.expressions._
import org.apache.spark.sql.catalyst.expressions.{Literal => ExprLiteral}
-import org.apache.spark.sql.catalyst.optimizer.ConstantFolding
+import org.apache.spark.sql.catalyst.optimizer.{ConstantFolding, Optimizer}
import org.apache.spark.sql.catalyst.parser.{CatalystSqlParser, ParseException}
import org.apache.spark.sql.catalyst.plans.logical._
import org.apache.spark.sql.catalyst.trees.TreePattern.PLAN_EXPRESSION
@@ -285,7 +285,9 @@ object ResolveDefaultColumns extends QueryErrorsBase with ResolveDefaultColumnsU
val analyzer: Analyzer = DefaultColumnAnalyzer
val analyzed = analyzer.execute(Project(Seq(Alias(parsed, colName)()), OneRowRelation()))
analyzer.checkAnalysis(analyzed)
- ConstantFolding(analyzed)
+ // Eagerly execute finish-analysis and constant-folding rules before checking whether the
+ // expression is foldable and resolved.
+ ConstantFolding(DefaultColumnOptimizer.FinishAnalysis(analyzed))
} catch {
case ex: AnalysisException =>
throw QueryCompilationErrors.defaultValuesUnresolvedExprError(
@@ -452,6 +454,11 @@ object ResolveDefaultColumns extends QueryErrorsBase with ResolveDefaultColumnsU
new CatalogManager(BuiltInFunctionCatalog, BuiltInFunctionCatalog.v1Catalog)) {
}
+ /**
+ * This is an Optimizer for convert default column expressions to foldable literals.
+ */
+ object DefaultColumnOptimizer extends Optimizer(DefaultColumnAnalyzer.catalogManager)
+
/**
* This is a FunctionCatalog for performing analysis using built-in functions only. It is a helper
* for the DefaultColumnAnalyzer above.
diff --git a/sql/core/src/test/scala/org/apache/spark/sql/ResolveDefaultColumnsSuite.scala b/sql/core/src/test/scala/org/apache/spark/sql/ResolveDefaultColumnsSuite.scala
index 00529559a485..79b2f517b060 100644
--- a/sql/core/src/test/scala/org/apache/spark/sql/ResolveDefaultColumnsSuite.scala
+++ b/sql/core/src/test/scala/org/apache/spark/sql/ResolveDefaultColumnsSuite.scala
@@ -215,4 +215,25 @@ class ResolveDefaultColumnsSuite extends QueryTest with SharedSparkSession {
}
}
}
+
+ test("SPARK-49054: Create table with current_user() default") {
+ val tableName = "test_current_user"
+ val user = spark.sparkContext.sparkUser
+ withTable(tableName) {
+ sql(s"CREATE TABLE $tableName(i int, s string default current_user()) USING parquet")
+ sql(s"INSERT INTO $tableName (i) VALUES ((0))")
+ checkAnswer(sql(s"SELECT * FROM $tableName"), Seq(Row(0, user)))
+ }
+ }
+
+ test("SPARK-49054: Alter table with current_user() default") {
+ val tableName = "test_current_user"
+ val user = spark.sparkContext.sparkUser
+ withTable(tableName) {
+ sql(s"CREATE TABLE $tableName(i int, s string) USING parquet")
+ sql(s"ALTER TABLE $tableName ALTER COLUMN s SET DEFAULT current_user()")
+ sql(s"INSERT INTO $tableName (i) VALUES ((0))")
+ checkAnswer(sql(s"SELECT * FROM $tableName"), Seq(Row(0, user)))
+ }
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org