Contributor
kanha-gupta

ShardingSphere Enhance SQLNodeConverterEngine to support more MySQL SQL statements


Mentors
Trista Pan, Zhengqiang Duan, tuichenchuxin
Organization
Apache Software Foundation
Technologies
mysql, java, antlr, apache calcite
Topics
SQL parsing
Shardingsphere federated query engine provides support for SQL statements. In the GSoc period, I have to add support for more MySQL SELECT statements so that more SQL statements can be converted into SQLNode. This can be achieved by: 1- Analysing the SQL statement I have to add support of, 2-Figure out components & logic required , 3- Make changes in SQL federation engine optimizer files , 4- Optimize parser files , 5- Make changes in TEST files to ensure test is passing successfully. After the support for More SELECT statements queries is added, The users & developers will be benefitted by utilising more SELECT queries for MySQL .