Package org.apache.calcite.linq4j

Interface OrderedQueryable<T>

Type Parameters:

T - Element type

All Superinterfaces:

Enumerable<T>, ExtendedEnumerable<T>, ExtendedOrderedQueryable<T>, Iterable<T>, Queryable<T>, RawEnumerable<T>, RawQueryable<T>

All Known Implementing Classes:

AbstractQueryable, AbstractTableQueryable, BaseQueryable, CassandraTable.CassandraQueryable, ElasticsearchTable.ElasticsearchQueryable, GeodeTable.GeodeQueryable, InnodbTable.InnodbQueryable, MongoTable.MongoQueryable, QueryableDefaults.NonLeafReplayableQueryable, QueryableDefaults.ReplayableQueryable, QueryProviderImpl.QueryableImpl

public interface OrderedQueryable<T>
extends Queryable<T>, ExtendedOrderedQueryable<T>

Represents the result of applying a sorting operation to a Queryable.

Method Summary

Modifier and Type	Method	Description
T	aggregate(FunctionExpression<Function2<T,T,T>> selector)	Applies an accumulator function over a sequence.
<TAccumulate> TAccumulate	aggregate(TAccumulate seed, FunctionExpression<Function2<TAccumulate,T,TAccumulate>> selector)	Applies an accumulator function over a sequence.
<TAccumulate, TResult> TResult	aggregate(TAccumulate seed, FunctionExpression<Function2<TAccumulate,T,TAccumulate>> func, FunctionExpression<Function1<TAccumulate,TResult>> selector)	Applies an accumulator function over a sequence.
boolean	all(FunctionExpression<Predicate1<T>> predicate)	Determines whether all the elements of a sequence satisfy a condition.
boolean	any(FunctionExpression<Predicate1<T>> predicate)	Determines whether any element of a sequence satisfies a condition.
BigDecimal	averageBigDecimal(FunctionExpression<BigDecimalFunction1<T>> selector)	Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
double	averageDouble(FunctionExpression<DoubleFunction1<T>> selector)	Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
float	averageFloat(FunctionExpression<FloatFunction1<T>> selector)	Computes the average of a sequence of Float values that is obtained by invoking a projection function on each element of the input sequence.
int	averageInteger(FunctionExpression<IntegerFunction1<T>> selector)	Computes the average of a sequence of int values that is obtained by invoking a projection function on each element of the input sequence.
long	averageLong(FunctionExpression<LongFunction1<T>> selector)	Computes the average of a sequence of long values that is obtained by invoking a projection function on each element of the input sequence.
BigDecimal	averageNullableBigDecimal(FunctionExpression<NullableBigDecimalFunction1<T>> selector)	Computes the average of a sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Double	averageNullableDouble(FunctionExpression<NullableDoubleFunction1<T>> selector)	Computes the average of a sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.
Float	averageNullableFloat(FunctionExpression<NullableFloatFunction1<T>> selector)	Computes the average of a sequence of nullable Float values that is obtained by invoking a projection function on each element of the input sequence.
Integer	averageNullableInteger(FunctionExpression<NullableIntegerFunction1<T>> selector)	Computes the average of a sequence of nullable int values that is obtained by invoking a projection function on each element of the input sequence.
Long	averageNullableLong(FunctionExpression<NullableLongFunction1<T>> selector)	Computes the average of a sequence of nullable long values that is obtained by invoking a projection function on each element of the input sequence.
<T2> Queryable<T2>	cast(Class<T2> clazz)	Converts the elements of this Enumerable to the specified type.
Queryable<T>	concat(Enumerable<T> source2)	Concatenates two sequences.
int	count(FunctionExpression<Predicate1<T>> predicate)	Returns the number of elements in the specified sequence that satisfies a condition.
Queryable<T>	defaultIfEmpty()	Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.
Queryable<T>	distinct()	Returns distinct elements from a sequence by using the default equality comparer to compare values.
Queryable<T>	distinct(EqualityComparer<T> comparer)	Returns distinct elements from a sequence by using a specified EqualityComparer<TSource> to compare values.
Queryable<T>	except(Enumerable<T> enumerable)	Produces the set difference of two sequences by using the default equality comparer to compare values, eliminate duplicates.
Queryable<T>	except(Enumerable<T> enumerable, boolean all)	Produces the set difference of two sequences by using the default equality comparer to compare values, using all to indicate whether to eliminate duplicates.
Queryable<T>	except(Enumerable<T> enumerable, EqualityComparer<T> comparer)	Produces the set difference of two sequences by using the specified EqualityComparer<TSource> to compare values, eliminate duplicates.
Queryable<T>	except(Enumerable<T> enumerable, EqualityComparer<T> comparer, boolean all)	Produces the set difference of two sequences by using the specified EqualityComparer<TSource> to compare values, using all to indicate whether to eliminate duplicates.
T	first(FunctionExpression<Predicate1<T>> predicate)	Returns the first element of a sequence that satisfies a specified condition.
T	firstOrDefault(FunctionExpression<Predicate1<T>> predicate)	Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.
<TKey> Queryable<Grouping<TKey,T>>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector)	Groups the elements of a sequence according to a specified key selector function.
<TKey> Queryable<Grouping<TKey,T>>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector, EqualityComparer<TKey> comparer)	Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.
<TKey, TElement> Queryable<Grouping<TKey,TElement>>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function1<T,TElement>> elementSelector)	Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function.
<TKey, TElement> Queryable<Grouping<TKey,TElement>>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function1<T,TElement>> elementSelector, EqualityComparer<TKey> comparer)	Groups the elements of a sequence and projects the elements for each group by using a specified function.
<TKey, TElement, TResult> Queryable<TResult>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function1<T,TElement>> elementSelector, FunctionExpression<Function2<TKey,Enumerable<TElement>,TResult>> resultSelector)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.
<TKey, TElement, TResult> Queryable<TResult>	groupBy(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function1<T,TElement>> elementSelector, FunctionExpression<Function2<TKey,Enumerable<TElement>,TResult>> resultSelector, EqualityComparer<TKey> comparer)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.
<TKey, TResult> Queryable<TResult>	groupByK(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function2<TKey,Enumerable<T>,TResult>> resultSelector)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.
<TKey, TResult> Queryable<TResult>	groupByK(FunctionExpression<Function1<T,TKey>> keySelector, FunctionExpression<Function2<TKey,Enumerable<T>,TResult>> resultSelector, EqualityComparer<TKey> comparer)	Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.
<TInner, TKey, TResult> Queryable<TResult>	groupJoin(Enumerable<TInner> inner, FunctionExpression<Function1<T,TKey>> outerKeySelector, FunctionExpression<Function1<TInner,TKey>> innerKeySelector, FunctionExpression<Function2<T,Enumerable<TInner>,TResult>> resultSelector)	Correlates the elements of two sequences based on key equality and groups the results.
<TInner, TKey, TResult> Queryable<TResult>	groupJoin(Enumerable<TInner> inner, FunctionExpression<Function1<T,TKey>> outerKeySelector, FunctionExpression<Function1<TInner,TKey>> innerKeySelector, FunctionExpression<Function2<T,Enumerable<TInner>,TResult>> resultSelector, EqualityComparer<TKey> comparer)	Correlates the elements of two sequences based on key equality and groups the results.
Queryable<T>	intersect(Enumerable<T> enumerable)	Produces the set intersection of two sequences by using the default equality comparer to compare values, eliminate duplicates.(Defined by Queryable.)
Queryable<T>	intersect(Enumerable<T> enumerable, boolean all)	Produces the set intersection of two sequences by using the default equality comparer to compare values, using all to indicate whether to eliminate duplicates.
Queryable<T>	intersect(Enumerable<T> enumerable, EqualityComparer<T> comparer)	Produces the set intersection of two sequences by using the specified EqualityComparer<TSource> to compare values, eliminate duplicates.
Queryable<T>	intersect(Enumerable<T> enumerable, EqualityComparer<T> comparer, boolean all)	Produces the set intersection of two sequences by using the specified EqualityComparer<TSource> to compare values, using all to indicate whether to eliminate duplicates.
<TInner, TKey, TResult> Queryable<TResult>	join(Enumerable<TInner> inner, FunctionExpression<Function1<T,TKey>> outerKeySelector, FunctionExpression<Function1<TInner,TKey>> innerKeySelector, FunctionExpression<Function2<T,TInner,TResult>> resultSelector)	Correlates the elements of two sequences based on matching keys.
<TInner, TKey, TResult> Queryable<TResult>	join(Enumerable<TInner> inner, FunctionExpression<Function1<T,TKey>> outerKeySelector, FunctionExpression<Function1<TInner,TKey>> innerKeySelector, FunctionExpression<Function2<T,TInner,TResult>> resultSelector, EqualityComparer<TKey> comparer)	Correlates the elements of two sequences based on matching keys.
T	last(FunctionExpression<Predicate1<T>> predicate)	Returns the last element of a sequence that satisfies a specified condition.
T	lastOrDefault(FunctionExpression<Predicate1<T>> predicate)	Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.
long	longCount(FunctionExpression<Predicate1<T>> predicate)	Returns an long that represents the number of elements in a sequence that satisfy a condition.
<TResult extends Comparable<TResult>> @Nullable TResult	max(FunctionExpression<Function1<T,TResult>> selector)	Invokes a projection function on each element of a generic IQueryable<TSource> and returns the maximum resulting value.
<TResult extends Comparable<TResult>> @Nullable TResult	min(FunctionExpression<Function1<T,TResult>> selector)	Invokes a projection function on each element of a generic IQueryable<TSource> and returns the minimum resulting value.
<TResult> Queryable<TResult>	ofType(Class<TResult> clazz)	Filters the elements of an IQueryable based on a specified type.
<TKey extends Comparable> OrderedQueryable<T>	orderBy(FunctionExpression<Function1<T,TKey>> keySelector)	Sorts the elements of a sequence in ascending order according to a key.
<TKey> OrderedQueryable<T>	orderBy(FunctionExpression<Function1<T,TKey>> keySelector, Comparator<TKey> comparator)	Sorts the elements of a sequence in ascending order by using a specified comparer.
<TKey extends Comparable> OrderedQueryable<T>	orderByDescending(FunctionExpression<Function1<T,TKey>> keySelector)	Sorts the elements of a sequence in descending order according to a key.
<TKey> OrderedQueryable<T>	orderByDescending(FunctionExpression<Function1<T,TKey>> keySelector, Comparator<TKey> comparator)	Sorts the elements of a sequence in descending order by using a specified comparer.
Queryable<T>	reverse()	Inverts the order of the elements in a sequence.
<TResult> Queryable<TResult>	select(FunctionExpression<Function1<T,TResult>> selector)	Projects each element of a sequence into a new form.
<TResult> Queryable<TResult>	selectMany(FunctionExpression<Function1<T,Enumerable<TResult>>> selector)	Projects each element of a sequence to an Enumerable<TSource> and combines the resulting sequences into one sequence.
<TCollection, TResult> Queryable<TResult>	selectMany(FunctionExpression<Function2<T,Integer,Enumerable<TCollection>>> collectionSelector, FunctionExpression<Function2<T,TCollection,TResult>> resultSelector)	Projects each element of a sequence to an Enumerable<TSource> that incorporates the index of the source element that produced it.
<TCollection, TResult> Queryable<TResult>	selectManyN(FunctionExpression<Function1<T,Enumerable<TCollection>>> collectionSelector, FunctionExpression<Function2<T,TCollection,TResult>> resultSelector)	Projects each element of a sequence to an Enumerable<TSource> and invokes a result selector function on each element therein.
<TResult> Queryable<TResult>	selectManyN(FunctionExpression<Function2<T,Integer,Enumerable<TResult>>> selector)	Projects each element of a sequence to an Enumerable<TSource> and combines the resulting sequences into one sequence.
<TResult> Queryable<TResult>	selectN(FunctionExpression<Function2<T,Integer,TResult>> selector)	Projects each element of a sequence into a new form by incorporating the element's index.
T	single(FunctionExpression<Predicate1<T>> predicate)	Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.
T	singleOrDefault()	Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.
T	singleOrDefault(FunctionExpression<Predicate1<T>> predicate)	Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.
Queryable<T>	skip(int count)	Bypasses a specified number of elements in a sequence and then returns the remaining elements.
Queryable<T>	skipWhile(FunctionExpression<Predicate1<T>> predicate)	Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.
Queryable<T>	skipWhileN(FunctionExpression<Predicate2<T,Integer>> predicate)	Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.
BigDecimal	sumBigDecimal(FunctionExpression<BigDecimalFunction1<T>> selector)	Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.
double	sumDouble(FunctionExpression<DoubleFunction1<T>> selector)	Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.
float	sumFloat(FunctionExpression<FloatFunction1<T>> selector)	Computes the sum of the sequence of Float values that is obtained by invoking a projection function on each element of the input sequence.
int	sumInteger(FunctionExpression<IntegerFunction1<T>> selector)	Computes the sum of the sequence of int values that is obtained by invoking a projection function on each element of the input sequence.
long	sumLong(FunctionExpression<LongFunction1<T>> selector)	Computes the sum of the sequence of long values that is obtained by invoking a projection function on each element of the input sequence.
BigDecimal	sumNullableBigDecimal(FunctionExpression<NullableBigDecimalFunction1<T>> selector)	Computes the sum of the sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.
Double	sumNullableDouble(FunctionExpression<NullableDoubleFunction1<T>> selector)	Computes the sum of the sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.
Float	sumNullableFloat(FunctionExpression<NullableFloatFunction1<T>> selector)	Computes the sum of the sequence of nullable Float values that is obtained by invoking a projection function on each element of the input sequence.
Integer	sumNullableInteger(FunctionExpression<NullableIntegerFunction1<T>> selector)	Computes the sum of the sequence of nullable int values that is obtained by invoking a projection function on each element of the input sequence.
Long	sumNullableLong(FunctionExpression<NullableLongFunction1<T>> selector)	Computes the sum of the sequence of nullable long values that is obtained by invoking a projection function on each element of the input sequence.
Queryable<T>	take(int count)	Returns a specified number of contiguous elements from the start of a sequence.
Queryable<T>	takeWhile(FunctionExpression<Predicate1<T>> predicate)	Returns elements from a sequence as long as a specified condition is true.
Queryable<T>	takeWhileN(FunctionExpression<Predicate2<T,Integer>> predicate)	Returns elements from a sequence as long as a specified condition is true.
Queryable<T>	union(Enumerable<T> source1)	Produces the set union of two sequences by using the default equality comparer.
Queryable<T>	union(Enumerable<T> source1, EqualityComparer<T> comparer)	Produces the set union of two sequences by using a specified EqualityComparer<TSource>.
Queryable<T>	where(FunctionExpression<? extends Predicate1<T>> predicate)	Filters a sequence of values based on a predicate.
Queryable<T>	whereN(FunctionExpression<? extends Predicate2<T,Integer>> predicate)	Filters a sequence of values based on a predicate.
<T1, TResult> Queryable<TResult>	zip(Enumerable<T1> source1, FunctionExpression<Function2<T,T1,TResult>> resultSelector)	Merges two sequences by using the specified predicate function.

Methods inherited from interface org.apache.calcite.linq4j.Enumerable

asQueryable

Methods inherited from interface org.apache.calcite.linq4j.ExtendedEnumerable

aggregate, aggregate, aggregate, all, any, any, asEnumerable, average, average, average, average, average, average, average, average, average, average, contains, contains, correlateJoin, count, count, defaultIfEmpty, elementAt, elementAtOrDefault, first, first, firstOrDefault, firstOrDefault, foreach, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupBy, groupJoin, groupJoin, hashJoin, hashJoin, hashJoin, hashJoin, into, last, last, lastOrDefault, lastOrDefault, longCount, longCount, max, max, max, max, max, max, max, max, max, max, max, max, min, min, min, min, min, min, min, min, min, min, min, min, orderBy, orderBy, orderByDescending, orderByDescending, removeAll, select, select, selectMany, selectMany, selectMany, selectMany, sequenceEqual, sequenceEqual, single, single, singleOrDefault, skipWhile, skipWhile, sortedGroupBy, sum, sum, sum, sum, sum, sum, sum, sum, sum, sum, takeWhile, takeWhile, toList, toLookup, toLookup, toLookup, toLookup, toMap, toMap, toMap, toMap, where, where, zip

Methods inherited from interface org.apache.calcite.linq4j.ExtendedOrderedQueryable

thenBy, thenBy, thenByDescending, thenByDescending

Methods inherited from interface java.lang.Iterable

forEach, iterator, spliterator

Methods inherited from interface org.apache.calcite.linq4j.RawEnumerable

enumerator

Methods inherited from interface org.apache.calcite.linq4j.RawQueryable

getElementType, getExpression, getProvider

Method Details

aggregate

T aggregate(FunctionExpression<Function2<T,T,T>> selector)

Applies an accumulator function over a sequence.

aggregate

<TAccumulate> TAccumulate aggregate(TAccumulate seed,
 FunctionExpression<Function2<TAccumulate,T,TAccumulate>> selector)

Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value.

aggregate

<TAccumulate,
TResult> TResult aggregate(TAccumulate seed,
 FunctionExpression<Function2<TAccumulate,T,TAccumulate>> func,
 FunctionExpression<Function1<TAccumulate,TResult>> selector)

Applies an accumulator function over a sequence. The specified seed value is used as the initial accumulator value, and the specified function is used to select the result value.

all

boolean all(FunctionExpression<Predicate1<T>> predicate)

Determines whether all the elements of a sequence satisfy a condition.

any

boolean any(FunctionExpression<Predicate1<T>> predicate)

Determines whether any element of a sequence satisfies a condition.

averageBigDecimal

BigDecimal averageBigDecimal(FunctionExpression<BigDecimalFunction1<T>> selector)

Computes the average of a sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.

averageNullableBigDecimal

BigDecimal averageNullableBigDecimal(FunctionExpression<NullableBigDecimalFunction1<T>> selector)

Computes the average of a sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.

averageDouble

double averageDouble(FunctionExpression<DoubleFunction1<T>> selector)

Computes the average of a sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.

averageNullableDouble

Double averageNullableDouble(FunctionExpression<NullableDoubleFunction1<T>> selector)

Computes the average of a sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.

averageInteger

int averageInteger(FunctionExpression<IntegerFunction1<T>> selector)

Computes the average of a sequence of int values that is obtained by invoking a projection function on each element of the input sequence.

averageNullableInteger

Integer averageNullableInteger(FunctionExpression<NullableIntegerFunction1<T>> selector)

Computes the average of a sequence of nullable int values that is obtained by invoking a projection function on each element of the input sequence.

averageFloat

float averageFloat(FunctionExpression<FloatFunction1<T>> selector)

Computes the average of a sequence of Float values that is obtained by invoking a projection function on each element of the input sequence.

averageNullableFloat

Float averageNullableFloat(FunctionExpression<NullableFloatFunction1<T>> selector)

Computes the average of a sequence of nullable Float values that is obtained by invoking a projection function on each element of the input sequence.

averageLong

long averageLong(FunctionExpression<LongFunction1<T>> selector)

Computes the average of a sequence of long values that is obtained by invoking a projection function on each element of the input sequence.

averageNullableLong

Long averageNullableLong(FunctionExpression<NullableLongFunction1<T>> selector)

Computes the average of a sequence of nullable long values that is obtained by invoking a projection function on each element of the input sequence.

concat

Queryable<T> concat(Enumerable<T> source2)

Concatenates two sequences.

Specified by:

concat in interface ExtendedEnumerable<TSource>

count

int count(FunctionExpression<Predicate1<T>> predicate)

Returns the number of elements in the specified sequence that satisfies a condition.

defaultIfEmpty

Queryable<T> defaultIfEmpty()

Returns the elements of the specified sequence or the type parameter's default value in a singleton collection if the sequence is empty.

Specified by:

defaultIfEmpty in interface ExtendedEnumerable<TSource>

distinct

Queryable<T> distinct()

Returns distinct elements from a sequence by using the default equality comparer to compare values.

Specified by:

distinct in interface ExtendedEnumerable<TSource>

distinct

Queryable<T> distinct(EqualityComparer<T> comparer)

Returns distinct elements from a sequence by using a specified EqualityComparer<TSource> to compare values.

Specified by:

distinct in interface ExtendedEnumerable<TSource>

except

Queryable<T> except(Enumerable<T> enumerable)

Produces the set difference of two sequences by using the default equality comparer to compare values, eliminate duplicates. (Defined by Enumerable.)

Specified by:

except in interface ExtendedEnumerable<TSource>

except

Queryable<T> except(Enumerable<T> enumerable,
 boolean all)

Produces the set difference of two sequences by using the default equality comparer to compare values, using all to indicate whether to eliminate duplicates. (Defined by Enumerable.)

Specified by:

except in interface ExtendedEnumerable<TSource>

except

Queryable<T> except(Enumerable<T> enumerable,
 EqualityComparer<T> comparer)

Produces the set difference of two sequences by using the specified EqualityComparer<TSource> to compare values, eliminate duplicates.

Specified by:

except in interface ExtendedEnumerable<TSource>

except

Queryable<T> except(Enumerable<T> enumerable,
 EqualityComparer<T> comparer,
 boolean all)

Produces the set difference of two sequences by using the specified EqualityComparer<TSource> to compare values, using all to indicate whether to eliminate duplicates.

Specified by:

except in interface ExtendedEnumerable<TSource>

first

T first(FunctionExpression<Predicate1<T>> predicate)

Returns the first element of a sequence that satisfies a specified condition.

firstOrDefault

T firstOrDefault(FunctionExpression<Predicate1<T>> predicate)

Returns the first element of a sequence that satisfies a specified condition or a default value if no such element is found.

groupBy

<TKey> Queryable<Grouping<TKey,T>> groupBy(FunctionExpression<Function1<T,TKey>> keySelector)

Groups the elements of a sequence according to a specified key selector function.

groupBy

<TKey> Queryable<Grouping<TKey,T>> groupBy(FunctionExpression<Function1<T,TKey>> keySelector,
 EqualityComparer<TKey> comparer)

Groups the elements of a sequence according to a specified key selector function and compares the keys by using a specified comparer.

groupBy

<TKey,
TElement> Queryable<Grouping<TKey,TElement>> groupBy(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function1<T,TElement>> elementSelector)

Groups the elements of a sequence according to a specified key selector function and projects the elements for each group by using a specified function.

groupBy

<TKey,
TElement> Queryable<Grouping<TKey,TElement>> groupBy(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function1<T,TElement>> elementSelector,
 EqualityComparer<TKey> comparer)

Groups the elements of a sequence and projects the elements for each group by using a specified function. Key values are compared by using a specified comparer.

groupByK

<TKey,
TResult> Queryable<TResult> groupByK(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function2<TKey,Enumerable<T>,TResult>> resultSelector)

Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key.

NOTE: Renamed from groupBy to distinguish from groupBy(org.apache.calcite.linq4j.tree.FunctionExpression, org.apache.calcite.linq4j.tree.FunctionExpression), which has the same erasure.

groupByK

<TKey,
TResult> Queryable<TResult> groupByK(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function2<TKey,Enumerable<T>,TResult>> resultSelector,
 EqualityComparer<TKey> comparer)

Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Keys are compared by using a specified comparer.

groupBy

<TKey,
TElement,
TResult> Queryable<TResult> groupBy(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function1<T,TElement>> elementSelector,
 FunctionExpression<Function2<TKey,Enumerable<TElement>,TResult>> resultSelector)

Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. The elements of each group are projected by using a specified function.

groupBy

<TKey,
TElement,
TResult> Queryable<TResult> groupBy(FunctionExpression<Function1<T,TKey>> keySelector,
 FunctionExpression<Function1<T,TElement>> elementSelector,
 FunctionExpression<Function2<TKey,Enumerable<TElement>,TResult>> resultSelector,
 EqualityComparer<TKey> comparer)

Groups the elements of a sequence according to a specified key selector function and creates a result value from each group and its key. Keys are compared by using a specified comparer and the elements of each group are projected by using a specified function.

groupJoin

<TInner,
TKey,
TResult> Queryable<TResult> groupJoin(Enumerable<TInner> inner,
 FunctionExpression<Function1<T,TKey>> outerKeySelector,
 FunctionExpression<Function1<TInner,TKey>> innerKeySelector,
 FunctionExpression<Function2<T,Enumerable<TInner>,TResult>> resultSelector)

Correlates the elements of two sequences based on key equality and groups the results. The default equality comparer is used to compare keys.

groupJoin

<TInner,
TKey,
TResult> Queryable<TResult> groupJoin(Enumerable<TInner> inner,
 FunctionExpression<Function1<T,TKey>> outerKeySelector,
 FunctionExpression<Function1<TInner,TKey>> innerKeySelector,
 FunctionExpression<Function2<T,Enumerable<TInner>,TResult>> resultSelector,
 EqualityComparer<TKey> comparer)

Correlates the elements of two sequences based on key equality and groups the results. A specified EqualityComparer<TSource> is used to compare keys.

intersect

Queryable<T> intersect(Enumerable<T> enumerable)

Produces the set intersection of two sequences by using the default equality comparer to compare values, eliminate duplicates.(Defined by Queryable.)

Specified by:

intersect in interface ExtendedEnumerable<TSource>

intersect

Queryable<T> intersect(Enumerable<T> enumerable,
 boolean all)

Produces the set intersection of two sequences by using the default equality comparer to compare values, using all to indicate whether to eliminate duplicates. (Defined by Queryable.)

Specified by:

intersect in interface ExtendedEnumerable<TSource>

intersect

Queryable<T> intersect(Enumerable<T> enumerable,
 EqualityComparer<T> comparer)

Produces the set intersection of two sequences by using the specified EqualityComparer<TSource> to compare values, eliminate duplicates.

Specified by:

intersect in interface ExtendedEnumerable<TSource>

intersect

Queryable<T> intersect(Enumerable<T> enumerable,
 EqualityComparer<T> comparer,
 boolean all)

Produces the set intersection of two sequences by using the specified EqualityComparer<TSource> to compare values, using all to indicate whether to eliminate duplicates.

Specified by:

intersect in interface ExtendedEnumerable<TSource>

join

<TInner,
TKey,
TResult> Queryable<TResult> join(Enumerable<TInner> inner,
 FunctionExpression<Function1<T,TKey>> outerKeySelector,
 FunctionExpression<Function1<TInner,TKey>> innerKeySelector,
 FunctionExpression<Function2<T,TInner,TResult>> resultSelector)

Correlates the elements of two sequences based on matching keys. The default equality comparer is used to compare keys.

join

<TInner,
TKey,
TResult> Queryable<TResult> join(Enumerable<TInner> inner,
 FunctionExpression<Function1<T,TKey>> outerKeySelector,
 FunctionExpression<Function1<TInner,TKey>> innerKeySelector,
 FunctionExpression<Function2<T,TInner,TResult>> resultSelector,
 EqualityComparer<TKey> comparer)

Correlates the elements of two sequences based on matching keys. A specified EqualityComparer<TSource> is used to compare keys.

last

T last(FunctionExpression<Predicate1<T>> predicate)

Returns the last element of a sequence that satisfies a specified condition.

lastOrDefault

T lastOrDefault(FunctionExpression<Predicate1<T>> predicate)

Returns the last element of a sequence that satisfies a condition or a default value if no such element is found.

longCount

long longCount(FunctionExpression<Predicate1<T>> predicate)

Returns an long that represents the number of elements in a sequence that satisfy a condition.

max

<TResult extends Comparable<TResult>>
@Nullable TResult max(FunctionExpression<Function1<T,TResult>> selector)

Invokes a projection function on each element of a generic IQueryable<TSource> and returns the maximum resulting value.

min

<TResult extends Comparable<TResult>>
@Nullable TResult min(FunctionExpression<Function1<T,TResult>> selector)

Invokes a projection function on each element of a generic IQueryable<TSource> and returns the minimum resulting value.

ofType

<TResult> Queryable<TResult> ofType(Class<TResult> clazz)

Filters the elements of an IQueryable based on a specified type.

The OfType method generates a MethodCallExpression that represents calling OfType itself as a constructed generic method. It then passes the MethodCallExpression to the CreateQuery(Expression) method of the QueryProvider represented by the Provider property of the source parameter.

The query behavior that occurs as a result of executing an expression tree that represents calling OfType depends on the implementation of the type of the source parameter. The expected behavior is that it filters out any elements in source that are not of type TResult.

NOTE: clazz parameter not present in C# LINQ; necessary because of Java type erasure.

Specified by:

ofType in interface ExtendedEnumerable<TSource>

Type Parameters:

TResult - Target type

Parameters:

clazz - Target type

Returns:

Collection of T2

cast

<T2> Queryable<T2> cast(Class<T2> clazz)

Description copied from interface: ExtendedEnumerable

Converts the elements of this Enumerable to the specified type.

This method is implemented by using deferred execution. The immediate return value is an object that stores all the information that is required to perform the action. The query represented by this method is not executed until the object is enumerated either by calling its RawEnumerable.enumerator() method directly or by using for (... in ...).

If an element cannot be cast to type TResult, the Enumerator.current() method will throw a ClassCastException a exception when the element it accessed. To obtain only those elements that can be cast to type TResult, use the ExtendedEnumerable.ofType(Class) method instead.

Specified by:

cast in interface ExtendedEnumerable<TSource>

See Also:

• EnumerableDefaults.cast(org.apache.calcite.linq4j.Enumerable<TSource>, java.lang.Class<T2>)
• ExtendedEnumerable.ofType(Class)

orderBy

<TKey extends Comparable> OrderedQueryable<T> orderBy(FunctionExpression<Function1<T,TKey>> keySelector)

Sorts the elements of a sequence in ascending order according to a key.

orderBy

<TKey> OrderedQueryable<T> orderBy(FunctionExpression<Function1<T,TKey>> keySelector,
 Comparator<TKey> comparator)

Sorts the elements of a sequence in ascending order by using a specified comparer.

orderByDescending

<TKey extends Comparable> OrderedQueryable<T> orderByDescending(FunctionExpression<Function1<T,TKey>> keySelector)

Sorts the elements of a sequence in descending order according to a key.

orderByDescending

<TKey> OrderedQueryable<T> orderByDescending(FunctionExpression<Function1<T,TKey>> keySelector,
 Comparator<TKey> comparator)

Sorts the elements of a sequence in descending order by using a specified comparer.

reverse

Queryable<T> reverse()

Inverts the order of the elements in a sequence.

Specified by:

reverse in interface ExtendedEnumerable<TSource>

select

<TResult> Queryable<TResult> select(FunctionExpression<Function1<T,TResult>> selector)

Projects each element of a sequence into a new form.

selectN

<TResult> Queryable<TResult> selectN(FunctionExpression<Function2<T,Integer,TResult>> selector)

Projects each element of a sequence into a new form by incorporating the element's index.

NOTE: Renamed from select because had same erasure as select(org.apache.calcite.linq4j.tree.FunctionExpression).

selectMany

<TResult> Queryable<TResult> selectMany(FunctionExpression<Function1<T,Enumerable<TResult>>> selector)

Projects each element of a sequence to an Enumerable<TSource> and combines the resulting sequences into one sequence.

selectManyN

<TResult> Queryable<TResult> selectManyN(FunctionExpression<Function2<T,Integer,Enumerable<TResult>>> selector)

Projects each element of a sequence to an Enumerable<TSource> and combines the resulting sequences into one sequence. The index of each source element is used in the projected form of that element.

NOTE: Renamed from selectMany because had same erasure as selectMany(org.apache.calcite.linq4j.tree.FunctionExpression).

selectMany

<TCollection,
TResult> Queryable<TResult> selectMany(FunctionExpression<Function2<T,Integer,Enumerable<TCollection>>> collectionSelector,
 FunctionExpression<Function2<T,TCollection,TResult>> resultSelector)

Projects each element of a sequence to an Enumerable<TSource> that incorporates the index of the source element that produced it. A result selector function is invoked on each element of each intermediate sequence, and the resulting values are combined into a single, one-dimensional sequence and returned.

selectManyN

<TCollection,
TResult> Queryable<TResult> selectManyN(FunctionExpression<Function1<T,Enumerable<TCollection>>> collectionSelector,
 FunctionExpression<Function2<T,TCollection,TResult>> resultSelector)

Projects each element of a sequence to an Enumerable<TSource> and invokes a result selector function on each element therein. The resulting values from each intermediate sequence are combined into a single, one-dimensional sequence and returned.

NOTE: Renamed from selectMany because had same erasure as selectMany(org.apache.calcite.linq4j.tree.FunctionExpression, org.apache.calcite.linq4j.tree.FunctionExpression)

single

T single(FunctionExpression<Predicate1<T>> predicate)

Returns the only element of a sequence that satisfies a specified condition, and throws an exception if more than one such element exists.

singleOrDefault

T singleOrDefault()

Returns the only element of a sequence, or a default value if the sequence is empty; this method throws an exception if there is more than one element in the sequence.

Specified by:

singleOrDefault in interface ExtendedEnumerable<TSource>

singleOrDefault

T singleOrDefault(FunctionExpression<Predicate1<T>> predicate)

Returns the only element of a sequence that satisfies a specified condition or a default value if no such element exists; this method throws an exception if more than one element satisfies the condition.

skip

Queryable<T> skip(int count)

Bypasses a specified number of elements in a sequence and then returns the remaining elements.

Specified by:

skip in interface ExtendedEnumerable<TSource>

skipWhile

Queryable<T> skipWhile(FunctionExpression<Predicate1<T>> predicate)

Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements.

skipWhileN

Queryable<T> skipWhileN(FunctionExpression<Predicate2<T,Integer>> predicate)

Bypasses elements in a sequence as long as a specified condition is true and then returns the remaining elements. The element's index is used in the logic of the predicate function.

sumBigDecimal

BigDecimal sumBigDecimal(FunctionExpression<BigDecimalFunction1<T>> selector)

Computes the sum of the sequence of Decimal values that is obtained by invoking a projection function on each element of the input sequence.

sumNullableBigDecimal

BigDecimal sumNullableBigDecimal(FunctionExpression<NullableBigDecimalFunction1<T>> selector)

Computes the sum of the sequence of nullable Decimal values that is obtained by invoking a projection function on each element of the input sequence.

sumDouble

double sumDouble(FunctionExpression<DoubleFunction1<T>> selector)

Computes the sum of the sequence of Double values that is obtained by invoking a projection function on each element of the input sequence.

sumNullableDouble

Double sumNullableDouble(FunctionExpression<NullableDoubleFunction1<T>> selector)

Computes the sum of the sequence of nullable Double values that is obtained by invoking a projection function on each element of the input sequence.

sumInteger

int sumInteger(FunctionExpression<IntegerFunction1<T>> selector)

Computes the sum of the sequence of int values that is obtained by invoking a projection function on each element of the input sequence.

sumNullableInteger

Integer sumNullableInteger(FunctionExpression<NullableIntegerFunction1<T>> selector)

Computes the sum of the sequence of nullable int values that is obtained by invoking a projection function on each element of the input sequence.

sumLong

long sumLong(FunctionExpression<LongFunction1<T>> selector)

Computes the sum of the sequence of long values that is obtained by invoking a projection function on each element of the input sequence.

sumNullableLong

Long sumNullableLong(FunctionExpression<NullableLongFunction1<T>> selector)

Computes the sum of the sequence of nullable long values that is obtained by invoking a projection function on each element of the input sequence.

sumFloat

float sumFloat(FunctionExpression<FloatFunction1<T>> selector)

Computes the sum of the sequence of Float values that is obtained by invoking a projection function on each element of the input sequence.

sumNullableFloat

Float sumNullableFloat(FunctionExpression<NullableFloatFunction1<T>> selector)

Computes the sum of the sequence of nullable Float values that is obtained by invoking a projection function on each element of the input sequence.

take

Queryable<T> take(int count)

Returns a specified number of contiguous elements from the start of a sequence.

Specified by:

take in interface ExtendedEnumerable<TSource>

takeWhile

Queryable<T> takeWhile(FunctionExpression<Predicate1<T>> predicate)

Returns elements from a sequence as long as a specified condition is true.

takeWhileN

Queryable<T> takeWhileN(FunctionExpression<Predicate2<T,Integer>> predicate)

Returns elements from a sequence as long as a specified condition is true. The element's index is used in the logic of the predicate function.

union

Queryable<T> union(Enumerable<T> source1)

Produces the set union of two sequences by using the default equality comparer.

Specified by:

union in interface ExtendedEnumerable<TSource>

union

Queryable<T> union(Enumerable<T> source1,
 EqualityComparer<T> comparer)

Produces the set union of two sequences by using a specified EqualityComparer<TSource>.

Specified by:

union in interface ExtendedEnumerable<TSource>

where

Queryable<T> where(FunctionExpression<? extends Predicate1<T>> predicate)

Filters a sequence of values based on a predicate.

whereN

Queryable<T> whereN(FunctionExpression<? extends Predicate2<T,Integer>> predicate)

Filters a sequence of values based on a predicate. Each element's index is used in the logic of the predicate function.

zip

<T1,
TResult> Queryable<TResult> zip(Enumerable<T1> source1,
 FunctionExpression<Function2<T,T1,TResult>> resultSelector)

Merges two sequences by using the specified predicate function.