基于数据集成平台SQL解析器的研究

Research Based on SQL Parser of Data Integration Platform

针对层出不穷的大数据组件和新型数据库,为了降低研发成本,兼容不同类型结构化查询语言(Structured Query Language,SQL)的解析,提出一种以传统SQL语法为模板,基于Antlr4开发的全新SQL解析器。经实践验证,该SQL解析器能够兼容MySQL、Spark SQL、Postgres,具有较高的实际应用价值.

In order to reduce the R&D cost and be compatible with the parsing of different types of Structured Query Language(SQL)languages,a new SQL parser based on Antlr4 based on traditional SQL syntax is proposed.It has been verified that the SQL parser is compatible with MySQL,Spark SQL,and Postgres,and has high practical application value。