TheR1sing3un opened a new pull request, #14183:
URL: https://github.com/apache/hudi/pull/14183

   For hudi, pushing down the primary key to file format is safe, which can 
significantly improve our query performance.
   
   > A simple query of select + pk filter in our product env
   
   > before
   
   <img width="542" height="135" alt="image" 
src="https://github.com/user-attachments/assets/2d974646-4e32-46b1-846f-4dbb2d6995bd";
 />
   
   <img width="360" height="97" alt="image" 
src="https://github.com/user-attachments/assets/3e67dc82-6179-47b8-97df-3a750bf544ec";
 />
   
   > after
   
   <img width="498" height="135" alt="image" 
src="https://github.com/user-attachments/assets/cbfa53f2-1128-4f28-99d0-c47fd3131302";
 />
   
   
   <img width="326" height="94" alt="image" 
src="https://github.com/user-attachments/assets/f8e462c6-9935-4f20-82ae-a2d6bc55b5d2";
 />
   
   
   
   
   ### Describe the issue this Pull Request addresses
   
   
   close #14181  subtask[1]: push-down to base file
   
   <!-- Either describe the issue inline here with motivation behind the 
changes 
        (or) link to an issue by including `Closes #<issue-number>` for 
context. 
        If this PR includes changes to the storage format, public APIs,
        or has breaking changes, use `!` (e.g., feat!: ...) -->
   
   ### Summary and Changelog
   1. introduce pk filter push-down to base file
   <!-- Short, plain-English summary of what users gain or what changed in 
behavior.
        Followed by a detailed log of all the changes. Highlight if any code 
was copied. -->
   
   ### Impact
   
   improve pk filter performance
   
   ### Risk Level
   
    low
   
   ### Documentation Update
   
   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
   
   - [x] Read through [contributor's 
guide](https://hudi.apache.org/contribute/how-to-contribute)
   - [x] Enough context is provided in the sections above
   - [x] 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to