You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by li...@apache.org on 2017/08/31 16:16:30 UTC
spark git commit: [SPARK-21878][SQL][TEST] Create SQLMetricsTestUtils
Repository: spark
Updated Branches:
refs/heads/master 964b507c7 -> 19b0240d4
[SPARK-21878][SQL][TEST] Create SQLMetricsTestUtils
## What changes were proposed in this pull request?
Creates `SQLMetricsTestUtils` for the utility functions of both Hive-specific and the other SQLMetrics test cases.
Also, move two SQLMetrics test cases from sql/hive to sql/core.
## How was this patch tested?
N/A
Author: gatorsmile <ga...@gmail.com>
Closes #19092 from gatorsmile/rewriteSQLMetrics.
Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/19b0240d
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/19b0240d
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/19b0240d
Branch: refs/heads/master
Commit: 19b0240d42f81008d918e7a67cb17647bca1500b
Parents: 964b507
Author: gatorsmile <ga...@gmail.com>
Authored: Thu Aug 31 09:16:26 2017 -0700
Committer: gatorsmile <ga...@gmail.com>
Committed: Thu Aug 31 09:16:26 2017 -0700
----------------------------------------------------------------------
.../sql/execution/metric/SQLMetricsSuite.scala | 151 +----------
.../execution/metric/SQLMetricsTestUtils.scala | 270 +++++++++++++++++++
.../sql/hive/execution/SQLMetricsSuite.scala | 106 +-------
3 files changed, 277 insertions(+), 250 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/spark/blob/19b0240d/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsSuite.scala
----------------------------------------------------------------------
diff --git a/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsSuite.scala b/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsSuite.scala
index fd79323..0dc612e 100644
--- a/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsSuite.scala
+++ b/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsSuite.scala
@@ -19,99 +19,21 @@ package org.apache.spark.sql.execution.metric
import java.io.File
-import scala.collection.mutable.HashMap
import scala.util.Random
import org.apache.spark.SparkFunSuite
-import org.apache.spark.scheduler.{SparkListener, SparkListenerTaskEnd}
import org.apache.spark.sql._
import org.apache.spark.sql.catalyst.plans.logical.LocalRelation
-import org.apache.spark.sql.execution.SparkPlanInfo
-import org.apache.spark.sql.execution.ui.SparkPlanGraph
import org.apache.spark.sql.functions._
import org.apache.spark.sql.internal.SQLConf
import org.apache.spark.sql.test.SharedSQLContext
import org.apache.spark.util.{AccumulatorContext, JsonProtocol}
-class SQLMetricsSuite extends SparkFunSuite with SharedSQLContext {
+class SQLMetricsSuite extends SparkFunSuite with SQLMetricsTestUtils with SharedSQLContext {
import testImplicits._
/**
- * Call `df.collect()` and collect necessary metrics from execution data.
- *
- * @param df `DataFrame` to run
- * @param expectedNumOfJobs number of jobs that will run
- * @param expectedNodeIds the node ids of the metrics to collect from execution data.
- */
- private def getSparkPlanMetrics(
- df: DataFrame,
- expectedNumOfJobs: Int,
- expectedNodeIds: Set[Long],
- enableWholeStage: Boolean = false): Option[Map[Long, (String, Map[String, Any])]] = {
- val previousExecutionIds = spark.sharedState.listener.executionIdToData.keySet
- withSQLConf("spark.sql.codegen.wholeStage" -> enableWholeStage.toString) {
- df.collect()
- }
- sparkContext.listenerBus.waitUntilEmpty(10000)
- val executionIds =
- spark.sharedState.listener.executionIdToData.keySet.diff(previousExecutionIds)
- assert(executionIds.size === 1)
- val executionId = executionIds.head
- val jobs = spark.sharedState.listener.getExecution(executionId).get.jobs
- // Use "<=" because there is a race condition that we may miss some jobs
- // TODO Change it to "=" once we fix the race condition that missing the JobStarted event.
- assert(jobs.size <= expectedNumOfJobs)
- if (jobs.size == expectedNumOfJobs) {
- // If we can track all jobs, check the metric values
- val metricValues = spark.sharedState.listener.getExecutionMetrics(executionId)
- val metrics = SparkPlanGraph(SparkPlanInfo.fromSparkPlan(
- df.queryExecution.executedPlan)).allNodes.filter { node =>
- expectedNodeIds.contains(node.id)
- }.map { node =>
- val nodeMetrics = node.metrics.map { metric =>
- val metricValue = metricValues(metric.accumulatorId)
- (metric.name, metricValue)
- }.toMap
- (node.id, node.name -> nodeMetrics)
- }.toMap
- Some(metrics)
- } else {
- // TODO Remove this "else" once we fix the race condition that missing the JobStarted event.
- // Since we cannot track all jobs, the metric values could be wrong and we should not check
- // them.
- logWarning("Due to a race condition, we miss some jobs and cannot verify the metric values")
- None
- }
- }
-
- /**
- * Call `df.collect()` and verify if the collected metrics are same as "expectedMetrics".
- *
- * @param df `DataFrame` to run
- * @param expectedNumOfJobs number of jobs that will run
- * @param expectedMetrics the expected metrics. The format is
- * `nodeId -> (operatorName, metric name -> metric value)`.
- */
- private def testSparkPlanMetrics(
- df: DataFrame,
- expectedNumOfJobs: Int,
- expectedMetrics: Map[Long, (String, Map[String, Any])]): Unit = {
- val optActualMetrics = getSparkPlanMetrics(df, expectedNumOfJobs, expectedMetrics.keySet)
- optActualMetrics.map { actualMetrics =>
- assert(expectedMetrics.keySet === actualMetrics.keySet)
- for (nodeId <- expectedMetrics.keySet) {
- val (expectedNodeName, expectedMetricsMap) = expectedMetrics(nodeId)
- val (actualNodeName, actualMetricsMap) = actualMetrics(nodeId)
- assert(expectedNodeName === actualNodeName)
- for (metricName <- expectedMetricsMap.keySet) {
- assert(expectedMetricsMap(metricName).toString === actualMetricsMap(metricName))
- }
- }
- }
- }
-
- /**
* Generates a `DataFrame` by filling randomly generated bytes for hash collision.
*/
private def generateRandomBytesDF(numRows: Int = 65535): DataFrame = {
@@ -570,75 +492,12 @@ class SQLMetricsSuite extends SparkFunSuite with SharedSQLContext {
assert(res3 === (10L, 0L, 10L) :: (30L, 0L, 30L) :: (0L, 30L, 300L) :: (0L, 300L, 0L) :: Nil)
}
}
-}
-
-object InputOutputMetricsHelper {
- private class InputOutputMetricsListener extends SparkListener {
- private case class MetricsResult(
- var recordsRead: Long = 0L,
- var shuffleRecordsRead: Long = 0L,
- var sumMaxOutputRows: Long = 0L)
- private[this] val stageIdToMetricsResult = HashMap.empty[Int, MetricsResult]
-
- def reset(): Unit = {
- stageIdToMetricsResult.clear()
- }
-
- /**
- * Return a list of recorded metrics aggregated per stage.
- *
- * The list is sorted in the ascending order on the stageId.
- * For each recorded stage, the following tuple is returned:
- * - sum of inputMetrics.recordsRead for all the tasks in the stage
- * - sum of shuffleReadMetrics.recordsRead for all the tasks in the stage
- * - sum of the highest values of "number of output rows" metric for all the tasks in the stage
- */
- def getResults(): List[(Long, Long, Long)] = {
- stageIdToMetricsResult.keySet.toList.sorted.map { stageId =>
- val res = stageIdToMetricsResult(stageId)
- (res.recordsRead, res.shuffleRecordsRead, res.sumMaxOutputRows)
- }
- }
-
- override def onTaskEnd(taskEnd: SparkListenerTaskEnd): Unit = synchronized {
- val res = stageIdToMetricsResult.getOrElseUpdate(taskEnd.stageId, MetricsResult())
-
- res.recordsRead += taskEnd.taskMetrics.inputMetrics.recordsRead
- res.shuffleRecordsRead += taskEnd.taskMetrics.shuffleReadMetrics.recordsRead
-
- var maxOutputRows = 0L
- for (accum <- taskEnd.taskMetrics.externalAccums) {
- val info = accum.toInfo(Some(accum.value), None)
- if (info.name.toString.contains("number of output rows")) {
- info.update match {
- case Some(n: Number) =>
- if (n.longValue() > maxOutputRows) {
- maxOutputRows = n.longValue()
- }
- case _ => // Ignore.
- }
- }
- }
- res.sumMaxOutputRows += maxOutputRows
- }
+ test("writing data out metrics: parquet") {
+ testMetricsNonDynamicPartition("parquet", "t1")
}
- // Run df.collect() and return aggregated metrics for each stage.
- def run(df: DataFrame): List[(Long, Long, Long)] = {
- val spark = df.sparkSession
- val sparkContext = spark.sparkContext
- val listener = new InputOutputMetricsListener()
- sparkContext.addSparkListener(listener)
-
- try {
- sparkContext.listenerBus.waitUntilEmpty(5000)
- listener.reset()
- df.collect()
- sparkContext.listenerBus.waitUntilEmpty(5000)
- } finally {
- sparkContext.removeSparkListener(listener)
- }
- listener.getResults()
+ test("writing data out metrics with dynamic partition: parquet") {
+ testMetricsDynamicPartition("parquet", "parquet", "t1")
}
}
http://git-wip-us.apache.org/repos/asf/spark/blob/19b0240d/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsTestUtils.scala
----------------------------------------------------------------------
diff --git a/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsTestUtils.scala b/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsTestUtils.scala
new file mode 100644
index 0000000..3966e98
--- /dev/null
+++ b/sql/core/src/test/scala/org/apache/spark/sql/execution/metric/SQLMetricsTestUtils.scala
@@ -0,0 +1,270 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.spark.sql.execution.metric
+
+import java.io.File
+
+import scala.collection.mutable.HashMap
+
+import org.apache.spark.scheduler.{SparkListener, SparkListenerTaskEnd}
+import org.apache.spark.sql.DataFrame
+import org.apache.spark.sql.catalyst.TableIdentifier
+import org.apache.spark.sql.execution.SparkPlanInfo
+import org.apache.spark.sql.execution.ui.SparkPlanGraph
+import org.apache.spark.sql.test.SQLTestUtils
+import org.apache.spark.util.Utils
+
+
+trait SQLMetricsTestUtils extends SQLTestUtils {
+
+ import testImplicits._
+
+ /**
+ * Get execution metrics for the SQL execution and verify metrics values.
+ *
+ * @param metricsValues the expected metric values (numFiles, numPartitions, numOutputRows).
+ * @param func the function can produce execution id after running.
+ */
+ private def verifyWriteDataMetrics(metricsValues: Seq[Int])(func: => Unit): Unit = {
+ val previousExecutionIds = spark.sharedState.listener.executionIdToData.keySet
+ // Run the given function to trigger query execution.
+ func
+ spark.sparkContext.listenerBus.waitUntilEmpty(10000)
+ val executionIds =
+ spark.sharedState.listener.executionIdToData.keySet.diff(previousExecutionIds)
+ assert(executionIds.size == 1)
+ val executionId = executionIds.head
+
+ val executionData = spark.sharedState.listener.getExecution(executionId).get
+ val executedNode = executionData.physicalPlanGraph.nodes.head
+
+ val metricsNames = Seq(
+ "number of written files",
+ "number of dynamic part",
+ "number of output rows")
+
+ val metrics = spark.sharedState.listener.getExecutionMetrics(executionId)
+
+ metricsNames.zip(metricsValues).foreach { case (metricsName, expected) =>
+ val sqlMetric = executedNode.metrics.find(_.name == metricsName)
+ assert(sqlMetric.isDefined)
+ val accumulatorId = sqlMetric.get.accumulatorId
+ val metricValue = metrics(accumulatorId).replaceAll(",", "").toInt
+ assert(metricValue == expected)
+ }
+
+ val totalNumBytesMetric = executedNode.metrics.find(_.name == "bytes of written output").get
+ val totalNumBytes = metrics(totalNumBytesMetric.accumulatorId).replaceAll(",", "").toInt
+ assert(totalNumBytes > 0)
+ }
+
+ protected def testMetricsNonDynamicPartition(
+ dataFormat: String,
+ tableName: String): Unit = {
+ withTable(tableName) {
+ Seq((1, 2)).toDF("i", "j")
+ .write.format(dataFormat).mode("overwrite").saveAsTable(tableName)
+
+ val tableLocation =
+ new File(spark.sessionState.catalog.getTableMetadata(TableIdentifier(tableName)).location)
+
+ // 2 files, 100 rows, 0 dynamic partition.
+ verifyWriteDataMetrics(Seq(2, 0, 100)) {
+ (0 until 100).map(i => (i, i + 1)).toDF("i", "j").repartition(2)
+ .write.format(dataFormat).mode("overwrite").insertInto(tableName)
+ }
+ assert(Utils.recursiveList(tableLocation).count(_.getName.startsWith("part-")) == 2)
+ }
+ }
+
+ protected def testMetricsDynamicPartition(
+ provider: String,
+ dataFormat: String,
+ tableName: String): Unit = {
+ withTempPath { dir =>
+ spark.sql(
+ s"""
+ |CREATE TABLE $tableName(a int, b int)
+ |USING $provider
+ |PARTITIONED BY(a)
+ |LOCATION '${dir.toURI}'
+ """.stripMargin)
+ val table = spark.sessionState.catalog.getTableMetadata(TableIdentifier(tableName))
+ assert(table.location == makeQualifiedPath(dir.getAbsolutePath))
+
+ val df = spark.range(start = 0, end = 40, step = 1, numPartitions = 1)
+ .selectExpr("id a", "id b")
+
+ // 40 files, 80 rows, 40 dynamic partitions.
+ verifyWriteDataMetrics(Seq(40, 40, 80)) {
+ df.union(df).repartition(2, $"a")
+ .write
+ .format(dataFormat)
+ .mode("overwrite")
+ .insertInto(tableName)
+ }
+ assert(Utils.recursiveList(dir).count(_.getName.startsWith("part-")) == 40)
+ }
+ }
+
+ /**
+ * Call `df.collect()` and collect necessary metrics from execution data.
+ *
+ * @param df `DataFrame` to run
+ * @param expectedNumOfJobs number of jobs that will run
+ * @param expectedNodeIds the node ids of the metrics to collect from execution data.
+ */
+ protected def getSparkPlanMetrics(
+ df: DataFrame,
+ expectedNumOfJobs: Int,
+ expectedNodeIds: Set[Long],
+ enableWholeStage: Boolean = false): Option[Map[Long, (String, Map[String, Any])]] = {
+ val previousExecutionIds = spark.sharedState.listener.executionIdToData.keySet
+ withSQLConf("spark.sql.codegen.wholeStage" -> enableWholeStage.toString) {
+ df.collect()
+ }
+ sparkContext.listenerBus.waitUntilEmpty(10000)
+ val executionIds =
+ spark.sharedState.listener.executionIdToData.keySet.diff(previousExecutionIds)
+ assert(executionIds.size === 1)
+ val executionId = executionIds.head
+ val jobs = spark.sharedState.listener.getExecution(executionId).get.jobs
+ // Use "<=" because there is a race condition that we may miss some jobs
+ // TODO Change it to "=" once we fix the race condition that missing the JobStarted event.
+ assert(jobs.size <= expectedNumOfJobs)
+ if (jobs.size == expectedNumOfJobs) {
+ // If we can track all jobs, check the metric values
+ val metricValues = spark.sharedState.listener.getExecutionMetrics(executionId)
+ val metrics = SparkPlanGraph(SparkPlanInfo.fromSparkPlan(
+ df.queryExecution.executedPlan)).allNodes.filter { node =>
+ expectedNodeIds.contains(node.id)
+ }.map { node =>
+ val nodeMetrics = node.metrics.map { metric =>
+ val metricValue = metricValues(metric.accumulatorId)
+ (metric.name, metricValue)
+ }.toMap
+ (node.id, node.name -> nodeMetrics)
+ }.toMap
+ Some(metrics)
+ } else {
+ // TODO Remove this "else" once we fix the race condition that missing the JobStarted event.
+ // Since we cannot track all jobs, the metric values could be wrong and we should not check
+ // them.
+ logWarning("Due to a race condition, we miss some jobs and cannot verify the metric values")
+ None
+ }
+ }
+
+ /**
+ * Call `df.collect()` and verify if the collected metrics are same as "expectedMetrics".
+ *
+ * @param df `DataFrame` to run
+ * @param expectedNumOfJobs number of jobs that will run
+ * @param expectedMetrics the expected metrics. The format is
+ * `nodeId -> (operatorName, metric name -> metric value)`.
+ */
+ protected def testSparkPlanMetrics(
+ df: DataFrame,
+ expectedNumOfJobs: Int,
+ expectedMetrics: Map[Long, (String, Map[String, Any])]): Unit = {
+ val optActualMetrics = getSparkPlanMetrics(df, expectedNumOfJobs, expectedMetrics.keySet)
+ optActualMetrics.foreach { actualMetrics =>
+ assert(expectedMetrics.keySet === actualMetrics.keySet)
+ for (nodeId <- expectedMetrics.keySet) {
+ val (expectedNodeName, expectedMetricsMap) = expectedMetrics(nodeId)
+ val (actualNodeName, actualMetricsMap) = actualMetrics(nodeId)
+ assert(expectedNodeName === actualNodeName)
+ for (metricName <- expectedMetricsMap.keySet) {
+ assert(expectedMetricsMap(metricName).toString === actualMetricsMap(metricName))
+ }
+ }
+ }
+ }
+}
+
+
+object InputOutputMetricsHelper {
+ private class InputOutputMetricsListener extends SparkListener {
+ private case class MetricsResult(
+ var recordsRead: Long = 0L,
+ var shuffleRecordsRead: Long = 0L,
+ var sumMaxOutputRows: Long = 0L)
+
+ private[this] val stageIdToMetricsResult = HashMap.empty[Int, MetricsResult]
+
+ def reset(): Unit = {
+ stageIdToMetricsResult.clear()
+ }
+
+ /**
+ * Return a list of recorded metrics aggregated per stage.
+ *
+ * The list is sorted in the ascending order on the stageId.
+ * For each recorded stage, the following tuple is returned:
+ * - sum of inputMetrics.recordsRead for all the tasks in the stage
+ * - sum of shuffleReadMetrics.recordsRead for all the tasks in the stage
+ * - sum of the highest values of "number of output rows" metric for all the tasks in the stage
+ */
+ def getResults(): List[(Long, Long, Long)] = {
+ stageIdToMetricsResult.keySet.toList.sorted.map { stageId =>
+ val res = stageIdToMetricsResult(stageId)
+ (res.recordsRead, res.shuffleRecordsRead, res.sumMaxOutputRows)
+ }
+ }
+
+ override def onTaskEnd(taskEnd: SparkListenerTaskEnd): Unit = synchronized {
+ val res = stageIdToMetricsResult.getOrElseUpdate(taskEnd.stageId, MetricsResult())
+
+ res.recordsRead += taskEnd.taskMetrics.inputMetrics.recordsRead
+ res.shuffleRecordsRead += taskEnd.taskMetrics.shuffleReadMetrics.recordsRead
+
+ var maxOutputRows = 0L
+ for (accum <- taskEnd.taskMetrics.externalAccums) {
+ val info = accum.toInfo(Some(accum.value), None)
+ if (info.name.toString.contains("number of output rows")) {
+ info.update match {
+ case Some(n: Number) =>
+ if (n.longValue() > maxOutputRows) {
+ maxOutputRows = n.longValue()
+ }
+ case _ => // Ignore.
+ }
+ }
+ }
+ res.sumMaxOutputRows += maxOutputRows
+ }
+ }
+
+ // Run df.collect() and return aggregated metrics for each stage.
+ def run(df: DataFrame): List[(Long, Long, Long)] = {
+ val spark = df.sparkSession
+ val sparkContext = spark.sparkContext
+ val listener = new InputOutputMetricsListener()
+ sparkContext.addSparkListener(listener)
+
+ try {
+ sparkContext.listenerBus.waitUntilEmpty(5000)
+ listener.reset()
+ df.collect()
+ sparkContext.listenerBus.waitUntilEmpty(5000)
+ } finally {
+ sparkContext.removeSparkListener(listener)
+ }
+ listener.getResults()
+ }
+}
http://git-wip-us.apache.org/repos/asf/spark/blob/19b0240d/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/SQLMetricsSuite.scala
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/SQLMetricsSuite.scala b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/SQLMetricsSuite.scala
index 24c0385..022cb71 100644
--- a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/SQLMetricsSuite.scala
+++ b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/SQLMetricsSuite.scala
@@ -17,112 +17,10 @@
package org.apache.spark.sql.hive.execution
-import java.io.File
-
-import org.apache.spark.sql.catalyst.TableIdentifier
-import org.apache.spark.sql.functions._
+import org.apache.spark.sql.execution.metric.SQLMetricsTestUtils
import org.apache.spark.sql.hive.test.TestHiveSingleton
-import org.apache.spark.sql.test.SQLTestUtils
-import org.apache.spark.util.Utils
-
-class SQLMetricsSuite extends SQLTestUtils with TestHiveSingleton {
- import spark.implicits._
-
- /**
- * Get execution metrics for the SQL execution and verify metrics values.
- *
- * @param metricsValues the expected metric values (numFiles, numPartitions, numOutputRows).
- * @param func the function can produce execution id after running.
- */
- private def verifyWriteDataMetrics(metricsValues: Seq[Int])(func: => Unit): Unit = {
- val previousExecutionIds = spark.sharedState.listener.executionIdToData.keySet
- // Run the given function to trigger query execution.
- func
- spark.sparkContext.listenerBus.waitUntilEmpty(10000)
- val executionIds =
- spark.sharedState.listener.executionIdToData.keySet.diff(previousExecutionIds)
- assert(executionIds.size == 1)
- val executionId = executionIds.head
-
- val executionData = spark.sharedState.listener.getExecution(executionId).get
- val executedNode = executionData.physicalPlanGraph.nodes.head
-
- val metricsNames = Seq(
- "number of written files",
- "number of dynamic part",
- "number of output rows")
-
- val metrics = spark.sharedState.listener.getExecutionMetrics(executionId)
-
- metricsNames.zip(metricsValues).foreach { case (metricsName, expected) =>
- val sqlMetric = executedNode.metrics.find(_.name == metricsName)
- assert(sqlMetric.isDefined)
- val accumulatorId = sqlMetric.get.accumulatorId
- val metricValue = metrics(accumulatorId).replaceAll(",", "").toInt
- assert(metricValue == expected)
- }
-
- val totalNumBytesMetric = executedNode.metrics.find(_.name == "bytes of written output").get
- val totalNumBytes = metrics(totalNumBytesMetric.accumulatorId).replaceAll(",", "").toInt
- assert(totalNumBytes > 0)
- }
-
- private def testMetricsNonDynamicPartition(
- dataFormat: String,
- tableName: String): Unit = {
- withTable(tableName) {
- Seq((1, 2)).toDF("i", "j")
- .write.format(dataFormat).mode("overwrite").saveAsTable(tableName)
-
- val tableLocation =
- new File(spark.sessionState.catalog.getTableMetadata(TableIdentifier(tableName)).location)
- // 2 files, 100 rows, 0 dynamic partition.
- verifyWriteDataMetrics(Seq(2, 0, 100)) {
- (0 until 100).map(i => (i, i + 1)).toDF("i", "j").repartition(2)
- .write.format(dataFormat).mode("overwrite").insertInto(tableName)
- }
- assert(Utils.recursiveList(tableLocation).count(_.getName.startsWith("part-")) == 2)
- }
- }
-
- private def testMetricsDynamicPartition(
- provider: String,
- dataFormat: String,
- tableName: String): Unit = {
- withTempPath { dir =>
- spark.sql(
- s"""
- |CREATE TABLE $tableName(a int, b int)
- |USING $provider
- |PARTITIONED BY(a)
- |LOCATION '${dir.toURI}'
- """.stripMargin)
- val table = spark.sessionState.catalog.getTableMetadata(TableIdentifier(tableName))
- assert(table.location == makeQualifiedPath(dir.getAbsolutePath))
-
- val df = spark.range(start = 0, end = 40, step = 1, numPartitions = 1)
- .selectExpr("id a", "id b")
-
- // 40 files, 80 rows, 40 dynamic partitions.
- verifyWriteDataMetrics(Seq(40, 40, 80)) {
- df.union(df).repartition(2, $"a")
- .write
- .format(dataFormat)
- .mode("overwrite")
- .insertInto(tableName)
- }
- assert(Utils.recursiveList(dir).count(_.getName.startsWith("part-")) == 40)
- }
- }
-
- test("writing data out metrics: parquet") {
- testMetricsNonDynamicPartition("parquet", "t1")
- }
-
- test("writing data out metrics with dynamic partition: parquet") {
- testMetricsDynamicPartition("parquet", "parquet", "t1")
- }
+class SQLMetricsSuite extends SQLMetricsTestUtils with TestHiveSingleton {
test("writing data out metrics: hive") {
testMetricsNonDynamicPartition("hive", "t1")
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org