You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hudi.apache.org by "linliu-code (via GitHub)" <gi...@apache.org> on 2025/09/20 16:42:51 UTC
[PR] [MINOR] Update hfile prefetch threshold [hudi]
linliu-code opened a new pull request, #13946:
URL: https://github.com/apache/hudi/pull/13946
### Describe the issue this Pull Request addresses
For queries that run short, like a few seconds, the impact from latency to read Hudi metadata could be huge. We have observed that the metadata read latency could be higher than that of the data read itself. Therefore, reducing the latency of reading Hudi metadata is important for these queries.
Previously the hfile reader could trigger multiple read for a single hfile in the MDT, e.g., a read is triggered when a data block is requested. When the hfile becomes bigger, this could be become a huge problem. An feature that Hudi introduces to alleviate this problem is caching the entire hfile before reading it if its size is below a certain threshold.
By default the threshold is 0MB.
### Summary and Changelog
This change Increases the threshold for hfile prefetch threshold from 0 MB to 50 MB, and really enables hfile prefetching and caching.
The change was tested by using the following query based on a table in 10TB tpcds dataset. After this change, its latency reduces from ~4s to ~1s.
`spark.read.format("hudi").option("hoodie.enable.data.skipping", "true").load("s3a://performance-benchmark-datasets-us-west-2/tpc-ds-datasets-hudi/10TB/store_sales/").createOrReplaceTempView("ss1");
spark.time{spark.sql("select count(1) from ss1 where ss_sold_date_sk='2450818' and ss_sold_time_sk=31367;").count()}`
### Impact
Reduce the MDT read latency and further improve the query performance.
### Risk Level
Low.
### Documentation Update
<!-- Describe any necessary documentation update if there is any new feature, config, or user-facing change. If not, put "none".
- The config description must be updated if new configs are added or the default value of the configs are changed.
- Any new feature or user-facing change requires updating the Hudi website. Please follow the
[instruction](https://hudi.apache.org/contribute/developer-setup#website) to make changes to the website. -->
### Contributor's checklist
- [ ] Read through [contributor's guide](https://hudi.apache.org/contribute/how-to-contribute)
- [ ] Enough context is provided in the sections above
- [ ] Adequate tests were added if applicable
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] perf: Increase HFile prefetch threshold [hudi]
Posted by "nsivabalan (via GitHub)" <gi...@apache.org>.
nsivabalan merged PR #13946:
URL: https://github.com/apache/hudi/pull/13946
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] perf: Increase HFile prefetch threshold [hudi]
Posted by "linliu-code (via GitHub)" <gi...@apache.org>.
linliu-code commented on PR #13946:
URL: https://github.com/apache/hudi/pull/13946#issuecomment-3315389523
The Azure CI is actually green:
<img width="1929" height="633" alt="image" src="https://github.com/user-attachments/assets/db7e4d49-1173-43d4-9048-0315c1bf9aca" />
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] config: Update HFile prefetch threshold [hudi]
Posted by "hudi-bot (via GitHub)" <gi...@apache.org>.
hudi-bot commented on PR #13946:
URL: https://github.com/apache/hudi/pull/13946#issuecomment-3315115425
<!--
Meta data
{
"version" : 1,
"metaDataEntries" : [ {
"hash" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"status" : "FAILURE",
"url" : "https://dev.azure.com/apachehudi/a1a51da7-8592-47d4-88dc-fd67bed336bb/_build/results?buildId=8672",
"triggerID" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"triggerType" : "PUSH"
} ]
}-->
## CI report:
* be01a21c145d07f9a91c1c1a42cb707298b92b52 Azure: [FAILURE](https://dev.azure.com/apachehudi/a1a51da7-8592-47d4-88dc-fd67bed336bb/_build/results?buildId=8672)
<details>
<summary>Bot commands</summary>
@hudi-bot supports the following commands:
- `@hudi-bot run azure` re-run the last Azure build
</details>
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] [MINOR] Update hfile prefetch threshold [hudi]
Posted by "hudi-bot (via GitHub)" <gi...@apache.org>.
hudi-bot commented on PR #13946:
URL: https://github.com/apache/hudi/pull/13946#issuecomment-3315098648
<!--
Meta data
{
"version" : 1,
"metaDataEntries" : [ {
"hash" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"status" : "PENDING",
"url" : "https://dev.azure.com/apachehudi/a1a51da7-8592-47d4-88dc-fd67bed336bb/_build/results?buildId=8672",
"triggerID" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"triggerType" : "PUSH"
} ]
}-->
## CI report:
* be01a21c145d07f9a91c1c1a42cb707298b92b52 Azure: [PENDING](https://dev.azure.com/apachehudi/a1a51da7-8592-47d4-88dc-fd67bed336bb/_build/results?buildId=8672)
<details>
<summary>Bot commands</summary>
@hudi-bot supports the following commands:
- `@hudi-bot run azure` re-run the last Azure build
</details>
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] [MINOR] Update hfile prefetch threshold [hudi]
Posted by "hudi-bot (via GitHub)" <gi...@apache.org>.
hudi-bot commented on PR #13946:
URL: https://github.com/apache/hudi/pull/13946#issuecomment-3315097206
<!--
Meta data
{
"version" : 1,
"metaDataEntries" : [ {
"hash" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"status" : "UNKNOWN",
"url" : "TBD",
"triggerID" : "be01a21c145d07f9a91c1c1a42cb707298b92b52",
"triggerType" : "PUSH"
} ]
}-->
## CI report:
* be01a21c145d07f9a91c1c1a42cb707298b92b52 UNKNOWN
<details>
<summary>Bot commands</summary>
@hudi-bot supports the following commands:
- `@hudi-bot run azure` re-run the last Azure build
</details>
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] perf: Increase HFile prefetch threshold [hudi]
Posted by "nsivabalan (via GitHub)" <gi...@apache.org>.
nsivabalan commented on PR #13946:
URL: https://github.com/apache/hudi/pull/13946#issuecomment-3315509983
<img width="1178" height="572" alt="image" src="https://github.com/user-attachments/assets/23dcb975-4cb0-46cf-b1fd-eb0ed7e0d69e" />
--
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.
To unsubscribe, e-mail: commits-unsubscribe@hudi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org