Hongyu Guo

Associate Professor

Washington DC-Baltimore Area United States
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts

Summary

🤩
Rockstar
🎓
Top School
Hongyu Guo is an experimental physicist and Associate Professor with over 18 years in condensed matter research and deep expertise in synchrotron X-ray and neutron scattering techniques. He has a strong track record from Johns Hopkins and NIST to the Chinese Academy of Sciences studying structure and dynamics of soft and complex materials, bridging hands-on beamline experiments with rheology and theory. Beyond academia, he contributes to open-source backend development—enhancing SQL support and string functions in the widely used Apache Calcite project—demonstrating fluency in both scientific instrumentation and production-grade software. Based in the Washington DC–Baltimore area, he combines long-form experimental programs with pragmatic software contributions that improve data processing and query capabilities for broader research and engineering workflows.
code3 years of coding experience
job5 years of employment as a software developer
bookJohns Hopkins University
bookMaster of Science (M.S.), Physics, Master of Science (M.S.), Physics at Peking University
languagesChinese, English
github-logo-circle

Github Skills (14)

apache-calcite10
javas10
sql10
calc10
java10
databases9
big-data9
database9
junit8
jtest8
data-structure5
algorithms5
algorithm5
data-structures5

Programming languages (2)

JavaHTML

Github contributions (5)

github-logo-circle
apache/calcite

Jul 2022 - Jan 2025

Apache Calcite
Role in this project:
userBack-end Developer
Contributions:93 reviews, 51 PRs, 24 pushes in 2 years 6 months
Contributions summary:Hongyu primarily contributed to the back-end logic and SQL query validation aspects of the Apache Calcite project. Their work included implementing support for new SQL features like `CREATE TABLE ... LIKE` and the `MERGE` statement, as well as addressing issues related to specific SQL dialects like MySQL and Spark SQL. The user also added new functions, such as `CODE_POINTS_TO_BYTES`, `CODE_POINTS_TO_STRING`, and `TO_CODE_POINTS`, which enhanced the project's string handling capabilities. These changes demonstrate a focus on expanding Calcite's SQL support and functionality.
geospatialapache-calcitesqlapachebig-data
macroguo-ghy/calcite

Jun 2023 - Mar 2024

Apache Calcite
Contributions:11 PRs, 196 pushes, 28 branches in 8 months
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.
Request Free Trial