Interface QOM.SampleTable<R extends Record>

All Superinterfaces:

Fields, GroupField, Named, Qualified, QueryPart, RecordQualifier<R>, SelectField<R>, SelectFieldOrAsterisk, Serializable, Table<R>, TableLike<R>, Typed<R>

Enclosing class:

QOM

public static interface QOM.SampleTable<R extends Record>
extends Table<R>

The TABLESAMPLE operator.

Get a TABLESAMPLE expression for this table using the default sample method.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
Table<R>	$arg1()
default QOM.SampleTable<R>	$arg1(Table<R> newArg1)
Field<? extends Number>	$arg2()
default QOM.SampleTable<R>	$arg2(Field<? extends Number> newArg2)
QOM.SampleMethod	$arg3()
default QOM.SampleTable<R>	$arg3(QOM.SampleMethod newArg3)
QOM.SampleSizeType	$arg4()
default QOM.SampleTable<R>	$arg4(QOM.SampleSizeType newArg4)
Field<? extends Number>	$arg5()
default QOM.SampleTable<R>	$arg5(Field<? extends Number> newArg5)
default @NotNull List<?>	$args()
@NotNull Function5<? super Table<R>, ? super Field<? extends Number>, ? super QOM.SampleMethod, ? super QOM.SampleSizeType, ? super Field<? extends Number>, ? extends QOM.SampleTable<R>>	$constructor()
default @Nullable QOM.SampleMethod	$method()
default @NotNull QOM.SampleTable<R>	$method(QOM.SampleMethod newMethod)
default QueryPart	$replace(Replacer replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
default @Nullable Field<? extends Number>	$seed()
default @NotNull QOM.SampleTable<R>	$seed(Field<? extends Number> newSeed)
default @NotNull Field<? extends Number>	$size()
default @NotNull QOM.SampleTable<R>	$size(Field<? extends Number> newSize)
default @Nullable QOM.SampleSizeType	$sizeType()
default @NotNull QOM.SampleTable<R>	$sizeType(QOM.SampleSizeType newSizeType)
default @NotNull Table<R>	$table()
default @NotNull QOM.SampleTable<R>	$table(Table<R> newTable)
default <T> T	$traverse(Traverser<?,T> traverser)	Traverser this QueryPart expression tree using a composable Traverser, producing a result.

Methods inherited from interface Fields

dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsIncludingHidden, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types

Methods inherited from interface Named

$name, getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface Qualified

$schema, getCatalog, getSchema

Methods inherited from interface QueryPart

$replace, $traverse, hashCode, toString

Methods inherited from interface RecordQualifier

getDataType, getPackage, getRecordType, newRecord

Methods inherited from interface SelectField

as, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo

Methods inherited from interface Table

as, as, as, as, as, as, as, as, as, as, as, as, as, as, as, asOfScn, asOfScn, asOfTimestamp, asOfTimestamp, asterisk, at, at, at, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, for_, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, forPortionOf, from, fullHashJoin, fullHashJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullLoopJoin, fullLoopJoin, fullMergeJoin, fullMergeJoin, fullOuterHashJoin, fullOuterHashJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterLoopJoin, fullOuterLoopJoin, fullOuterMergeJoin, fullOuterMergeJoin, getChecks, getIdentity, getIndexes, getKeys, getOptions, getPrimaryKey, getRecordTimestamp, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getTableType, getTriggers, getUniqueKeys, hashJoin, hashJoin, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerHashJoin, innerHashJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerLoopJoin, innerLoopJoin, innerMergeJoin, innerMergeJoin, join, join, join, join, join, join, join, join, join, leftAntiJoin, leftAntiJoin, leftHashJoin, leftHashJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftLoopJoin, leftLoopJoin, leftMergeJoin, leftMergeJoin, leftOuterHashJoin, leftOuterHashJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterLoopJoin, leftOuterLoopJoin, leftOuterMergeJoin, leftOuterMergeJoin, leftSemiJoin, leftSemiJoin, loopJoin, loopJoin, mergeJoin, mergeJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalFullOuterJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, pivot, recordType, rightHashJoin, rightHashJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightLoopJoin, rightLoopJoin, rightMergeJoin, rightMergeJoin, rightOuterHashJoin, rightOuterHashJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterLoopJoin, rightOuterLoopJoin, rightOuterMergeJoin, rightOuterMergeJoin, rowid, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, tablesample, tablesample, tablesampleBernoulli, tablesampleBernoulli, tablesampleSystem, tablesampleSystem, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, where, where, where, where, where, where, where, where, whereExists, whereNotExists, with, with, with, with, withOrdinality

Methods inherited from interface TableLike

asMultiset, asMultiset, asMultiset, asMultiset, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable, asTable

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Method Details

$table

@NotNull
default @NotNull Table<R> $table()

$table

@CheckReturnValue
@NotNull
default @NotNull QOM.SampleTable<R> $table(Table<R> newTable)

$size

@NotNull
default @NotNull Field<? extends Number> $size()

$size

@CheckReturnValue
@NotNull
default @NotNull QOM.SampleTable<R> $size(Field<? extends Number> newSize)

$method

@Nullable
default @Nullable QOM.SampleMethod $method()

$method

@CheckReturnValue
@NotNull
default @NotNull QOM.SampleTable<R> $method(QOM.SampleMethod newMethod)

$sizeType

@Nullable
default @Nullable QOM.SampleSizeType $sizeType()

$sizeType

@CheckReturnValue
@NotNull
default @NotNull QOM.SampleTable<R> $sizeType(QOM.SampleSizeType newSizeType)

$seed

@Nullable
default @Nullable Field<? extends Number> $seed()

$seed

@CheckReturnValue
@NotNull
default @NotNull QOM.SampleTable<R> $seed(Field<? extends Number> newSeed)

$arg1

Table<R> $arg1()

$arg2

Field<? extends Number> $arg2()

$arg3

QOM.SampleMethod $arg3()

$arg4

QOM.SampleSizeType $arg4()

$arg5

Field<? extends Number> $arg5()

$arg1

@CheckReturnValue
@NotNull
default QOM.SampleTable<R> $arg1(Table<R> newArg1)

$arg2

@CheckReturnValue
@NotNull
default QOM.SampleTable<R> $arg2(Field<? extends Number> newArg2)

$arg3

@CheckReturnValue
@NotNull
default QOM.SampleTable<R> $arg3(QOM.SampleMethod newArg3)

$arg4

@CheckReturnValue
@NotNull
default QOM.SampleTable<R> $arg4(QOM.SampleSizeType newArg4)

$arg5

@CheckReturnValue
@NotNull
default QOM.SampleTable<R> $arg5(Field<? extends Number> newArg5)

$constructor

@NotNull
@NotNull Function5<? super Table<R>, ? super Field<? extends Number>, ? super QOM.SampleMethod, ? super QOM.SampleSizeType, ? super Field<? extends Number>, ? extends QOM.SampleTable<R>> $constructor()

$args

@NotNull
default @NotNull List<?> $args()

$traverse

default <T> T $traverse(Traverser<?,T> traverser)

Description copied from interface: QueryPart

Traverser this QueryPart expression tree using a composable Traverser, producing a result.

This offers a generic way to traverse expression trees to translate the tree to arbitrary other data structures. The simplest traversal would just count all the tree elements:

int count = CUSTOMER.NAME.eq(1).$traverse(0, (i, p) -> i + 1);

The same can be achieved by translating the JDK Collector API to the Traverser API using Traversers.collecting(Collector).

CUSTOMER.NAME.eq(1).$traverse(Traversers.collecting(Collectors.counting()));

Unlike a Collector, a Traverser is optimised for tree traversal, not stream traversal:

• Is not designed for parallelism
• It can Traverser.abort() traversal early when the result can be produced early (e.g. when running Traversers.containing(QueryPart), and a result has been found).
• It can decide whether to Traverser.recurse() into a QueryPart subtree, or whether that is not necessary or even undesirable, e.g. to prevent entering new subquery scopes.
• Unlike a Collector, which can use its Collector.accumulator() to accumulate each element only once, in tree traversal, it's desirable to be able to distinguish between accumulating an item Traverser.before() or Traverser.after() recursing into it. This is useful e.g. to wrap each tree node in XML opening and closing tags.

This is a commercial jOOQ edition only feature.

Specified by:

$traverse in interface QueryPart

$replace

@NotNull
default QueryPart $replace(Replacer replacer)

Description copied from interface: QueryPart

Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.

While replacing contents, this QueryPart isn't modified. Instead, a new object is returned.

This is a commercial jOOQ edition only feature.

Specified by:

$replace in interface QueryPart