sqlparser java_Java SqlParser.parseQuery方法代码示例

import org.apache.calcite.sql.parser.SqlParser; //导入方法依赖的package包/类

@Override public RelRoot expandView(RelDataType rowType, String queryString,

List schemaPath, List viewPath) {

SqlParser parser = SqlParser.create(queryString, parserConfig);

SqlNode sqlNode;

try {

sqlNode = parser.parseQuery();

} catch (SqlParseException e) {

throw new RuntimeException("parse failed", e);

}

final SqlConformance conformance = conformance();

final CalciteCatalogReader catalogReader =

createCatalogReader().withSchemaPath(schemaPath);

final SqlValidator validator =

new CalciteSqlValidator(operatorTable, catalogReader, typeFactory,

conformance);

validator.setIdentifierExpansion(true);

final SqlNode validatedSqlNode = validator.validate(sqlNode);

final RexBuilder rexBuilder = createRexBuilder();

final RelOptCluster cluster = RelOptCluster.create(planner, rexBuilder);

final SqlToRelConverter.Config config = SqlToRelConverter

.configBuilder()

.withConfig(sqlToRelConverterConfig)

.withTrimUnusedFields(false)

.withConvertTableAccess(false)

.build();

final SqlToRelConverter sqlToRelConverter =

new SqlToRelConverter(new ViewExpanderImpl(), validator,

catalogReader, cluster, convertletTable, config);

root = sqlToRelConverter.convertQuery(validatedSqlNode, true, false);

root = root.withRel(sqlToRelConverter.flattenTypes(root.rel, true));

root = root.withRel(RelDecorrelator.decorrelateQuery(root.rel));

return PlannerImpl.this.root;

}