liupc commented on a change in pull request #26016: [SPARK-24914][SQL] New
statistic to improve data size estimate for columnar storage formats
URL: https://github.com/apache/spark/pull/26016#discussion_r381071658
##########
File path:
sql/core/src/main/scala/org/apache/spark/sql/execution/command/CommandUtils.scala
##########
@@ -56,39 +64,94 @@ object CommandUtils extends Logging {
}
}
- def calculateTotalSize(spark: SparkSession, catalogTable: CatalogTable):
BigInt = {
+ def calculateTotalSize(
+ spark: SparkSession,
+ catalogTable: CatalogTable): SizeInBytesWithDeserFactor = {
val sessionState = spark.sessionState
val startTime = System.nanoTime()
val totalSize = if (catalogTable.partitionColumnNames.isEmpty) {
- calculateLocationSize(sessionState, catalogTable.identifier,
catalogTable.storage.locationUri)
+ calculateLocationSize(
+ sessionState,
+ catalogTable.identifier,
+ catalogTable.storage.locationUri,
+ catalogTable.storage.serde)
} else {
// Calculate table size as a sum of the visible partitions. See
SPARK-21079
val partitions =
sessionState.catalog.listPartitions(catalogTable.identifier)
logInfo(s"Starting to calculate sizes for ${partitions.length}
partitions.")
- if (spark.sessionState.conf.parallelFileListingInStatsComputation) {
- val paths = partitions.map(x => new Path(x.storage.locationUri.get))
- val stagingDir =
sessionState.conf.getConfString("hive.exec.stagingdir", ".hive-staging")
- val pathFilter = new PathFilter with Serializable {
- override def accept(path: Path): Boolean = isDataPath(path,
stagingDir)
+ val sizeWithDeserFactorsForPartitions =
+ if (sessionState.conf.parallelFileListingInStatsComputation) {
+ val paths = partitions.map(x => new Path(x.storage.locationUri.get))
+ val stagingDir =
sessionState.conf.getConfString("hive.exec.stagingdir", ".hive-staging")
+ val pathFilter = new PathFilter with Serializable {
+ override def accept(path: Path): Boolean = isDataPath(path,
stagingDir)
+ }
+ val deserFactCalcEnabled =
sessionState.conf.deserFactorStatCalcEnabled
+ val hadoopConf = sessionState.newHadoopConf()
+ val fileStatusSeq = InMemoryFileIndex.bulkListLeafFiles(
+ paths, hadoopConf, pathFilter, spark, areRootPaths = true)
+ fileStatusSeq.flatMap { case (_, fileStatuses) =>
+ fileStatuses.map { fileStatus =>
+ sizeInBytesWithDeserFactor(
+ deserFactCalcEnabled,
+ hadoopConf,
+ fileStatus,
+ catalogTable.storage.serde)
+ }
+ }
+ } else {
+ partitions.map { p =>
+ calculateLocationSize(
+ sessionState,
+ catalogTable.identifier,
+ p.storage.locationUri,
+ p.storage.serde)
+ }
}
- val fileStatusSeq = InMemoryFileIndex.bulkListLeafFiles(
- paths, sessionState.newHadoopConf(), pathFilter, spark, areRootPaths
= true)
- fileStatusSeq.flatMap(_._2.map(_.getLen)).sum
- } else {
- partitions.map { p =>
- calculateLocationSize(sessionState, catalogTable.identifier,
p.storage.locationUri)
- }.sum
- }
+ sumSizeWithMaxDeserializationFactor(sizeWithDeserFactorsForPartitions)
}
logInfo(s"It took ${(System.nanoTime() - startTime) / (1000 * 1000)} ms to
calculate" +
s" the total size for table ${catalogTable.identifier}.")
totalSize
}
+ def sumSizeWithMaxDeserializationFactor(
+ sizesWithFactors: Seq[SizeInBytesWithDeserFactor]):
SizeInBytesWithDeserFactor = {
+ val definedFactors =
sizesWithFactors.filter(_.deserFactor.isDefined).map(_.deserFactor.get)
+ SizeInBytesWithDeserFactor(
+ sizesWithFactors.map(_.sizeInBytes).sum,
+ if (definedFactors.isEmpty) None else Some(definedFactors.max))
+ }
+
+ def sizeInBytesWithDeserFactor(
+ calcDeserFact: Boolean,
+ hadoopConf: Configuration,
+ fStatus: FileStatus,
+ serde: Option[String]): SizeInBytesWithDeserFactor = {
+ assert(fStatus.isFile)
+ val factor = if (calcDeserFact) {
+ val isOrc = serde.contains(orcSerDeCanonicalClass) ||
fStatus.getPath.getName.endsWith(".orc")
Review comment:
Are there any plan to support datasource table to calculate this stats on
demand? Maybe we can also add an option to enable this for on demand
calculation?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
