Zijie Zhang
Student
Summary
🤩
RockstarZijie Zhang is a backend-focused software engineer and long-term contributor to open-source database projects, with nine years of hands-on experience despite currently listed as a student. He has made substantive contributions to TiDB and its MySQL-compatible parser—implementing JSON functions like json_array_insert, adding optimizer and aggregation hints (TIDB_HASHAGG, TIDB_STREAMAGG, AGG_TO_COP), and improving planner behaviors and error states. His work shows deep familiarity with SQL parsing, query planning, and memory/quota considerations in distributed SQL engines. Comfortable coding in Go and working on complex database internals, he blends practical feature development with careful testing and refinement. An interesting detail: his contributions include nuanced parser states and optimizer hints that directly influence execution strategies, reflecting both low-level parsing skill and high-level performance awareness.
9 years of coding experience
Github Skills (11)
tidb10
parserator10
json10
databases10
query-optimization10
parser10
go10
distributed-database10
sql10
mysql10
database10
Programming languages (5)
Github contributions (5)
pingcap/parser
Jul 2019 - Sep 2019
A MySQL Compatible SQL Parser
Role in this project:
Back-end Developer
Back-end DeveloperContributions:6 commits, 10 PRs, 3 pushes in 2 months
Contributions summary:Zijie primarily contributed to the MySQL parser, adding new states and optimizer hints. They introduced features like the `ErrInvalidJSONPathArrayCell` state and several optimizer hints, including `TIDB_HASHAGG`, `TIDB_STREAMAGG`, and `AGG_TO_COP`. Further contributions included modifying the memory quota hint argument and adding the `IGNORE_INDEX` hint, indicating ongoing development and refinement of the parser's capabilities.
mysqlsql-parser
pingcap/tidb
Jul 2019 - Oct 2019
TiDB is built for agentic workloads that grow unpredictably, with ACID guarantees and native support for transactions, analytics, and vector search. No data silos. No noisy neighbors. No infrastructure ceiling.
Role in this project:Back-end Developer
Back-end DeveloperContributions:21 commits, 32 PRs, 9 pushes in 3 months
Contributions summary:Zijie contributed to the TiDB project by implementing the built-in function `json_array_insert`. This involved writing Go code to add the function and associated test cases, demonstrating a strong understanding of JSON manipulation within the database context. The user also addressed multiple planner-related issues, specifically related to the `TIDB_INLJ` hint, and added aggregation hints like `TIDB_HASHAGG` and `TIDB_STREAMAGG`. These changes indicate contributions to the database's query optimization and planning features.
agentictidbvector-searchdistributed-databasedistributed-transactions
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.