During the month, contributed to the xupefei/spark repository by developing a customizable query optimization hints framework targeting aggregate, sort, and window operators. This work introduced an abstract hint mechanism for aggregates and an extension API that allows custom hint resolution rules, enabling greater flexibility in guiding the optimizer’s execution planning. Hints were also enabled on Sort and Window nodes, supporting more granular control over query performance. The implementation focused on extensibility for future enhancements and was delivered using Scala and Spark, leveraging data analysis and SQL expertise. No major bug fixes were addressed, as the primary focus remained on feature development.