org.apache.calcite.sql2rel.StandardConvertletTable.TimestampDiffConvertlet Class Reference

Inheritance diagram for org.apache.calcite.sql2rel.StandardConvertletTable.TimestampDiffConvertlet:

Collaboration diagram for org.apache.calcite.sql2rel.StandardConvertletTable.TimestampDiffConvertlet:

Public Member Functions
RexNode	convertCall (SqlRexContext cx, SqlCall call)

Detailed Description

Convertlet that handles the

TIMESTAMPDIFF 

function.

Definition at line 1427 of file StandardConvertletTable.java.

Member Function Documentation

RexNode org.apache.calcite.sql2rel.StandardConvertletTable.TimestampDiffConvertlet.convertCall ( SqlRexContext  cx, SqlCall  call  )

inline

Definition at line 1428 of file StandardConvertletTable.java.

                                                               {
      // TIMESTAMPDIFF(unit, t1, t2)
      //    => (t2 - t1) UNIT
      final RexBuilder rexBuilder = cx.getRexBuilder();
      final SqlLiteral unitLiteral = call.operand(0);
      TimeUnit unit = unitLiteral.symbolValue(TimeUnit.class);
      BigDecimal multiplier = BigDecimal.ONE;
      BigDecimal divider = BigDecimal.ONE;
      SqlTypeName sqlTypeName =
              unit == TimeUnit.NANOSECOND ? SqlTypeName.BIGINT : SqlTypeName.INTEGER;
      switch (unit) {
        case MICROSECOND:
        case MILLISECOND:
        case NANOSECOND:
        case WEEK:
          multiplier = BigDecimal.valueOf(DateTimeUtils.MILLIS_PER_SECOND);
          divider = unit.multiplier;
          unit = TimeUnit.SECOND;
          break;
        case QUARTER:
          divider = unit.multiplier;
          unit = TimeUnit.MONTH;
          break;
      }
      final SqlIntervalQualifier qualifier =
              new SqlIntervalQualifier(unit, null, SqlParserPos.ZERO);
      final RexNode op2 = cx.convertExpression(call.operand(2));
      final RexNode op1 = cx.convertExpression(call.operand(1));
      final RelDataType intervalType = cx.getTypeFactory().createTypeWithNullability(
              cx.getTypeFactory().createSqlIntervalType(qualifier),
              op1.getType().isNullable() || op2.getType().isNullable());
      final RexCall rexCall = (RexCall) rexBuilder.makeCall(
              intervalType, SqlStdOperatorTable.MINUS_DATE, ImmutableList.of(op2, op1));
      final RelDataType intType = cx.getTypeFactory().createTypeWithNullability(
              cx.getTypeFactory().createSqlType(sqlTypeName),
              SqlTypeUtil.containsNullable(rexCall.getType()));
      RexNode e = rexBuilder.makeCast(intType, rexCall);
      return rexBuilder.multiplyDivide(e, multiplier, divider);
    }

---

The documentation for this class was generated from the following file:

• /home/jenkins-slave/workspace/core-os-doxygen/java/calcite/src/main/java/org/apache/calcite/sql2rel/StandardConvertletTable.java