lordk911 opened a new issue, #5236: URL: https://github.com/apache/kyuubi/issues/5236
### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) ### Search before asking - [X] I have searched in the [issues](https://github.com/apache/kyuubi/issues?q=is%3Aissue) and found no similar issues. ### Describe the bug 1、kyuubi1.7.1 、kyuubi-extension-spark-3-3_2.12-1.7.1.jar (download from maven)、spark 3.3.3 2、insert into ... select ... statment 3、if I user AQE and KyuubiSparkSQLExtension, the Exchange node is RoundRobinPartitioning, and shuffle write data size expand very large, I finally cancel the query <img width="470" alt="image" src="https://github.com/apache/kyuubi/assets/19989300/fb6a5215-db86-4e56-b546-a5c70ffb6de4";> 4、if I not use KyuubiSparkSQLExtension <img width="387" alt="image" src="https://github.com/apache/kyuubi/assets/19989300/038b7de7-c602-4bb1-b781-ebe707ffb4f0";> 5、I'm I get the wrong way to use KyuubiSparkSQLExtension? ### Affects Version(s) 1.7.1 ### Kyuubi Server Log Output _No response_ ### Kyuubi Engine Log Output _No response_ ### Kyuubi Server Configurations _No response_ ### Kyuubi Engine Configurations ```yaml ##AQE Adaptive Query Execution spark.sql.adaptive.enabled true spark.sql.adaptive.forceApply false spark.sql.adaptive.logLevel info spark.sql.adaptive.advisoryPartitionSizeInBytes 256m spark.sql.adaptive.coalescePartitions.enabled true spark.sql.adaptive.coalescePartitions.minPartitionNum 1 spark.sql.adaptive.coalescePartitions.initialPartitionNum 2000 spark.sql.adaptive.fetchShuffleBlocksInBatch true spark.sql.adaptive.localShuffleReader.enabled true spark.sql.adaptive.skewJoin.enabled true spark.sql.adaptive.skewJoin.skewedPartitionFactor 5 spark.sql.adaptive.skewJoin.skewedPartitionThresholdInBytes 400MB spark.sql.adaptive.nonEmptyPartitionRatioForBroadcastJoin 0.2 spark.sql.adaptive.autoBroadcastJoinThreshold 100MB spark.sql.adaptive.maxShuffledHashJoinLocalMapThreshold 400MB spark.sql.autoBroadcastJoinThreshold -1 #spark.sql.extensions org.apache.kyuubi.plugin.spark.authz.ranger.RangerSparkExtension,org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions,org.apache.kyuubi.sql.KyuubiSparkSQLExtension spark.sql.extensions org.apache.kyuubi.plugin.spark.authz.ranger.RangerSparkExtension,org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions ``` ### Additional context _No response_ ### Are you willing to submit PR? - [ ] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix. - [ ] No. I cannot submit a PR at this time. -- 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]
