flink sql 语法校验

flink sql 语法校验

说明：apache flink 源码的校验方式

1 新增依赖包

        <dependency>
            <groupId>org.apache.flink</groupId>
            <artifactId>flink-table-planner-blink_${scala.binary.version}</artifactId>
            <version>对应flink的版本</version>
        </dependency>

2 code

/**
     * 解析&校验 Flink SQL语句
     *
     * @param sql 一整段字符串sql
     * @return sql语句list
     */
    public List<String> parseFlinkSql(String sql) throws Exception {
        List<String> sqlList = new ArrayList<>();
        if (StringUtils.isNotBlank(sql)) {
            SqlParser parser = SqlParser.create(sql, SqlParser.configBuilder()
                    .setParserFactory(FlinkSqlParserImpl.FACTORY)
                    .setQuoting(Quoting.BACK_TICK)
                    .setUnquotedCasing(Casing.TO_LOWER)   //字段名统一转化为小写
                    .setQuotedCasing(Casing.UNCHANGED)
                    .setConformance(FlinkSqlConformance.DEFAULT)
                    .build()
            );
            List<SqlNode> sqlNodeList = parser.parseStmtList().getList();
            if (sqlNodeList != null && !sqlNodeList.isEmpty()) {
                for (SqlNode sqlNode : sqlNodeList) {
                    sqlList.add(sqlNode.toString());
                }
            }
        }
        return sqlList;
    }