How to use

org.apache.calcite.sql.validate.SqlValidatorImpl$NavigationExpander

constructor

  inner.accept(new NavigationExpander(call.getOperator(), offset));
if (op != null) {
  newInnerNode = op.createCall(SqlParserPos.ZERO, newInnerNode,
for (SqlNode node : operands) {
  if (node != null) {
    SqlNode newNode = node.accept(new NavigationExpander());
    if (op != null) {
      newNode = op.createCall(SqlParserPos.ZERO, newNode, offset);

private SqlNode navigationInMeasure(SqlNode node, boolean allRows) {
  final Set<String> prefix = node.accept(new PatternValidator(true));
  Util.discard(prefix);
  final List<SqlNode> ops = ((SqlCall) node).getOperandList();
  final SqlOperator defaultOp =
    allRows ? SqlStdOperatorTable.RUNNING : SqlStdOperatorTable.FINAL;
  final SqlNode op0 = ops.get(0);
  if (!isRunningOrFinal(op0.getKind())
    || !allRows && op0.getKind() == SqlKind.RUNNING) {
    SqlNode newNode = defaultOp.createCall(SqlParserPos.ZERO, op0);
    node = SqlStdOperatorTable.AS.createCall(SqlParserPos.ZERO, newNode, ops.get(1));
  }
  node = new NavigationExpander().go(node);
  return node;
}

  inner.accept(new NavigationExpander(call.getOperator(), offset));
if (op != null) {
 newInnerNode = op.createCall(SqlParserPos.ZERO, newInnerNode,
for (SqlNode node : operands) {
 if (node != null) {
  SqlNode newNode = node.accept(new NavigationExpander());
  if (op != null) {
   newNode = op.createCall(SqlParserPos.ZERO, newNode, offset);

/** Checks that all pattern variables within a function are the same,
 * and canonizes expressions such as {@code PREV(B.price)} to
 * {@code LAST(B.price, 0)}. */
private SqlNode navigationInDefine(SqlNode node, String alpha) {
  Set<String> prefix = node.accept(new PatternValidator(false));
  Util.discard(prefix);
  node = new NavigationExpander().go(node);
  node = new NavigationReplacer(alpha).go(node);
  return node;
}

/** Checks that all pattern variables within a function are the same,
 * and canonizes expressions such as {@code PREV(B.price)} to
 * {@code LAST(B.price, 0)}. */
private SqlNode navigationInDefine(SqlNode node, String alpha) {
 Set<String> prefix = node.accept(new PatternValidator(false));
 Util.discard(prefix);
 node = new NavigationExpander().go(node);
 node = new NavigationReplacer(alpha).go(node);
 return node;
}

/** Checks that all pattern variables within a function are the same,
 * and canonizes expressions such as {@code PREV(B.price)} to
 * {@code LAST(B.price, 0)}. */
private SqlNode navigationInDefine(SqlNode node, String alpha) {
 Set<String> prefix = node.accept(new PatternValidator(false));
 Util.discard(prefix);
 node = new NavigationExpander().go(node);
 node = new NavigationReplacer(alpha).go(node);
 return node;
}

private SqlNode navigationInMeasure(SqlNode node, boolean allRows) {
 final Set<String> prefix = node.accept(new PatternValidator(true));
 Util.discard(prefix);
 final List<SqlNode> ops = ((SqlCall) node).getOperandList();
 final SqlOperator defaultOp =
   allRows ? SqlStdOperatorTable.RUNNING : SqlStdOperatorTable.FINAL;
 final SqlNode op0 = ops.get(0);
 if (!isRunningOrFinal(op0.getKind())
   || !allRows && op0.getKind() == SqlKind.RUNNING) {
  SqlNode newNode = defaultOp.createCall(SqlParserPos.ZERO, op0);
  node = SqlStdOperatorTable.AS.createCall(SqlParserPos.ZERO, newNode, ops.get(1));
 }
 node = new NavigationExpander().go(node);
 return node;
}

private SqlNode navigationInMeasure(SqlNode node, boolean allRows) {
 final Set<String> prefix = node.accept(new PatternValidator(true));
 Util.discard(prefix);
 final List<SqlNode> ops = ((SqlCall) node).getOperandList();
 final SqlOperator defaultOp =
   allRows ? SqlStdOperatorTable.RUNNING : SqlStdOperatorTable.FINAL;
 final SqlNode op0 = ops.get(0);
 if (!isRunningOrFinal(op0.getKind())
   || !allRows && op0.getKind() == SqlKind.RUNNING) {
  SqlNode newNode = defaultOp.createCall(SqlParserPos.ZERO, op0);
  node = SqlStdOperatorTable.AS.createCall(SqlParserPos.ZERO, newNode, ops.get(1));
 }
 node = new NavigationExpander().go(node);
 return node;
}

  inner.accept(new NavigationExpander(call.getOperator(), offset));
if (op != null) {
 newInnerNode = op.createCall(SqlParserPos.ZERO, newInnerNode,
for (SqlNode node : operands) {
 if (node != null) {
  SqlNode newNode = node.accept(new NavigationExpander());
  if (op != null) {
   newNode = op.createCall(SqlParserPos.ZERO, newNode, offset);