H2 Database Engine 2.3.232 · org.h2.expression.aggregate.Percentile

Modifier and Type	Field and Description
pack-priv static final BigDecimal	HALF BigDecimal value of 0.5.

Access	Constructor and Description
private	Percentile()

Method Summary

Modifier and Type	Method and Description
pack-priv static Index	Returns: the index, or null getColumnIndex(Database the database database, Expression the expression (usually a column expression) on) Get the index (if any) for the column specified in the inverse distribution function.
pack-priv static Value	Returns: the result getFromIndex(SessionLocal the session session, Expression the expression expression, int the data type dataType, ArrayList<QueryOrderBy> ORDER BY list orderByList, BigDecimal argument of percentile function, or 0.5d for median percentile, boolean whether value should be interpolated interpolate) Get the result from the index.
pack-priv static Value	Returns: the result getValue(SessionLocal the session session, Value[] array with values array, int the data type dataType, ArrayList<QueryOrderBy> ORDER BY list orderByList, BigDecimal argument of percentile function, or 0.5d for median percentile, boolean whether value should be interpolated interpolate) Get the result from the array of values.
private static Value	interpolate(Value v0, Value v1, BigDecimal factor, int dataType, SessionLocal session, CompareMode compareMode)
private static BigDecimal	interpolateDecimal(BigDecimal d0, BigDecimal d1, BigDecimal factor)
private static boolean	isNullsLast(DefaultNullOrdering defaultNullOrdering, Index index)
private static BigDecimal	timestampToDecimal(long dateValue, long timeNanos)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

HALF	back to summary
pack-priv static final BigDecimal HALF BigDecimal value of 0.5.

Percentile	back to summary
private Percentile()

getColumnIndex	back to summary
pack-priv static Index getColumnIndex(Database database, Expression on) Get the index (if any) for the column specified in the inverse distribution function. Parameters database:Database the database on:Expression the expression (usually a column expression) Returns:Index the index, or null

getColumnIndex

pack-priv static Index getColumnIndex(Database database, Expression on)

Get the index (if any) for the column specified in the inverse distribution function.

Parameters

Returns:Index

the index, or null

getFromIndex	back to summary
pack-priv static Value getFromIndex(SessionLocal session, Expression expression, int dataType, ArrayList<QueryOrderBy> orderByList, BigDecimal percentile, boolean interpolate) Get the result from the index. Parameters session:SessionLocal the session expression:Expression the expression dataType:int the data type orderByList:ArrayList<QueryOrderBy> ORDER BY list percentile:BigDecimal argument of percentile function, or 0.5d for median interpolate:boolean whether value should be interpolated Returns:Value the result

getFromIndex

pack-priv static Value getFromIndex(SessionLocal session, Expression expression, int dataType, ArrayList<QueryOrderBy> orderByList, BigDecimal percentile, boolean interpolate)

Get the result from the index.

Parameters

Returns:Value

the result

getValue	back to summary
pack-priv static Value getValue(SessionLocal session, Value[] array, int dataType, ArrayList<QueryOrderBy> orderByList, BigDecimal percentile, boolean interpolate) Get the result from the array of values. Parameters session:SessionLocal the session array:Value[] array with values dataType:int the data type orderByList:ArrayList<QueryOrderBy> ORDER BY list percentile:BigDecimal argument of percentile function, or 0.5d for median interpolate:boolean whether value should be interpolated Returns:Value the result

getValue

pack-priv static Value getValue(SessionLocal session, Value[] array, int dataType, ArrayList<QueryOrderBy> orderByList, BigDecimal percentile, boolean interpolate)

Get the result from the array of values.

Parameters

Returns:Value

the result

interpolate	back to summary
private static Value interpolate(Value v0, Value v1, BigDecimal factor, int dataType, SessionLocal session, CompareMode compareMode)

interpolateDecimal	back to summary
private static BigDecimal interpolateDecimal(BigDecimal d0, BigDecimal d1, BigDecimal factor)

isNullsLast	back to summary
private static boolean isNullsLast(DefaultNullOrdering defaultNullOrdering, Index index)

timestampToDecimal	back to summary
private static BigDecimal timestampToDecimal(long dateValue, long timeNanos)