Nicky Chew enhanced the apache/spark repository by developing Stream-Stream Join State Format V4, focusing on indexing and timestamp range scoping to optimize Spark’s streaming join state format. Using Scala and leveraging big data and stream processing expertise, Nicky introduced timestamp-based indexing and scoped time-interval joins, reducing scan I/O and improving retrieval efficiency. The work included fixing watermark ordinal resolution for time window joins, ensuring correct join behavior and robust state management. Comprehensive test coverage was added, with all V4 suites passing, demonstrating stability. The V4 format remains experimental, gated by configuration, laying groundwork for future performance improvements and features.