private HiveExtractDate(String name) { super(name, SqlKind.EXTRACT, ReturnTypes.cascade(ReturnTypes.INTEGER, SqlTypeTransforms.FORCE_NULLABLE), null, OperandTypes.INTERVALINTERVAL_INTERVALDATETIME, SqlFunctionCategory.SYSTEM); }
public SqlCoalesceFunction() { // NOTE jvs 26-July-2006: We fill in the type strategies here, // but normally they are not used because the validator invokes // rewriteCall to convert COALESCE into CASE early. However, // validator rewrite can optionally be disabled, in which case these // strategies are used. super("COALESCE", SqlKind.COALESCE, ReturnTypes.cascade(ReturnTypes.LEAST_RESTRICTIVE, SqlTypeTransforms.LEAST_NULLABLE), null, OperandTypes.SAME_VARIADIC, SqlFunctionCategory.SYSTEM); }
public SqlCoalesceFunction() { // NOTE jvs 26-July-2006: We fill in the type strategies here, // but normally they are not used because the validator invokes // rewriteCall to convert COALESCE into CASE early. However, // validator rewrite can optionally be disabled, in which case these // strategies are used. super("COALESCE", SqlKind.COALESCE, ReturnTypes.cascade(ReturnTypes.LEAST_RESTRICTIVE, SqlTypeTransforms.LEAST_NULLABLE), null, OperandTypes.SAME_VARIADIC, SqlFunctionCategory.SYSTEM); }
public SqlJsonQueryFunction() { super("JSON_QUERY", SqlKind.OTHER_FUNCTION, ReturnTypes.cascade(ReturnTypes.VARCHAR_2000, SqlTypeTransforms.FORCE_NULLABLE), null, OperandTypes.family(SqlTypeFamily.ANY, SqlTypeFamily.ANY, SqlTypeFamily.ANY, SqlTypeFamily.ANY), SqlFunctionCategory.SYSTEM); }