使用SqlImplementor.Context实现类转换Rex表达式
org.apache.calcite.rel.rel2sql.SqlImplementor.BaseContext
org.apache.calcite.rel.rel2sql.SqlImplementor.AliasContext
org.apache.calcite.rel.rel2sql.SqlImplementor.MatchRecognizeContext
org.apache.calcite.rel.rel2sql.SqlImplementor.SimpleContext
SqlImplementor有成员方法构造上述对象
SqlImplementor.Context context = new SqlImplementor.Context(MysqlSqlDialect.DEFAULT, JdbcTable.this.rowSignature.getColumnCount()) {
@Override
public SqlNode field(int ordinal) {
String fieldName = xxxx.get(ordinal);
return new SqlIdentifier(ImmutableList.of(schemaName, tableName, fieldName),
SqlImplementor.POS);
}
};
SqlNode sqlNode = context.toSql(null, rexNode);
使用RexToSqlNodeConverter
final RexSqlStandardConvertletTable convertletTable = new RexSqlStandardConvertletTable();
RexToSqlNodeConverter converter = new RexToSqlNodeConverterImpl(convertletTable);
SqlNode sqlNode = converter.convertNode(rexNode);
只能转换三种类型
RexCall
RexLiteral
RexInputRef
使用RelToSqlConverter
RelToSqlConverter relToSqlConverter = new RelToSqlConverter(MysqlSqlDialect.DEFAULT);
SqlImplementor.Result visit = relToSqlConverter.visitChild(0,logicalTableScan);
SqlNode sqlNode = visit.asStatement();
relToSqlConverter有多种访问访问
SqlImplementor.Result既有多种输出方法