[ 
https://issues.apache.org/jira/browse/SPARK-46678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated SPARK-46678:
-----------------------------------
    Labels: pull-request-available  (was: )

> Set datanucleus.autoStartMechanismMode=ignored to clean the wall of noisy logs
> ------------------------------------------------------------------------------
>
>                 Key: SPARK-46678
>                 URL: https://issues.apache.org/jira/browse/SPARK-46678
>             Project: Spark
>          Issue Type: Test
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Kent Yao
>            Priority: Major
>              Labels: pull-request-available
>
> {code:java}
> [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 {code}
> Such logs should suppressed



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to