This is an automated email from the ASF dual-hosted git repository.
dongjoon pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new bfaf9e47b35b [SPARK-46678][TEST] Set
`datanucleus.autoStartMechanismMode=ignored` to clean the wall of noisy logs
bfaf9e47b35b is described below
commit bfaf9e47b35b96be01962cce0670949901e171c3
Author: Kent Yao <y...@apache.org>
AuthorDate: Thu Jan 11 02:54:49 2024 -0800
[SPARK-46678][TEST] Set `datanucleus.autoStartMechanismMode=ignored` to
clean the wall of noisy logs
### What changes were proposed in this pull request?
We set `datanucleus.autoStartMechanismMode=ignored` to clean the wall of
noisy logs in this PR.
### Why are the changes needed?
An individual test in HiveVersionSuite can print a massive wall of logs as
below. Each test file has to be run multiple times in different versions to
make things worse.
```
[info] - 3.1: Decimal support of Avro Hive serde (1 second, 452
milliseconds)
16:20:31.482 ERROR org.apache.spark.sql.execution.command.DDLUtils: Failed
to find data source: avro when check data column names.
org.apache.spark.sql.AnalysisException: Failed to find data source: avro.
Avro is built-in but external data source module since Spark 2.4. Please deploy
the application as per the deployment section of Apache Avro Data Source Guide.
at
org.apache.spark.sql.errors.QueryCompilationErrors$.failedToFindAvroDataSourceError(QueryCompilationErrors.scala:1630)
at
org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:660)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkDataColNames(ddl.scala:1028)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1(ddl.scala:1016)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1$adapted(ddl.scala:1004)
at scala.Option.foreach(Option.scala:437)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkTableColumns(ddl.scala:1004)
00:20:31.485 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.486 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.487 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.489 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.490 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.496 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.497 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.500 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.582 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.583 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.587 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.590 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.591 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.594 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.598 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.599 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.602 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.603 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
[info] - 3.1: read avro file containing decimal (135 milliseconds)
16:20:31.626 ERROR org.apache.spark.sql.execution.command.DDLUtils: Failed
to find data source: avro when check data column names.
org.apache.spark.sql.AnalysisException: Failed to find data source: avro.
Avro is built-in but external data source module since Spark 2.4. Please deploy
the application as per the deployment section of Apache Avro Data Source Guide.
at
org.apache.spark.sql.errors.QueryCompilationErrors$.failedToFindAvroDataSourceError(QueryCompilationErrors.scala:1630)
at
org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:660)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkDataColNames(ddl.scala:1028)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1(ddl.scala:1016)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1$adapted(ddl.scala:1004)
at scala.Option.foreach(Option.scala:437)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkTableColumns(ddl.scala:1004)
00:20:31.630 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.631 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.632 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.634 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.639 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
16:20:31.647 ERROR org.apache.spark.sql.execution.command.DDLUtils: Failed
to find data source: avro when check data column names.
org.apache.spark.sql.AnalysisException: Failed to find data source: avro.
Avro is built-in but external data source module since Spark 2.4. Please deploy
the application as per the deployment section of Apache Avro Data Source Guide.
at
org.apache.spark.sql.errors.QueryCompilationErrors$.failedToFindAvroDataSourceError(QueryCompilationErrors.scala:1630)
at
org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:660)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkDataColNames(ddl.scala:1028)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1(ddl.scala:1016)
at
org.apache.spark.sql.execution.command.DDLUtils$.$anonfun$checkTableColumns$1$adapted(ddl.scala:1004)
at scala.Option.foreach(Option.scala:437)
at
org.apache.spark.sql.execution.command.DDLUtils$.checkTableColumns(ddl.scala:1004)
00:20:31.650 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.651 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.653 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.654 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.655 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.656 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.657 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.660 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.661 WARN org.apache.hadoop.hive.metastore.HiveMetaStore: Location:
file:/Users/hzyaoqin/spark/target/tmp/spark-25540345-5c0e-40aa-9049-ce088ccd77fb/tab1
specified for non-external table:tab1
00:20:31.693 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.695 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.698 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.701 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.703 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:31.705 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.223 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.229 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.232 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.273 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.275 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.282 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.289 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.291 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.294 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.356 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.358 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.361 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.428 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.430 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.433 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.437 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.439 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.441 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.893 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.897 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.950 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.952 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.956 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.963 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.965 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.968 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.970 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.974 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.981 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.982 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:32.985 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.089 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.091 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.094 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.098 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.100 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.102 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.106 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.108 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.111 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.112 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.127 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.128 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.131 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.135 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.137 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.140 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.145 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.146 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.149 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
00:20:33.150 WARN org.apache.hadoop.hive.metastore.ObjectStore:
datanucleus.autoStartMechanismMode is set to unsupported value null . Setting
it to value: ignored
```
### Does this PR introduce _any_ user-facing change?
no
### How was this patch tested?
run HiveVersionSuites locally
```
SPARK_TEST_HIVE_CLIENT_VERSIONS=3.1 ./build/sbt -Phive -Phive-thriftserver
"testOnly *HiveClientSuite*"
```
### Was this patch authored or co-authored using generative AI tooling?
no
Closes #44687 from yaooqinn/minor.
Authored-by: Kent Yao <y...@apache.org>
Signed-off-by: Dongjoon Hyun <dh...@apple.com>
---
.../test/scala/org/apache/spark/sql/hive/client/HiveVersionSuite.scala | 1 +
1 file changed, 1 insertion(+)
diff --git
a/sql/hive/src/test/scala/org/apache/spark/sql/hive/client/HiveVersionSuite.scala
b/sql/hive/src/test/scala/org/apache/spark/sql/hive/client/HiveVersionSuite.scala
index 4cc51064cfdd..9bd731bc3c9c 100644
---
a/sql/hive/src/test/scala/org/apache/spark/sql/hive/client/HiveVersionSuite.scala
+++
b/sql/hive/src/test/scala/org/apache/spark/sql/hive/client/HiveVersionSuite.scala
@@ -35,6 +35,7 @@ private[client] abstract class HiveVersionSuite(version:
String) extends SparkFu
if (version == "2.0" || version == "2.1" || version == "2.2" || version ==
"2.3" ||
version == "3.0" || version == "3.1") {
hadoopConf.set("datanucleus.schema.autoCreateAll", "true")
+ hadoopConf.set("datanucleus.autoStartMechanismMode", "ignored")
hadoopConf.set("hive.metastore.schema.verification", "false")
}
// Since Hive 3.0, HIVE-19310 skipped `ensureDbInit` if
`hive.in.test=false`.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
