Apache ShardingSphere

 
Apache ShardingSphere is a distributed database middleware ecosystem, including 2 independent products, ShardingSphere JDBC and ShardingSphere Proxy presently. They all provide functions of data sharding, distributed transaction, and database orchestration.
Page: https://shardingsphere.apache.org
Github: https://github.com/apache/shardingsphere 

Background

ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). At present, this parser engine can handle SQLs for `MySQL`, `PostgreSQL`, `SQLServer`, `openGauss` and `Oracle`, which means we have to understand different database dialect SQLs.
 
More details:
https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/ 

Task

This issue is to solve the unsupported postgres sql about alter in this file . * ALTER OPERATORCALL

• ALTER POLICYCHECKPOINTALTER PUBLICATION

• CLOSE

• ALTER ROUTINECLUSTERALTER RULE

• COMMENT

• ALTER SCHEMA

• ALTER SEQUENCE

• ALTER SERVER

• ALTER STATISTICS

• ALTER SUBSCRIPTION

• ALTER TABLE

• ALTER TEXT SEARCH

• ALTER TRIGGER

• ALTER TYPE

• ALTER VIEW

• COPY

• CREATE ACCESS METHOD

• CREATE AGGREGATE

• CREATE CAST

• CREATE COLLATION

• CREATE EVENT TRIGGER

• CREATE FOREIGN DATA WRAPPER

• CREATE FOREIGN TABLE

• CREATE GROUP

• CREATE MATERIALIZED VIEW

• CREATE OPERATOR

• CREATE POLICY

• CREATE PUBLICATION

 
You can learn more You can learn more here. *
You may need to try to get why it's not supported.(antlr4 grammar? or not implement visit method) You can use antlr4 plugins to help you to analyze. You may need to visit an official doc to check the grammar.

• After you fix it, remember to add a new corresponding SQL case in SQL Cases and the expected parsed result in Expected Statment XML.

• Run SQLParserParameterizedTest and UnsupportedSQLParserParameterizedTest to make sure no exceptions.

 
Notice, these issues can be a good example.
support alter foreign table for pg/og
support alter materialized view for pg/og.

Relevant Skills

 
1. Master JAVA language
2. Have a basic understanding of Antlr g4 file
3. Be familiar with Postgres SQLsSQLs 

Targets files

 
1. Postgres SQLs g4 file: https://github.com/apache/shardingsphere/blob/master/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatement.g4

Mentor

Trista PanZhengqiang Duan, PMC Committer of Apache ShardingSphere, https://tristazero.github.ioZhengqiang Duan, Committer of ApacheShardingSphere, https://github.com/strongduanmuduanzhengqiang@apache.org
Haoran Meng, PMC of Apache ShardingSphere, menghaoran@apache.org

Apache ShardingSphere

 
Apache ShardingSphere is a distributed database middleware ecosystem, including 2 independent products, ShardingSphere JDBC and ShardingSphere Proxy presently. They all provide functions of data sharding, distributed transaction, and database orchestration.
Page: https://shardingsphere.apache.org
Github: https://github.com/apache/shardingsphere 

 Background

ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). At present, this parser engine can handle SQLs for `MySQL`, `PostgreSQL`, `SQLServer`, `openGauss` and `Oracle`, which means we have to understand different database dialect SQLs.
 
More details:
https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/ 

Task

This issue is to solve the unsupported postgres sql about alter in this file . * CALLALTER OPERATOR

• CHECKPOINTALTER POLICY

• CLOSEALTER PUBLICATION

• CLUSTERALTER ROUTINE

• COMMENTALTER RULE

• COPY

• CREATE ACCESS METHOD

• CREATE AGGREGATE

• CREATE CAST

• CREATE COLLATION

• CREATE EVENT TRIGGER

• CREATE FOREIGN DATA WRAPPER

• CREATE FOREIGN TABLE

• CREATE GROUP

• CREATE MATERIALIZED VIEW

• CREATE OPERATOR

• CREATE POLICY

• CREATE PUBLICATION

• ALTER SCHEMA

• ALTER SEQUENCE

• ALTER SERVER

• ALTER STATISTICS

• ALTER SUBSCRIPTION

• ALTER TABLE

• ALTER TEXT SEARCH

• ALTER TRIGGER

• ALTER TYPE

• ALTER VIEW

You can learn more here. *
You may need to try to get why it's not supported.(antlr4 grammar? or not implement visit method) You can use antlr4 plugins to help you to analyze. You may need to visit an official doc to check the grammar.

• 
  After you fix it, remember to add a new corresponding SQL case in SQL Cases and the expected parsed result in Expected Statment XML.

• Run SQLParserParameterizedTest and UnsupportedSQLParserParameterizedTest to make sure no exceptions.

Notice, these issues can be a good example.
support alter foreign table for pg/og
support alter materialized view for pg/og.

Relevant Skills

1. Master JAVA language
2. Have a basic understanding of Antlr g4 file
3. Be familiar with Postgres SQLs SQLs

Targets files

1. Postgres SQLs g4 file: https://github.com/apache/shardingsphere/blob/master/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatement.g4

Mentor

Zhengqiang DuanTrista Pan, Committer PMC of Apache ShardingSphere, duanzhengqiang@apache.org
Haoran Meng, PMC of Apache ShardingSphere, menghaoran@apache.org https://tristazero.github.io

Zhengqiang Duan, Committer of ApacheShardingSphere, https://github.com/strongduanmu

Apache ShenYu (incubating)

A High-performance,multi-protocol,extensible,responsive API Gateway. Compatible with a variety of mainstream framework systems, support hot plug, users can customize the development, meet the current situation and future needs of users in a variety of scenarios, experienced the temper of large-scale scenes

• Website: https://shenyu.apache.org
• GitHub: https://github.com/apache/incubator-shenyu
• Linked GitHub Issue

Apache ShardingSphere

• : https://github.com/apache/

Background

ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). At present, this parser engine can handle SQLs for `MySQL`, `PostgreSQL`, `SQLServer`, `openGauss` and `Oracle`, which means we have to understand different database dialect SQLs.
 
More details:
https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/

Task

This issue is to solve the unsupported postgres sql about alter in this file . * ALTER OPERATOR

• ALTER POLICY

• ALTER PUBLICATION

• ALTER ROUTINE

• ALTER RULE

• ALTER SCHEMA

• ALTER SEQUENCE

• ALTER SERVER

• ALTER STATISTICS

• ALTER SUBSCRIPTION

• ALTER TABLE

• ALTER TEXT SEARCH

• ALTER TRIGGER

• ALTER TYPE

• ALTER VIEW

 
You can learn more here. *
You may need to try to get why it's not supported.(antlr4 grammar? or not implement visit method) You can use antlr4 plugins to help you to analyze. You may need to visit an official doc to check the grammar.

• After you fix it, remember to add a new corresponding SQL case in SQL Cases and expected parsed result in Expected Statment XML.

• Run SQLParserParameterizedTest and UnsupportedSQLParserParameterizedTest to make sure no exceptions.

 
Notice, these issues can be a good example.
support alter foreign table for pg/og
support alter materialized view for pg/og.

Relevant Skills

1. Master JAVA language
2. Have a basic understanding of Antlr g4 file
3. Be familiar with Postgres SQLs

Targets files

• incubator-shenyu/issues/2896

Description

1. Apache ShenYu uses java agent and bytecode enhancement technology to achieve seamless embedding, so that users can access third-party observability systems without introducing dependencies, and obtain Traces, Metrics and Logging.
2. Take the shenyu gateway log information, write it to elasticSearch and display it.
3. Can add module like this ：

               shenyu-agent
               ------ shenyu-agent-plugin-logging
               ----------------shenyu-agent-plugin-logging-elasticsearch

Task

• Add shenyu-agent-plugin-logging-elasticsearch module and impl write it to elasticSearch
• Complete unit test for this module
• Complete the integration for this module
• Complete doc for this module in shenyu website

Recommended Skills

•  Familiar with Java
•  Know the usage of java agent and bytebuddy
•  Know the usage of elasticSearch java client
•  Have some knowledge about  Docker

Mentor

XiaoYu, PPMC of Apache ShenYu, https://github.com/yu199195, [xiaoyu@apache.org](xiaoyu@apache.org^{Image Added})

Apache ShenYu (incubating)

A High-performance,multi-protocol,extensible,responsive API Gateway. Compatible with a variety of mainstream framework systems, support hot plug, users can customize the development, meet the current situation and future needs of users in a variety of scenarios, experienced the temper of large-scale scenes

Website: https://shenyu.apache.org

GitHub1. Postgres SQLs g4 file: https://github.com/apache/shardingsphere/blob/master/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/antlr4/org/apache/shardingsphere/sql/parser/autogen/PostgreSQLStatement.g4

Mentor

Zhengqiang Duan, Committer of Apache ShardingSphere, duanzhengqiang@apache.org
Haoran Meng, PMC of Apache ShardingSphere, menghaoran@apache.org

incubator-shenyu

Linked GitHub Issue: https://github.com/apache/incubator-shenyu/issues/2890

Background

1. ShenYu is still vacant with helm deployment, so we need to write charts for it, and then complete the integration test.
2. Shenyu already has a relatively complete integration testing framework, but some plug-ins have not been tested, and some tests are not perfect.

Task

• Write helm chart for Apache ShenYu
• Complete the integration test of deploying Apache ShenYu with helm in Kubernetes
• Documentation for helm deployment
• Complete the integration test of the Oauth2 plugin
• Improve the integration test of other existing plugin

Recommended Skills

Familiar with Java

Know the usage of spring-framework

Have some knowledge about Kubernetes and Docker

Mentor

Kunshuai Zhu, Committer of Apache ShenYu, https://github.com/JooKS-me, jooks@apache.org^{Image Added}

BanyanDB, as an observability database, aims to ingest, analyze and store Metrics, Tracing, and Logging data. It's designed to handle observability data generated by Apache SkyWalking. 

We need a web-based application to 

• Query the data from the banyandb's data nodes
• Monitor the performance of the backend
• Render the topology of server nodes

Apache ShenYu (incubating)

A High-performance,multi-protocol,extensible,responsive API Gateway. Compatible with a variety of mainstream framework systems, support hot plug, users can customize the development, meet the current situation and future needs of users in a variety of scenarios, experienced the temper of large-scale scenes

Website: https://shenyu.apache.org

GitHub: https://github.com/apache/incubator-shenyu

Linked GitHub Issue: https://github.com/apache/incubator-shenyu/issues/2890

Background

1. ShenYu is still vacant with helm deployment, so we need to write charts for it, and then complete the integration test.

1. Shenyu already has a relatively complete integration testing framework, but some plug-ins have not been tested, and some tests are not perfect.

Task

• Write helm chart for Apache ShenYu
• Complete the integration test of deploying Apache ShenYu with helm in Kubernetes
• Documentation for helm deployment
• Complete the integration test of the Oauth2 plugin
• Improve the integration test of other existing plugin

Recommended Skills

Familiar with Java

Know the usage of spring-framework

Have some knowledge about Kubernetes and Docker

Mentor

jooks@apache.org^{Image Removed}