Examples of Decimal128

macromedia.asc.util.Decimal128
org.apache.hadoop.hive.common.type.Decimal128
This code was originally written for Microsoft PolyBase.
A 128-bit fixed-length Decimal value in the ANSI SQL Numeric semantics, representing unscaledValue / 10**scale where scale is 0 or positive.

This class is similar to {@link java.math.BigDecimal}, but a few things differ to conform to the SQL Numeric semantics.

Scale of this object is specified by the user, not automatically determined like {@link java.math.BigDecimal}. This means that underflow is possible depending on the scale. {@link java.math.BigDecimal} controls roundingbehaviors by MathContext, possibly throwing errors. But, underflow is NOT an error in ANSI SQL Numeric. "CAST(0.000000000....0001 AS DECIMAL(38,1))" is "0.0" without an error.

Because this object is fixed-length, overflow is also possible. Overflow IS an error in ANSI SQL Numeric. "CAST(10000 AS DECIMAL(38,38))" throws overflow error.

Each arithmetic operator takes scale as a parameter to control its behavior. It's user's (or query optimizer's) responsibility to give an appropriate scale parameter.

Finally, this class performs MUCH faster than java.math.BigDecimal for a few reasons. Its behavior is simple because of the designs above. This class is fixed-length without array expansion and re-allocation. This class is mutable, allowing reuse of the same object without re-allocation. This class and {@link UnsignedInt128} are designed such that minimal heap-objectallocations are required for most operations. The only exception is division. Even this class requires a few object allocations for division, though much fewer than BigDecimal.
org.apache.qpid.proton.amqp.Decimal128
org.apache.qpid.proton.type.Decimal128

Examples of org.apache.hadoop.hive.common.type.Decimal128

        int batchSize,
        boolean[] isNull) {


      for(int i=0;i<batchSize;++i) {
        if (!isNull[i]) {
          Decimal128 value = vector[i];
          myagg.sumValueWithCheck(value, this.sumScale);
        }
      }
    }

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

        myagg.sum.zeroClear();
        myagg.count = 0;
      }


      for (int i=0;i<batchSize;++i) {
        Decimal128 value = vector[i];
        myagg.sumValueNoCheck(value, this.sumScale);
      }
    }

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

      this.inputExpression = inputExpression;
    }


    public VectorUDAFSumDecimal() {
      super();
      scratchDecimal = new Decimal128();
    }

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

        int[] selected) {


      for (int j=0; j< batchSize; ++j) {
        int i = selected[j];
        if (!isNull[i]) {
          Decimal128 value = vector[i];
          if (myagg.isNull) {
            myagg.isNull = false;
            myagg.sum.zeroClear();
          }
          myagg.sum.addDestructive(value, scale);

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

        myagg.sum.zeroClear();
        myagg.isNull = false;
      }


      for (int i=0; i< batchSize; ++i) {
        Decimal128 value = vector[selected[i]];
        myagg.sum.addDestructive(value, scale);
      }
    }

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

        int batchSize,
        boolean[] isNull) {


      for(int i=0;i<batchSize;++i) {
        if (!isNull[i]) {
          Decimal128 value = vector[i];
          if (myagg.isNull) {
            myagg.sum.zeroClear();
            myagg.isNull = false;
          }
          myagg.sum.addDestructive(value, scale);

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

        myagg.sum.zeroClear();
        myagg.isNull = false;
      }


      for (int i=0;i<batchSize;++i) {
        Decimal128 value = vector[i];
        myagg.sum.addDestructive(value, scale);
      }
    }

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

    ExprNodeDesc child = childExpr.get(0);
    String inputType = childExpr.get(0).getTypeString();
    if (child instanceof ExprNodeConstantDesc) {
      // Return a constant vector expression
      Object constantValue = ((ExprNodeConstantDesc) child).getValue();
      Decimal128 decimalValue = castConstantToDecimal(constantValue, child.getTypeInfo());
      return getConstantVectorExpression(decimalValue, returnType, Mode.PROJECTION);
    }
    if (isIntFamily(inputType)) {
      return createVectorExpression(CastLongToDecimal.class, childExpr, Mode.PROJECTION, returnType);
    } else if (isFloatFamily(inputType)) {

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

  }


  private Decimal128 castConstantToDecimal(Object scalar, TypeInfo type) throws HiveException {
    PrimitiveTypeInfo ptinfo = (PrimitiveTypeInfo) type;
    String typename = type.getTypeName();
    Decimal128 d = new Decimal128();
    int scale = HiveDecimalUtils.getScaleForType(ptinfo);
    switch (ptinfo.getPrimitiveCategory()) {
      case FLOAT:
        float floatVal = ((Float) scalar).floatValue();
        d.update(floatVal, (short) scale);
        break;
      case DOUBLE:
        double doubleVal = ((Double) scalar).doubleValue();
        d.update(doubleVal, (short) scale);
        break;
      case BYTE:
        byte byteVal = ((Byte) scalar).byteValue();
        d.update(byteVal, (short) scale);
        break;
      case SHORT:
        short shortVal = ((Short) scalar).shortValue();
        d.update(shortVal, (short) scale);
        break;
      case INT:
        int intVal = ((Integer) scalar).intValue();
        d.update(intVal, (short) scale);
        break;
      case LONG:
        long longVal = ((Long) scalar).longValue();
        d.update(longVal, (short) scale);
        break;
      case DECIMAL:
        HiveDecimal decimalVal = (HiveDecimal) scalar;
        d.update(decimalVal.unscaledValue(), (short) scale);
        break;
      default:
        throw new HiveException("Unsupported type "+typename+" for cast to Decimal128");
    }
    return d;

View Full Code Here

Examples of org.apache.hadoop.hive.common.type.Decimal128

      } else {
        return 0;
      }
    } else if (decimalTypePattern.matcher(constDesc.getTypeString()).matches()) {
      HiveDecimal hd = (HiveDecimal) constDesc.getValue();
      Decimal128 dvalue = new Decimal128();
      dvalue.update(hd.unscaledValue(), (short) hd.scale());
      return dvalue;
    } else {
      return constDesc.getValue();
    }
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.