LuciferYang commented on PR #46580: URL: https://github.com/apache/spark/pull/46580#issuecomment-2137364776
there are new failing cases in `SQLQueryTestSuite` and `ThriftServerQueryTestSuite ` after this one is merged into branch-3.5: - ThriftServerQueryTestSuite : https://github.com/apache/spark/actions/runs/9273419348/job/25513506718 ``` [info] - identifier-clause.sql *** FAILED *** (2 seconds, 408 milliseconds) [info] "" did not contain "Exception" Exception did not match for query #96 [info] create table identifier('t2') as (select my_col from (values (1), (2), (1) as (my_col)) group by 1), expected: , but got: java.sql.SQLException [info] org.apache.hive.service.cli.HiveSQLException: Error running query: [NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT] org.apache.spark.sql.AnalysisException: [NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT] CREATE Hive TABLE (AS SELECT) is not supported, if you want to enable it, please set "spark.sql.catalogImplementation" to "hive".; [info] 'CreateTable `spark_catalog`.`default`.`t2`, ErrorIfExists [info] +- Aggregate [my_col#20215], [my_col#20215] [info] +- SubqueryAlias __auto_generated_subquery_name [info] +- SubqueryAlias as [info] +- LocalRelation [my_col#20215] [info] [info] at org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors$.runningQueryError(HiveThriftServerErrors.scala:43) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org$apache$spark$sql$hive$thriftserver$SparkExecuteStatementOperation$$execute(SparkExecuteStatementOperation.scala:262) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2$$anon$3.$anonfun$run$2(SparkExecuteStatementOperation.scala:166) [info] at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) [info] at org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties(SparkOperation.scala:79) [info] at org.apache.spark.sql.hive.thriftserver.SparkOperation.withLocalProperties$(SparkOperation.scala:63) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.withLocalProperties(SparkExecuteStatementOperation.scala:41) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2$$anon$3.run(SparkExecuteStatementOperation.scala:166) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2$$anon$3.run(SparkExecuteStatementOperation.scala:161) [info] at java.security.AccessController.doPrivileged(Native Method) [info] at javax.security.auth.Subject.doAs(Subject.java:422) [info] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1878) [info] at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$$anon$2.run(SparkExecuteStatementOperation.scala:175) [info] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [info] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [info] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [info] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [info] at java.lang.Thread.run(Thread.java:750) [info] Caused by: org.apache.spark.sql.AnalysisException: [NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT] CREATE Hive TABLE (AS SELECT) is not supported, if you want to enable it, please set "spark.sql.catalogImplementation" to "hive".; [info] 'CreateTable `spark_catalog`.`default`.`t2`, ErrorIfExists [info] +- Aggregate [my_col#20215], [my_col#20215] [info] +- SubqueryAlias __auto_generated_subquery_name [info] +- SubqueryAlias as [info] +- LocalRelation [my_col#20215] ``` - SQLQueryTestSuite : https://github.com/apache/spark/actions/runs/9273419348/job/25513508812 ``` [info] - identifier-clause.sql *** FAILED *** (1 second, 208 milliseconds) [info] identifier-clause.sql [info] Expected "[]", but got "[org.apache.spark.sql.catalyst.ExtendedAnalysisException [info] { [info] "errorClass" : "NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT", [info] "messageParameters" : { [info] "cmd" : "CREATE Hive TABLE (AS SELECT)" [info] } [info] }]" Result did not match for query #96 [info] create table identifier('t2') as (select my_col from (values (1), (2), (1) as (my_col)) group by 1) (SQLQueryTestSuite.scala:876) ``` cc @nikolamand-db @cloud-fan -- 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]
