Java Code Examples for org.apache.calcite.sql.SqlWindow#create()
The following examples show how to use
org.apache.calcite.sql.SqlWindow#create() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: DremioRelToSqlConverter.java From dremio-oss with Apache License 2.0 | 6 votes |
/** * Returns a SqlWindow that adds ORDER BY if op is one of the given functions. */ protected static SqlWindow addDummyOrderBy(SqlWindow window, DremioContext context, SqlAggFunction op, List<SqlAggFunction> opsToAddClauseFor) { if (!SqlNodeList.isEmptyList(window.getOrderList())) { return window; } // Add the ORDER BY if op is one of the given functions. for (SqlAggFunction function : opsToAddClauseFor) { if (function == op) { SqlNodeList dummyOrderByList = new SqlNodeList(POS); dummyOrderByList.add(context.field(0)); return SqlWindow.create(window.getDeclName(), window.getRefName(), window.getPartitionList(), dummyOrderByList, SqlLiteral.createBoolean(window.isRows(), POS), window.getLowerBound(), window.getUpperBound(), SqlLiteral.createBoolean(window.isAllowPartial(), POS), POS); } } return window; }
Example 2
Source File: SqlImplementor.java From Bats with Apache License 2.0 | 5 votes |
private SqlCall toSql(RexProgram program, RexOver rexOver) { final RexWindow rexWindow = rexOver.getWindow(); final SqlNodeList partitionList = new SqlNodeList(toSql(program, rexWindow.partitionKeys), POS); ImmutableList.Builder<SqlNode> orderNodes = ImmutableList.builder(); if (rexWindow.orderKeys != null) { for (RexFieldCollation rfc : rexWindow.orderKeys) { orderNodes.add(toSql(program, rfc)); } } final SqlNodeList orderList = new SqlNodeList(orderNodes.build(), POS); final SqlLiteral isRows = SqlLiteral.createBoolean(rexWindow.isRows(), POS); // null defaults to true. // During parsing the allowPartial == false (e.g. disallow partial) // is expand into CASE expression and is handled as a such. // Not sure if we can collapse this CASE expression back into // "disallow partial" and set the allowPartial = false. final SqlLiteral allowPartial = null; SqlAggFunction sqlAggregateFunction = rexOver.getAggOperator(); SqlNode lowerBound = null; SqlNode upperBound = null; if (sqlAggregateFunction.allowsFraming()) { lowerBound = createSqlWindowBound(rexWindow.getLowerBound()); upperBound = createSqlWindowBound(rexWindow.getUpperBound()); } final SqlWindow sqlWindow = SqlWindow.create(null, null, partitionList, orderList, isRows, lowerBound, upperBound, allowPartial, POS); final List<SqlNode> nodeList = toSql(program, rexOver.getOperands()); return createOverCall(sqlAggregateFunction, nodeList, sqlWindow); }
Example 3
Source File: SqlImplementor.java From dremio-oss with Apache License 2.0 | 5 votes |
protected SqlCall toSql(RexProgram program, RexOver rexOver) { final RexWindow rexWindow = rexOver.getWindow(); final SqlNodeList partitionList = new SqlNodeList( toSql(program, rexWindow.partitionKeys), POS); ImmutableList.Builder<SqlNode> orderNodes = ImmutableList.builder(); if (rexWindow.orderKeys != null) { for (RexFieldCollation rfc : rexWindow.orderKeys) { orderNodes.add(toSql(program, rfc)); } } final SqlNodeList orderList = new SqlNodeList(orderNodes.build(), POS); final SqlLiteral isRows = SqlLiteral.createBoolean(rexWindow.isRows(), POS); final SqlNode lowerBound = createSqlWindowBound(rexWindow.getLowerBound()); final SqlNode upperBound = createSqlWindowBound(rexWindow.getUpperBound()); // null defaults to true. // During parsing the allowPartial == false (e.g. disallow partial) // is expand into CASE expression and is handled as a such. // Not sure if we can collapse this CASE expression back into // "disallow partial" and set the allowPartial = false. final SqlLiteral allowPartial = null; final SqlWindow sqlWindow = SqlWindow.create(null, null, partitionList, orderList, isRows, lowerBound, upperBound, allowPartial, POS); final List<SqlNode> nodeList = toSql(program, rexOver.getOperands()); final SqlCall aggFunctionCall = rexOver.getAggOperator().createCall(POS, nodeList); return SqlStdOperatorTable.OVER.createCall(POS, aggFunctionCall, sqlWindow); }
Example 4
Source File: SqlImplementor.java From calcite with Apache License 2.0 | 5 votes |
private SqlCall toSql(RexProgram program, RexOver rexOver) { final RexWindow rexWindow = rexOver.getWindow(); final SqlNodeList partitionList = new SqlNodeList( toSql(program, rexWindow.partitionKeys), POS); List<SqlNode> orderNodes = Expressions.list(); if (rexWindow.orderKeys != null) { for (RexFieldCollation rfc : rexWindow.orderKeys) { addOrderItem(orderNodes, program, rfc); } } final SqlNodeList orderList = new SqlNodeList(orderNodes, POS); final SqlLiteral isRows = SqlLiteral.createBoolean(rexWindow.isRows(), POS); // null defaults to true. // During parsing the allowPartial == false (e.g. disallow partial) // is expand into CASE expression and is handled as a such. // Not sure if we can collapse this CASE expression back into // "disallow partial" and set the allowPartial = false. final SqlLiteral allowPartial = null; SqlAggFunction sqlAggregateFunction = rexOver.getAggOperator(); SqlNode lowerBound = null; SqlNode upperBound = null; if (sqlAggregateFunction.allowsFraming()) { lowerBound = createSqlWindowBound(rexWindow.getLowerBound()); upperBound = createSqlWindowBound(rexWindow.getUpperBound()); } final SqlWindow sqlWindow = SqlWindow.create(null, null, partitionList, orderList, isRows, lowerBound, upperBound, allowPartial, POS); final List<SqlNode> nodeList = toSql(program, rexOver.getOperands()); return createOverCall(sqlAggregateFunction, nodeList, sqlWindow); }
Example 5
Source File: SqlImplementor.java From dremio-oss with Apache License 2.0 | 4 votes |
public List<SqlNode> toSql(Window.Group group, ImmutableList<RexLiteral> constants, int inputFieldCount) { final List<SqlNode> rexOvers = new ArrayList<>(); final List<SqlNode> partitionKeys = new ArrayList<>(); final List<SqlNode> orderByKeys = new ArrayList<>(); for (int partition : group.keys) { partitionKeys.add(this.field(partition)); } for (RelFieldCollation collation : group.orderKeys.getFieldCollations()) { this.addOrderItem(orderByKeys, collation); } SqlLiteral isRows = SqlLiteral.createBoolean(group.isRows, POS); SqlNode lowerBound = null; SqlNode upperBound = null; final SqlLiteral allowPartial = null; for (Window.RexWinAggCall winAggCall : group.aggCalls) { SqlAggFunction aggFunction = (SqlAggFunction) winAggCall.getOperator(); final SqlWindow sqlWindow = SqlWindow.create(null, null, new SqlNodeList(partitionKeys, POS), new SqlNodeList(orderByKeys, POS), isRows, lowerBound, upperBound, allowPartial, POS); if (aggFunction.allowsFraming()) { lowerBound = createSqlWindowBound(group.lowerBound); upperBound = createSqlWindowBound(group.upperBound); sqlWindow.setLowerBound(lowerBound); sqlWindow.setUpperBound(upperBound); } RexShuttle replaceConstants = new RexShuttle() { @Override public RexNode visitInputRef(RexInputRef inputRef) { int index = inputRef.getIndex(); RexNode ref; if (index > inputFieldCount - 1) { ref = constants.get(index - inputFieldCount); } else { ref = inputRef; } return ref; } }; RexCall aggCall = (RexCall) winAggCall.accept(replaceConstants); List<SqlNode> operands = toSql(null, aggCall.operands); rexOvers.add(createOverCall(aggFunction, operands, sqlWindow)); } return rexOvers; }
Example 6
Source File: PigRelToSqlConverter.java From calcite with Apache License 2.0 | 4 votes |
/** @see #dispatch */ public Result visit(Window e) { final Result x = visitChild(0, e.getInput()); final Builder builder = x.builder(e, Clause.SELECT); final List<SqlNode> selectList = new ArrayList<>(builder.context.fieldList()); for (Window.Group winGroup : e.groups) { final List<SqlNode> partitionList = Expressions.list(); for (int i : winGroup.keys) { partitionList.add(builder.context.field(i)); } final List<SqlNode> orderList = Expressions.list(); for (RelFieldCollation orderKey : winGroup.collation().getFieldCollations()) { orderList.add(builder.context.toSql(orderKey)); } final SqlNode sqlWindow = SqlWindow.create( null, // Window declaration name null, // Window reference name new SqlNodeList(partitionList, POS), new SqlNodeList(orderList, POS), SqlLiteral.createBoolean(winGroup.isRows, POS), builder.context.toSql(winGroup.lowerBound), builder.context.toSql(winGroup.upperBound), null, // allowPartial POS); for (Window.RexWinAggCall winFunc : winGroup.aggCalls) { final List<SqlNode> winFuncOperands = Expressions.list(); for (RexNode operand : winFunc.getOperands()) { winFuncOperands.add(builder.context.toSql(null, operand)); } SqlNode aggFunc = winFunc.getOperator().createCall(new SqlNodeList(winFuncOperands, POS)); selectList.add(SqlStdOperatorTable.OVER.createCall(POS, aggFunc, sqlWindow)); } builder.setSelect(new SqlNodeList(selectList, POS)); } return builder.result(); }
Example 7
Source File: SqlImplementor.java From calcite with Apache License 2.0 | 4 votes |
public List<SqlNode> toSql(Window.Group group, ImmutableList<RexLiteral> constants, int inputFieldCount) { final List<SqlNode> rexOvers = new ArrayList<>(); final List<SqlNode> partitionKeys = new ArrayList<>(); final List<SqlNode> orderByKeys = new ArrayList<>(); for (int partition: group.keys) { partitionKeys.add(this.field(partition)); } for (RelFieldCollation collation: group.orderKeys.getFieldCollations()) { this.addOrderItem(orderByKeys, collation); } SqlLiteral isRows = SqlLiteral.createBoolean(group.isRows, POS); SqlNode lowerBound = null; SqlNode upperBound = null; final SqlLiteral allowPartial = null; for (Window.RexWinAggCall winAggCall: group.aggCalls) { SqlAggFunction aggFunction = (SqlAggFunction) winAggCall.getOperator(); final SqlWindow sqlWindow = SqlWindow.create(null, null, new SqlNodeList(partitionKeys, POS), new SqlNodeList(orderByKeys, POS), isRows, lowerBound, upperBound, allowPartial, POS); if (aggFunction.allowsFraming()) { lowerBound = createSqlWindowBound(group.lowerBound); upperBound = createSqlWindowBound(group.upperBound); sqlWindow.setLowerBound(lowerBound); sqlWindow.setUpperBound(upperBound); } RexShuttle replaceConstants = new RexShuttle() { @Override public RexNode visitInputRef(RexInputRef inputRef) { int index = inputRef.getIndex(); RexNode ref; if (index > inputFieldCount - 1) { ref = constants.get(index - inputFieldCount); } else { ref = inputRef; } return ref; } }; RexCall aggCall = (RexCall) winAggCall.accept(replaceConstants); List<SqlNode> operands = toSql(null, aggCall.operands); rexOvers.add(createOverCall(aggFunction, operands, sqlWindow)); } return rexOvers; }