Worked on the apache/doris repository to enhance routine-load workflows by introducing a FOR-based syntax to the SHOW ROUTINE LOAD TASK command, aligning it with other routine-load statements while maintaining backward compatibility. Addressed reliability by fixing host:port parsing in Stream Load, leveraging Guava’s HostAndPort to robustly support both IPv4 and IPv6 formats and reduce parsing errors. Focused on backend development using Java and SQL, with comprehensive unit testing to ensure stability. Improved user experience and production reliability by standardizing command syntax and expanding test coverage, supporting future scalability and safer iterations of streaming and load features within the project.