guixiaowen opened a new pull request, #46243:
URL: https://github.com/apache/spark/pull/46243
### What changes were proposed in this pull request?
I am doing Hive SQL to switch to Spark SQL.
In Hive SQL
hive> explain select *,row_number() over (partition by day) rn from
testdb.zeropart_db;
OK
Explain
In Spark SQL
spark-sql> explain select *,row_number() over (partition by age ) rn from
testdb.zeropart_db;
plan
== Physical Plan ==
org.apache.spark.sql.AnalysisException: Window function row_number()
requires window to be ordered, please add ORDER BY clause. For example SELECT
row_number()(value_expr) OVER (PARTITION BY window_partition ORDER BY
window_ordering) from table
Time taken: 0.172 seconds, Fetched 1 row(s)
For better compatibility with migration. For better compatibility with
migration, new parameters are added to ensure compatibility with the same
behavior as Hive SQL
### Why are the changes needed?
For better compatibility with migration.
### Does this PR introduce _any_ user-facing change?
before this pr：
spark-sql> explain select *,row_number() over (partition by age ) rn from
testdb.zeropart_db;
plan
== Physical Plan ==
org.apache.spark.sql.AnalysisException: Window function row_number()
requires window to be ordered, please add ORDER BY clause. For example SELECT
row_number()(value_expr) OVER (PARTITION BY window_partition ORDER BY
window_ordering) from table
Time taken: 0.172 seconds, Fetched 1 row(s)
after this pr：
spark-sql> explain select *,row_number() over (partition by age ) rn from
testdb.zeropart_db;
plan
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=false
+- Window [row_number() windowspecdefinition(age#37, age#37 ASC NULLS FIRST,
specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS
rn#30], [age#37], [age#37 ASC NULLS FIRST]
+- Sort [age#37 ASC NULLS FIRST, age#37 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(age#37, 1000), ENSURE_REQUIREMENTS,
[id=#53]
+- Scan hive testdb.zeropart_db [age#37, sex#38, name#39, day#40],
HiveTableRelation [`bigdata_qa`.`zeropart_db`,
org.apache.hadoop.hive.ql.io.orc.OrcSerde, Data Cols: [age#37, sex#38,
name#39], Partition Cols: [day#40]]
Time taken: 0.154 seconds, Fetched 1 row(s)
### How was this patch tested?
<!--
If tests were added, say they were added here. Please make sure to add some
test cases that check the changes thoroughly including negative and positive
cases if possible.
If it was tested in a way different from regular unit tests, please clarify
how you tested step by step, ideally copy and paste-able, so that other
reviewers can test and check, and descendants can verify in the future.
If tests were not added, please describe why they were not added and/or why
it was difficult to add.
If benchmark tests were added, please run the benchmarks in GitHub Actions
for the consistent environment, and the instructions could accord to:
https://spark.apache.org/developer-tools.html#github-workflow-benchmarks.
-->
### Was this patch authored or co-authored using generative AI tooling?
<!--
If generative AI tooling has been used in the process of authoring this
patch, please include the
phrase: 'Generated-by: ' followed by the name of the tool and its version.
If no, write 'No'.
Please refer to the [ASF Generative Tooling
Guidance](https://www.apache.org/legal/generative-tooling.html) for details.
-->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
