[
https://issues.apache.org/jira/browse/SPARK-32220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
angerszhu updated SPARK-32220:
------------------------------
Description:
{code:java}
spark-sql> select * from test4 order by a asc;
1 2
Time taken: 1.063 seconds, Fetched 4 row(s)20/07/08 14:11:25 INFO
SparkSQLCLIDriver: Time taken: 1.063 seconds, Fetched 4 row(s)
spark-sql>select * from test5 order by a asc
1 2
2 2
Time taken: 1.18 seconds, Fetched 24 row(s)20/07/08 14:13:59 INFO
SparkSQLCLIDriver: Time taken: 1.18 seconds, Fetched 24 row(s)spar
{code}
was:
{code:java}
spark-sql> select * from test1 order by a asc;
1 2
1 4
2 3
3 4
Time taken: 1.063 seconds, Fetched 4 row(s)20/07/08 14:11:25 INFO
SparkSQLCLIDriver: Time taken: 1.063 seconds, Fetched 4 row(s)
spark-sql>select * from test2 order by a asc
1 2
1 3
1 3
2 4
2 5
3 1
4 1
4 5
5 1
5 3
5 4
6 10
6 3
6 8
7 1
7 10
7 11
7 12
7 13
7 15
7 20
7 5
7 8
8 2
Time taken: 1.18 seconds, Fetched 24 row(s)20/07/08 14:13:59 INFO
SparkSQLCLIDriver: Time taken: 1.18 seconds, Fetched 24 row(s)spar
{code}
> Cartesian Product Hint cause data error
> ---------------------------------------
>
> Key: SPARK-32220
> URL: https://issues.apache.org/jira/browse/SPARK-32220
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: angerszhu
> Priority: Major
>
> {code:java}
> spark-sql> select * from test4 order by a asc;
> 1 2
> Time taken: 1.063 seconds, Fetched 4 row(s)20/07/08 14:11:25 INFO
> SparkSQLCLIDriver: Time taken: 1.063 seconds, Fetched 4 row(s)
> spark-sql>select * from test5 order by a asc
> 1 2
> 2 2
> Time taken: 1.18 seconds, Fetched 24 row(s)20/07/08 14:13:59 INFO
> SparkSQLCLIDriver: Time taken: 1.18 seconds, Fetched 24 row(s)spar
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
