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_r381070895
##########
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(
Review comment:
Can we submit a job to calculate this `SizeInBytesWithDeserFactor` directly?
I think in some cases too many fileStatuses may introduce unnecessary memory
pressure.
----------------------------------------------------------------
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]
