How to use

sequence

method

in

org.apache.calcite.sql.type.OperandTypes

private HiveFloorDate(String name) {
 super(name, SqlKind.FLOOR, ReturnTypes.ARG0_OR_EXACT_NO_SCALE, null,
   OperandTypes.sequence(
     "'" + SqlKind.FLOOR + "(<DATE> TO <TIME_UNIT>)'\n"
     + "'" + SqlKind.FLOOR + "(<TIME> TO <TIME_UNIT>)'\n"
     + "'" + SqlKind.FLOOR + "(<TIMESTAMP> TO <TIME_UNIT>)'",
     OperandTypes.DATETIME,
     OperandTypes.ANY),
   SqlFunctionCategory.NUMERIC);
}

private HiveFloorDate(String name) {
 super(name, SqlKind.FLOOR, ReturnTypes.ARG0_OR_EXACT_NO_SCALE, null,
   OperandTypes.sequence(
     "'" + SqlKind.FLOOR + "(<DATE> TO <TIME_UNIT>)'\n"
     + "'" + SqlKind.FLOOR + "(<TIME> TO <TIME_UNIT>)'\n"
     + "'" + SqlKind.FLOOR + "(<TIMESTAMP> TO <TIME_UNIT>)'",
     OperandTypes.DATETIME,
     OperandTypes.ANY),
   SqlFunctionCategory.NUMERIC);
}

 QuantileSqlAggFunction()
 {
  super(
    NAME,
    null,
    SqlKind.OTHER_FUNCTION,
    ReturnTypes.explicit(SqlTypeName.DOUBLE),
    null,
    OperandTypes.or(
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE1, OperandTypes.ANY, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC)
      ),
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE2, OperandTypes.ANY, OperandTypes.LITERAL, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC, SqlTypeFamily.EXACT_NUMERIC)
      )
    ),
    SqlFunctionCategory.NUMERIC,
    false,
    false
  );
 }
}

SqlOverlapsOperator(SqlKind kind) {
 super(kind.sql, kind, 30, true, ReturnTypes.BOOLEAN_NULLABLE,
   InferTypes.FIRST_KNOWN,
   OperandTypes.sequence("'<PERIOD> " + kind.sql + " <PERIOD>'",
     OperandTypes.PERIOD, OperandTypes.PERIOD));
}

SqlOverlapsOperator(SqlKind kind) {
 super(kind.sql, kind, 30, true, ReturnTypes.BOOLEAN_NULLABLE,
   InferTypes.FIRST_KNOWN,
   OperandTypes.sequence("'<PERIOD> " + kind.sql + " <PERIOD>'",
     OperandTypes.PERIOD, OperandTypes.PERIOD));
}

public SqlFloorFunction(SqlKind kind) {
 super(kind.name(), kind, ReturnTypes.ARG0_OR_EXACT_NO_SCALE, null,
   OperandTypes.or(OperandTypes.NUMERIC_OR_INTERVAL,
     OperandTypes.sequence(
       "'" + kind + "(<DATE> TO <TIME_UNIT>)'\n"
       + "'" + kind + "(<TIME> TO <TIME_UNIT>)'\n"
       + "'" + kind + "(<TIMESTAMP> TO <TIME_UNIT>)'",
       OperandTypes.DATETIME,
       OperandTypes.ANY)),
   SqlFunctionCategory.NUMERIC);
 Preconditions.checkArgument(kind == SqlKind.FLOOR || kind == SqlKind.CEIL);
}

public SqlFloorFunction(SqlKind kind) {
 super(kind.name(), kind, ReturnTypes.ARG0_OR_EXACT_NO_SCALE, null,
   OperandTypes.or(OperandTypes.NUMERIC_OR_INTERVAL,
     OperandTypes.sequence(
       "'" + kind + "(<DATE> TO <TIME_UNIT>)'\n"
       + "'" + kind + "(<TIME> TO <TIME_UNIT>)'\n"
       + "'" + kind + "(<TIMESTAMP> TO <TIME_UNIT>)'",
       OperandTypes.DATETIME,
       OperandTypes.ANY)),
   SqlFunctionCategory.NUMERIC);
 Preconditions.checkArgument(kind == SqlKind.FLOOR || kind == SqlKind.CEIL);
}

 QuantileSqlAggFunction()
 {
  super(
    NAME,
    null,
    SqlKind.OTHER_FUNCTION,
    ReturnTypes.explicit(SqlTypeName.DOUBLE),
    null,
    OperandTypes.or(
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE1, OperandTypes.ANY, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC)
      ),
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE2, OperandTypes.ANY, OperandTypes.LITERAL, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC, SqlTypeFamily.EXACT_NUMERIC)
      )
    ),
    SqlFunctionCategory.NUMERIC,
    false,
    false
  );
 }
}

 QuantileSqlAggFunction()
 {
  super(
    NAME,
    null,
    SqlKind.OTHER_FUNCTION,
    ReturnTypes.explicit(SqlTypeName.DOUBLE),
    null,
    OperandTypes.or(
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE1, OperandTypes.ANY, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC)
      ),
      OperandTypes.and(
        OperandTypes.sequence(SIGNATURE2, OperandTypes.ANY, OperandTypes.LITERAL, OperandTypes.LITERAL),
        OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.NUMERIC, SqlTypeFamily.EXACT_NUMERIC)
      )
    ),
    SqlFunctionCategory.NUMERIC,
    false,
    false
  );
 }
}

public SqlDatePartOperator() {
 super(
   "DATE_PART",
   SqlKind.OTHER_FUNCTION,
   ReturnTypes.BIGINT_NULLABLE,
   null,
   OperandTypes.sequence(
     "<PERIOD LITERAL>, <DATE or TIMESTAMP or INTERVAL>",
     new EnumeratedListChecker(VALID_PERIODS.keySet()),
     OperandTypes.or(
       OperandTypes.family(SqlTypeFamily.DATE),
       OperandTypes.family(SqlTypeFamily.TIMESTAMP),
       OperandTypes.family(SqlTypeFamily.DATETIME),
       OperandTypes.family(SqlTypeFamily.DATETIME_INTERVAL),
       OperandTypes.family(SqlTypeFamily.INTERVAL_DAY_TIME),
       OperandTypes.family(SqlTypeFamily.INTERVAL_YEAR_MONTH))
     ),
     SqlFunctionCategory.SYSTEM);
}