prestodb/presto · error · PrestoException

DIVISION_BY_ZERO

DIVISION_BY_ZERO

Error message

Division by zero

What it means

Arithmetic error from decimal division (divideShortShortShort): the divisor is zero, so the division cannot proceed. Unlike integer division, decimal division checks the zero divisor explicitly and reports Division by zero with NUMERIC_VALUE_OUT_OF_RANGE.

Source

Thrown at presto-main-base/src/main/java/com/facebook/presto/type/DecimalOperators.java:345

                            .withExtraParameters(DecimalOperators::divideRescaleFactor)))
                .build();
    }

    private static List<Object> divideRescaleFactor(PolymorphicScalarFunctionBuilder.SpecializeContext context)
    {
        DecimalType returnType = (DecimalType) context.getReturnType();
        int dividendScale = toIntExact(requireNonNull(context.getLiteral("a_scale"), "a_scale is null"));
        int divisorScale = toIntExact(requireNonNull(context.getLiteral("b_scale"), "b_scale is null"));
        int resultScale = returnType.getScale();
        int rescaleFactor = resultScale - dividendScale + divisorScale;
        return ImmutableList.of(rescaleFactor);
    }

    @UsedByGeneratedCode
    public static long divideShortShortShort(long dividend, long divisor, int rescaleFactor)
    {
        if (divisor == 0) {
            throw new PrestoException(DIVISION_BY_ZERO, "Division by zero");
        }

        if (dividend == 0) {
            return 0;
        }

        int resultSignum = signum(dividend) * signum(divisor);

        long unsignedDividend = abs(dividend);
        long unsignedDivisor = abs(divisor);

        long rescaledUnsignedDividend = unsignedDividend * longTenToNth(rescaleFactor);
        long quotient = rescaledUnsignedDividend / unsignedDivisor;
        long remainder = rescaledUnsignedDividend - (quotient * unsignedDivisor);

        if (Long.compareUnsigned(remainder * 2, unsignedDivisor) >= 0) {
            quotient++;
        }

View on GitHub (pinned to 55bb57d202)

Solutions

1. Filter or guard zero divisors: CASE WHEN b = 0 THEN NULL ELSE a/b END
2. Clean the data so decimal divisor columns contain no zeros
3. Use try(a / b) to return NULL on division by zero

When it happens

Trigger: Thrown at presto-main-base/src/main/java/com/facebook/presto/type/DecimalOperators.java:345 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of prestodb/presto@55bb57d202 (2026-09-04). Data as JSON: /api/errors/73b73052776ce918. Report an issue: GitHub.