Class SubscriptionSnapshotTable
- All Implemented Interfaces:
com.fishlib.base.log.LogOutputAppendable,NotificationQueue.Dependency,Deflatable<Table>,Table,LivenessManager,LivenessNode,LivenessReferent,LongSizedDataStructure,DynamicNode,DynamicTable,NotificationStepReceiver,NotificationStepSource,SubscribableTable,SystemicObject,Serializable
- See Also:
-
Nested Class Summary
Nested classes/interfaces inherited from class com.illumon.iris.db.v2.BaseTable
BaseTable.CopyAttributeOperation, BaseTable.ListenerImpl, BaseTable.ShiftAwareListenerImpl, BaseTable.SwapListenerFactory<T extends SwapListenerBase>Nested classes/interfaces inherited from interface com.illumon.iris.db.tables.Table
Table.AsOfMatchRule, Table.GroupStrategy, Table.RenameFunction -
Field Summary
Fields inherited from class com.illumon.iris.db.v2.BaseTable
attributes, definition, description, PRINT_SERIALIZED_UPDATE_OVERLAPS, sharedAttributesFields inherited from interface com.illumon.iris.db.v2.NotificationStepReceiver
NULL_NOTIFICATION_STEPFields inherited from interface com.illumon.iris.db.tables.Table
ACL_ATTRIBUTE, ADD_ONLY_TABLE_ATTRIBUTE, COLUMN_DESCRIPTIONS_ATTRIBUTE, COLUMN_RENDERERS_ATTRIBUTE, CUSTOM_ACTIONS_ATTRIBUTE, DO_NOT_MAKE_REMOTE_ATTRIBUTE, EMPTY_SOURCE_TABLE_ATTRIBUTE, FILTERABLE_COLUMNS_ATTRIBUTE, HIERARCHICAL_CHILDREN_TABLE_MAP_ATTRIBUTE, HIERARCHICAL_SOURCE_INFO_ATTRIBUTE, HIERARCHICAL_SOURCE_TABLE_ATTRIBUTE, INPUT_TABLE_ATTRIBUTE, KEY_COLUMNS_ATTRIBUTE, LAYOUT_HINTS_ATTRIBUTE, MERGED_TABLE_ATTRIBUTE, NON_DISPLAY_TABLE, PLUGIN_NAME, PREDEFINED_ROLLUP_ATTRIBUTE, PREEMPTIVE_VIEWPORT_TYPE, PREPARED_RLL_ATTRIBUTE, PREVIEW_PARENT_TABLE, REVERSE_LOOKUP_ATTRIBUTE, ROLLUP_LEAF_ATTRIBUTE, SNAPSHOT_VIEWPORT_TYPE, SORTABLE_COLUMNS_ATTRIBUTE, SORTED_COLUMNS_ATTRIBUTE, SYSTEMIC_TABLE_ATTRIBUTE, TABLE_DESCRIPTION_ATTRIBUTE, TOTALS_TABLE_ATTRIBUTE, TREE_TABLE_FILTER_REVERSE_LOOKUP_ATTRIBUTE, UNIQUE_KEYS_ATTRIBUTE, UNTRACKED_LASTBY_TABLE_ATTRIBUTE, VIEWPORT_TYPE_ATTRIBUTE, ZERO_LENGTH_TABLE_ARRAY -
Constructor Summary
ConstructorsConstructorDescriptionSubscriptionSnapshotTable(com.fishlib.io.logger.Logger log, BaseTable originalTable, long updateInterval) -
Method Summary
Modifier and TypeMethodDescriptionabsSumBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the sum of the absolute values for the rest of the fieldsbooleanaddSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int handleId, BitSet columnsToSubscribe, boolean isViewport) Add a subscription to this table.aj(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, Table.AsOfMatchRule asOfMatchRule) Looks up the columns in the rightTable that meet the match conditions in the columnsToMatch list.applyToAllBy(String formulaColumn, String columnParamName, SelectColumn... groupByColumns) Groups data according to groupByColumns and applies formulaColumn to each of columns not altered by the grouping operation.avgBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the average for the rest of the fieldsby(AggregationStateFactory aggregationStateFactory, SelectColumn... groupByColumns) byExternal(boolean dropKeys, String... keyColumnNames) Create aTableMapfrom this table, keyed by the specified columns.countBy(String countColumnName, SelectColumn... groupByColumns) dropColumns(String... columnNames) Identical to naturalJoin, but fail if the right side does not produce a match.firstBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand retrieves the first for the rest of the fieldsflatten()Creates a version of this table with a flat index (V2 only).getColumnSource(String sourceName) Map<String,? extends ColumnSource> Collection<? extends ColumnSource>getIndex()Object[]Returns an object array populated with the column values at the specified rowNo.getSubTable(Index index) head(long size) headPct(double percent) Provides a head that selects a dynamic number of rows based on a percent.booleanisFlat()Return true if this table is guaranteed to be flat.booleanTrue if this table is a snapshot table (as opposed to a preemptive updates table); used byRemoteQueryProcessorto set the isSnapshot flag onExportedTableCreationMessagemessages, so that a client knows if it has an appropriate type of table for its viewport.join(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, int numRightBitsToReserve) Perform a cross join with the right table.lastBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand retrieves the last for the rest of the fieldslazyUpdate(SelectColumn... columns) Compute column formulas on demand.Augments this table with array columns of right-hand side matches.voidMark this object as systemically important.maxBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the max for the rest of the fieldsmedianBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the median for the rest of the fieldsminBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the min for the rest of the fieldsnaturalJoin(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd) Augment this table with zero or one row from the right table.preemptiveSnapshotTable(long updateInterval) preemptiveUpdatesTable(long updateInterval) raj(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, Table.AsOfMatchRule asOfMatchRule) Just like .aj(), but the matching on the last column is in reverse order, so that you find the row after the given timestamp instead of the row before.booleanremoveSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId) Remove a subscription.renameColumns(MatchPair... pairs) reverse()rollup(ComboAggregateFactory comboAggregateFactory, boolean includeConstituents, SelectColumn... columns) select(SelectColumn... columns) selectDistinct(SelectColumn... columns) voidsetAttribute(String key, Object object) Set the value of an attribute.silent()Return an identical table that suppresses all downstream notificationslongsize()The size of this data structure.slice(long firstPositionInclusive, long lastPositionExclusive) Extracts a subset of a table by row position.Snapshot "rightTable", triggered by "this" Table, and return a new Table as a result.snapshotHistory(Table rightTable) snapshotIncremental(Table rightTable, boolean doInitialSnapshot, String... stampColumns) stdBy(SelectColumn... groupByColumns) sumBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the sum for the rest of the fieldstail(long size) tailPct(double percent) Create a hierarchical tree table.Ungroups a table by converting arrays into columns.update(SelectColumn... columns) updateBy(UpdateByControl control, Collection<UpdateByClause> operations, MatchPair... byColumns) Create a table with the sameindexas it's parent that will perform the specified set of row based operations to it.booleanupdateSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, BitSet newSubscribedColumns) Update the subscription's columns.updateView(SelectColumn... columns) booleanupdateViewport(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, Index newViewPort) Update the subscription's viewport (rows).booleanupdateViewportAndColumns(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, Index newViewPort, BitSet columnsToSubscribe) Update the subscription's columns and viewport (rows).validateSelect(SelectColumn... columns) DO NOT USE -- this API is in flux and may change or disappear in the future.varBy(SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the variance for the rest of the fieldsview(SelectColumn... columns) wavgBy(String weightColumn, SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the weighted average using weightColumn for the rest of the fieldswhere(SelectFilter... filters) Filters this table based on the set of values in the rightTable.wouldMatch(WouldMatchPair... matchers) A table operation that applies the supplied predicate to each row in the table and produces columns containing the pass/fail result of the predicate application.wsumBy(String weightColumn, SelectColumn... groupByColumns) Groups the data column according togroupByColumnsand computes the weighted sum using weightColumn for the rest of the fields If the weight column is a floating point type, all result columns will be doubles.Methods inherited from class com.illumon.iris.db.v2.BaseTable
addParentReference, append, awaitUpdate, awaitUpdate, clearSortingRestrictions, copy, copyAttributes, copyAttributes, createSwapListenerIfRefreshing, destroy, getAttribute, getAttributeNames, getAttributes, getDefinition, getDescription, getLastNotificationStep, getNotificationQueue, hasAttribute, initializeWithSnapshot, isAddOnly, isAddOnly, isFailed, isRefreshing, isSystemicObject, layoutHints, listenForDirectUpdates, listenForUpdates, listenForUpdates, notifyListeners, notifyListenersOnError, removeDirectUpdateListener, removeUpdateListener, removeUpdateListener, restrictSortTo, satisfied, setColumnRenderers, setLastNotificationStep, setRefreshing, setTotalsTable, shouldCopyAttribute, toString, withColumnDescription, withKeys, withTableDescription, withUniqueKeysMethods inherited from class com.illumon.iris.db.util.liveness.LivenessArtifact
manageWithCurrentScope, unmanage, unmanageMethods inherited from class com.illumon.iris.db.util.liveness.ReferenceCountedLivenessNode
dropReference, getWeakReference, initializeTransientFieldsForLiveness, onReferenceCountAtZero, tryManage, tryRetainReferenceMethods inherited from class com.illumon.util.referencecounting.ReferenceCounted
decrementReferenceCount, incrementReferenceCount, resetReferenceCount, tryDecrementReferenceCount, tryIncrementReferenceCountMethods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitMethods inherited from interface com.illumon.iris.db.v2.DynamicTable
listenForUpdates, newModifiedColumnSet, newModifiedColumnSetIdentityTransformer, newModifiedColumnSetIdentityTransformer, newModifiedColumnSetTransformer, newModifiedColumnSetTransformer, newModifiedColumnSetTransformer, notifyListenersMethods inherited from interface com.illumon.iris.db.util.liveness.LivenessManager
manage, tryManageMethods inherited from interface com.illumon.iris.db.util.liveness.LivenessReferent
dropReference, getReferentDescription, getWeakReference, retainReference, tryRetainReferenceMethods inherited from interface com.illumon.iris.db.util.LongSizedDataStructure
intSize, intSizeMethods inherited from interface com.illumon.iris.db.tables.Table
absSumBy, absSumBy, absSumBy, aj, aj, aj, aj, aj, apply, applyToAllBy, applyToAllBy, applyToAllBy, avgBy, avgBy, avgBy, by, by, by, by, by, by, byExternal, byteColumnIterator, characterColumnIterator, close, coalesce, columnIterator, countBy, countBy, countBy, dateTimeColumnAsNanos, dateTimeColumnAsNanos, deflate, deflate, doubleColumnIterator, dropColumnFormats, dropColumns, exactJoin, exactJoin, exactJoin, exactJoin, firstBy, firstBy, firstBy, floatColumnIterator, formatColumns, formatColumnWhere, formatRowWhere, getAttributes, getColumn, getColumns, getColumnSource, getMeta, getViewPort, hasColumns, hasColumns, headBy, headBy, integerColumnIterator, isEmpty, isLive, join, join, join, join, join, join, join, join, join, lastBy, lastBy, lastBy, layoutHints, lazyUpdate, lazyUpdate, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, longColumnIterator, maxBy, maxBy, maxBy, medianBy, medianBy, medianBy, minBy, minBy, minBy, moveColumns, moveColumns, moveDownColumns, moveUpColumns, naturalJoin, naturalJoin, naturalJoin, naturalJoin, preemptiveSnapshotTable, raj, raj, raj, raj, raj, releaseCachedResources, renameAllColumns, renameColumns, renameColumns, rollup, rollup, rollup, rollup, rollup, rollup, rollup, select, select, select, selectDistinct, selectDistinct, selectDistinct, shortColumnIterator, sizeForInstrumentation, snapshot, snapshotIncremental, sort, sort, sortDescending, sortDescending, stdBy, stdBy, stdBy, subscribeToPreemptiveUpdates, sumBy, sumBy, sumBy, supportsPreemptiveSubscription, tailBy, tailBy, ungroup, ungroup, ungroup, ungroupAllBut, update, update, updateBy, updateBy, updateBy, updateBy, updateBy, updateView, updateView, validateSelect, varBy, varBy, varBy, view, view, wavgBy, wavgBy, wavgBy, where, where, where, whereIn, whereIn, whereIn, whereNotIn, whereNotIn, whereOneOf, whereOneOf, whereOneOf, withColumnDescription, wouldMatch, wsumBy, wsumBy, wsumBy
-
Constructor Details
-
SubscriptionSnapshotTable
public SubscriptionSnapshotTable(com.fishlib.io.logger.Logger log, BaseTable originalTable, long updateInterval)
-
-
Method Details
-
markSystemic
public void markSystemic()Description copied from interface:SystemicObjectMark this object as systemically important.- Specified by:
markSystemicin interfaceSystemicObject- Overrides:
markSystemicin classBaseTable
-
size
public long size()Description copied from interface:LongSizedDataStructureThe size of this data structure.- Specified by:
sizein interfaceLongSizedDataStructure- Returns:
- The size
-
getIndex
-
getColumnSource
- Specified by:
getColumnSourcein interfaceTable
-
getColumnSourceMap
- Specified by:
getColumnSourceMapin interfaceTable
-
getColumnSources
- Specified by:
getColumnSourcesin interfaceTable
-
getColumn
-
getRecord
Description copied from interface:TableReturns an object array populated with the column values at the specified rowNo. The ordering of columns in the object array is based on the columnNames array provided or by default the column ordering is based on TableDefinition. -
where
-
whereIn
Description copied from interface:TableFilters this table based on the set of values in the rightTable. Note that when the right table ticks, all of the rows in the left table are going to be re-evaluated, thus the intention is that the right table is fairly slow moving compared with the left table. -
getSubTable
- Specified by:
getSubTablein interfaceTable
-
select
-
selectDistinct
- Specified by:
selectDistinctin interfaceTable
-
update
-
lazyUpdate
Description copied from interface:TableCompute column formulas on demand.Lazy update defers computation until required for a set of values, and caches the results for a set of input values. This uses less RAM than an update statement when you have a smaller set of unique values. Less computation than an updateView is needed, because the results are saved in a cache.
If you have many unique values, you should instead use an update statement, which will have more memory efficient structures. Values are never removed from the lazyUpdate cache, so it should be used judiciously on a ticking table.
- Specified by:
lazyUpdatein interfaceTable- Parameters:
columns- the columns to add- Returns:
- a new Table with the columns added; to be computed on demand
-
view
-
updateView
- Specified by:
updateViewin interfaceTable
-
validateSelect
Description copied from interface:TableDO NOT USE -- this API is in flux and may change or disappear in the future.- Specified by:
validateSelectin interfaceTable
-
dropColumns
- Specified by:
dropColumnsin interfaceTable
-
renameColumns
- Specified by:
renameColumnsin interfaceTable
-
slice
Description copied from interface:TableExtracts a subset of a table by row position. If both firstPosition and lastPosition are positive, then the rows are counted from the beginning of the table. The firstPosition is inclusive, and the lastPosition is exclusive. TheTable.head(long)(N) call is equivalent to slice(0, N). The firstPosition must be less than or equal to the lastPosition. If firstPosition is positive and lastPosition is negative, then the firstRow is counted from the beginning of the table, inclusively. The lastPosition is counted from the end of the table. For example, slice(1, -1) includes all rows but the first and last. If the lastPosition would be before the firstRow, the result is an emptyTable. If firstPosition is negative, and lastPosition is zero, then the firstRow is counted from the end of the table, and the end of the slice is the size of the table. slice(-N, 0) is equivalent toTable.tail(long)(N). If the firstPosition is nega tive and the lastPosition is negative, they are both counted from the end of the table. For example, slice(-2, -1) returns the second to last row of the table. -
head
-
tail
-
headPct
Description copied from interface:TableProvides a head that selects a dynamic number of rows based on a percent. -
tailPct
-
leftJoin
Description copied from interface:TableAugments this table with array columns of right-hand side matches.The leftJoin() method returns the exact rows of the leftTable. The data joined in from the rightTable are grouped into arrays of data. When no right-hand side data is found, the right hand columns are null.
- Specified by:
leftJoinin interfaceTable- Parameters:
rightTable- The right side table on the join.columnsToMatch- An array of match pair conditions ("leftColumn=rightColumn" or "columnFoundInBoth")columnsToAdd- An array of the columns from the right side be added to the left side as a result of the match. If empty, then all columns from the right table are added to the result.- Returns:
- a new table joined according to the specification in columnsToMatch and columnsToAdd
-
exactJoin
Description copied from interface:TableIdentical to naturalJoin, but fail if the right side does not produce a match. -
aj
public Table aj(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, Table.AsOfMatchRule asOfMatchRule) Description copied from interface:TableLooks up the columns in the rightTable that meet the match conditions in the columnsToMatch list. Matching is done exactly for the first n-1 columns and via a binary search for the last match pair. The columns of the original table are returned intact, together with the columns from rightTable defined in a comma separated list "columnsToAdd"- Specified by:
ajin interfaceTable- Parameters:
rightTable- The right side table on the join.columnsToMatch- A comma separated list of match conditions ("leftColumn=rightColumn" or "columnFoundInBoth")columnsToAdd- A comma separated list with the columns from the left side that need to be added to the right side as a result of the match.- Returns:
- a new table joined according to the specification in columnsToMatch and columnsToAdd
-
raj
public Table raj(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, Table.AsOfMatchRule asOfMatchRule) Description copied from interface:TableJust like .aj(), but the matching on the last column is in reverse order, so that you find the row after the given timestamp instead of the row before.Looks up the columns in the rightTable that meet the match conditions in the columnsToMatch list. Matching is done exactly for the first n-1 columns and via a binary search for the last match pair. The columns of the original table are returned intact, together with the columns from rightTable defined in a comma separated list "columnsToAdd"
- Specified by:
rajin interfaceTable- Parameters:
rightTable- The right side table on the join.columnsToMatch- A comma separated list of match conditions ("leftColumn=rightColumn" or "columnFoundInBoth")columnsToAdd- A comma separated list with the columns from the left side that need to be added to the right side as a result of the match.- Returns:
- a new table joined according to the specification in columnsToMatch and columnsToAdd
-
naturalJoin
Description copied from interface:TableAugment this table with zero or one row from the right table.The result is somewhat like an Excel vlookup or SQL leftJoin.
- The leftTable always retains the same number of rows and the same columns with which it started.
- If there are no matching values for a row, the appended cell(s) from the rightTable will contain NULL values.
- The right side table can only have one row for each key of the join. If duplicate rows exist on the right side, then the operation's initialization or update results in an error.
When columnsToMatch is empty, then no join keys are used. If there is a row in the right table, it is joined to all rows of the left table. If there are no rows in the right table, then the right columns are null. If there are multiple rows in the right table then there is an error.
- Specified by:
naturalJoinin interfaceTable- Parameters:
rightTable- The right side table on the join.columnsToMatch- An array of match pair conditions ("leftColumn=rightColumn" or "columnFoundInBoth")columnsToAdd- An array of the columns from the right side be added to the left side as a result of the match. If empty, then all columns from the right table are added to the result.- Returns:
- a new table joined according to the specification in columnsToMatch and columnsToAdd
-
join
public Table join(Table rightTable, MatchPair[] columnsToMatch, MatchPair[] columnsToAdd, int numRightBitsToReserve) Description copied from interface:TablePerform a cross join with the right table.Returns a table that is the cartesian product of left rows X right rows, with one column for each of the left table's columns, and one column corresponding to each of the right table's columns that are included in the columnsToAdd argument. The rows are ordered first by the left table then by the right table. If columnsToMatch is non-empty then the product is filtered by the supplied match conditions.
To efficiently produce updates, the bits that represent a key for a given row are split into two. Unless specified, join reserves 16 bits to represent a right row. When there are too few bits to represent all of the right rows for a given aggregation group the table will shift a bit from the left side to the right side. The default of 16 bits was carefully chosen because it results in an efficient implementation to process live updates.
An
OutOfKeySpaceExceptionis thrown when the total number of bits needed to express the result table exceeds that needed to represent Long.MAX_VALUE. There are a few work arounds: - If the left table is sparse, consider flattening the left table. - If there are no key-columns and the right table is sparse, consider flattening the right table. - If the maximum size of a right table's group is small, you can reserve fewer bits by setting numRightBitsToReserve on initialization.Note: If you can prove that a given group has at most one right-row then you should prefer using
Table.naturalJoin(com.illumon.iris.db.tables.Table, com.illumon.iris.db.tables.select.MatchPair[], com.illumon.iris.db.tables.select.MatchPair[]).- Specified by:
joinin interfaceTable- Parameters:
rightTable- The right side table on the join.columnsToMatch- An array of match pair conditions ("leftColumn=rightColumn" or "columnFoundInBoth")columnsToAdd- An array of the columns from the right side that need to be added to the left side as a result of the match.numRightBitsToReserve- The number of bits to reserve for rightTable groups.- Returns:
- a new table joined according to the specification in columnsToMatch and columnsToAdd
-
by
-
headBy
-
tailBy
-
applyToAllBy
public Table applyToAllBy(String formulaColumn, String columnParamName, SelectColumn... groupByColumns) Description copied from interface:TableGroups data according to groupByColumns and applies formulaColumn to each of columns not altered by the grouping operation.columnParamNameis used as place-holder for the name of each column insideformulaColumn.- Specified by:
applyToAllByin interfaceTable- Parameters:
formulaColumn- Formula applied to each columncolumnParamName- The parameter name used as a placeholder for each columngroupByColumns- The grouping columnsTable.by(SelectColumn[])
-
sumBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the sum for the rest of the fields- Specified by:
sumByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
absSumBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the sum of the absolute values for the rest of the fields- Specified by:
absSumByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
avgBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the average for the rest of the fields- Specified by:
avgByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
wavgBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the weighted average using weightColumn for the rest of the fields- Specified by:
wavgByin interfaceTable- Parameters:
weightColumn- the column to use for the weightgroupByColumns- The grouping columnsTable.by(String...)
-
wsumBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the weighted sum using weightColumn for the rest of the fields If the weight column is a floating point type, all result columns will be doubles. If the weight column is an integral type, all integral input columns will have long results and all floating point input columns will have double results.- Specified by:
wsumByin interfaceTable- Parameters:
weightColumn- the column to use for the weightgroupByColumns- The grouping columnsTable.by(String...)
-
stdBy
-
varBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the variance for the rest of the fields- Specified by:
varByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
lastBy
Description copied from interface:TableGroups the data column according togroupByColumnsand retrieves the last for the rest of the fields- Specified by:
lastByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
firstBy
Description copied from interface:TableGroups the data column according togroupByColumnsand retrieves the first for the rest of the fields- Specified by:
firstByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
minBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the min for the rest of the fields- Specified by:
minByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)
-
maxBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the max for the rest of the fields- Specified by:
maxByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)}
-
medianBy
Description copied from interface:TableGroups the data column according togroupByColumnsand computes the median for the rest of the fields- Specified by:
medianByin interfaceTable- Parameters:
groupByColumns- The grouping columnsTable.by(String...)}
-
countBy
-
ungroup
Description copied from interface:TableUngroups a table by converting arrays into columns.- Specified by:
ungroupin interfaceTable- Parameters:
nullFill- indicates if the ungrouped table should allow disparate sized arrays filling shorter columns with null values. If set to false, then all arrays should be the same length.columnsToUngroup- the columns to ungroup- Returns:
- the ungrouped table
-
byExternal
Description copied from interface:TableCreate aTableMapfrom this table, keyed by the specified columns.The returned TableMap contains each row in this table in exactly one of the tables within the map. If you have exactly one key column the TableMap is keyed by the value in that column. If you have zero key columns, then the TableMap is keyed by
com.fishlib.datastructures.util.SmartKey.EMPTY(and will contain this table as the value). If you have multiple key columns, then the TableMap is keyed by acom.fishlib.datastructures.util.SmartKey. The SmartKey will have one value for each of your column values, in the order specified by keyColumnNames.For example if you have a Table keyed by a String column named USym, and a DBDateTime column named Expiry; a value could be retrieved from the TableMap with
tableMap.get(new SmartKey("SPY";, DBTimeUtils.convertDateTime("2020-06-19T16:15:00 NY"))). For a table with an Integer column named Bucket, you simply use the desired value as intableMap.get(1).- Specified by:
byExternalin interfaceTable- Parameters:
dropKeys- if true, drop key columns in the output TableskeyColumnNames- the name of the key columns to use.- Returns:
- a TableMap keyed by keyColumnNames
-
rollup
public HierarchicalTable rollup(ComboAggregateFactory comboAggregateFactory, boolean includeConstituents, SelectColumn... columns) -
treeTable
Description copied from interface:TableCreate a hierarchical tree table. The structure of the table is encoded by an "id" and a "parent" column. The id column should represent a unique identifier for a given row, and the parent column indicates which row is the parent for a given row. Rows that have a null parent, are shown in the main table. It is possible for rows to be "orphaned", if their parent reference is non-null and does not exist in the table.- Specified by:
treeTablein interfaceTable- Parameters:
idColumn- the name of a column containing a unique identifier for a particular row in the tableparentColumn- the name of a column containing the parent's identifier, null for elements that are part of the root table- Returns:
- a hierarchical table grouped according to the parentColumn
-
sort
-
reverse
-
wouldMatch
Description copied from interface:TableA table operation that applies the supplied predicate to each row in the table and produces columns containing the pass/fail result of the predicate application. This is similar toTable.where(String...)except that instead of selecting only rows that meet the criteria, new columns are added with the result of the comparison.- Specified by:
wouldMatchin interfaceTable- Returns:
- a table with new columns containing the filter result for each row.
-
snapshot
Description copied from interface:TableSnapshot "rightTable", triggered by "this" Table, and return a new Table as a result. "this" Table is the triggering table, i.e. the table whose change events cause a new snapshot to be taken. The result table includes a "snapshot key" which is a subset (possibly all) of this Table's columns. The remaining columns in the result table come from "rightTable", the table being snapshotted.- Specified by:
snapshotin interfaceTable- Parameters:
rightTable- The table to be snapshotteddoInitialSnapshot- Take the first snapshot now (otherwise wait for a change event)stampColumns- The columns forming the "snapshot key", i.e. some subset of this Table's columns to be included in the result at snapshot time. As a special case, an empty stampColumns is taken to mean "include all columns".- Returns:
- The result table
-
snapshotIncremental
public Table snapshotIncremental(Table rightTable, boolean doInitialSnapshot, String... stampColumns) - Specified by:
snapshotIncrementalin interfaceTable
-
snapshotHistory
- Specified by:
snapshotHistoryin interfaceTable
-
isFlat
public boolean isFlat()Description copied from interface:TableReturn true if this table is guaranteed to be flat. The index of a flat table will be from 0...numRows-1. -
flatten
Description copied from interface:TableCreates a version of this table with a flat index (V2 only). -
preemptiveUpdatesTable
- Specified by:
preemptiveUpdatesTablein interfaceTable
-
preemptiveSnapshotTable
- Specified by:
preemptiveSnapshotTablein interfaceTable
-
updateBy
public Table updateBy(@NotNull UpdateByControl control, @NotNull Collection<UpdateByClause> operations, MatchPair... byColumns) Description copied from interface:TableCreate a table with the same
indexas it's parent that will perform the specified set of row based operations to it. As opposed toTable.update(String...)these operations are more restricted but are capable of processing state between rows. This operation will group the table by the specified set of keys if provided before applying the operation. -
silent
Description copied from interface:DynamicTableReturn an identical table that suppresses all downstream notifications
WARNING: Use this feature responsibly. Even though updates are suppressed, that does not imply that the underlying column sources are necessarily static, and so reading data from the table may not be consistent. A safer approach is to use
Table.snapshot(Table, String...)orTable.snapshotIncremental(Table, String...)- Specified by:
silentin interfaceDynamicTable- Returns:
- a new
Tablethat does not propagate updates downstream.
-
addSubscription
public boolean addSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int handleId, BitSet columnsToSubscribe, boolean isViewport) Description copied from interface:SubscribableTableAdd a subscription to this table.- Specified by:
addSubscriptionin interfaceSubscribableTable- Parameters:
client- the client requesting the subscription, used to uniquely identify he handleId and send deltas, snapshots and responseshandleId- the ID of our subscriptioncolumnsToSubscribe- the bitset of columns to subscribe toisViewport- true if the subscription is a viewport, false if it is a full subscription- Returns:
- true if the subscription was added
-
updateSubscription
public boolean updateSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, BitSet newSubscribedColumns) Description copied from interface:SubscribableTableUpdate the subscription's columns.- Specified by:
updateSubscriptionin interfaceSubscribableTable- Parameters:
client- the client requesting the subscription, used to send deltas, snapshots and responsessubscriptionId- the ID of our subscriptionnewSubscribedColumns- the bitset of columns to subscribe to- Returns:
- true if the subscription was found and updated
-
updateViewport
public boolean updateViewport(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, Index newViewPort) Description copied from interface:SubscribableTableUpdate the subscription's viewport (rows).- Specified by:
updateViewportin interfaceSubscribableTable- Parameters:
client- the client requesting the subscription, used to send deltas, snapshots and responsessubscriptionId- the ID of our subscriptionnewViewPort- the index representing which rows to subscribe to (in position space)- Returns:
- true if the subscription was found and updated
-
updateViewportAndColumns
public boolean updateViewportAndColumns(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId, Index newViewPort, BitSet columnsToSubscribe) Description copied from interface:SubscribableTableUpdate the subscription's columns and viewport (rows).- Specified by:
updateViewportAndColumnsin interfaceSubscribableTable- Parameters:
client- the client requesting the subscription, used to send deltas, snapshots and responsessubscriptionId- the ID of our subscriptionnewViewPort- the index representing which rows to subscribe to (in position space)columnsToSubscribe- the bitset of columns to subscribe to- Returns:
- true if the subscription was found and updated
-
removeSubscription
public boolean removeSubscription(io.deephaven.enterprise.comm.api.CommandSender client, int subscriptionId) Description copied from interface:SubscribableTableRemove a subscription.- Specified by:
removeSubscriptionin interfaceSubscribableTable- Parameters:
client- the client requesting the subscription, used to send responsessubscriptionId- the ID of our subscription- Returns:
- true if the subscription was found and updated
-
isSnapshot
public boolean isSnapshot()Description copied from interface:SubscribableTableTrue if this table is a snapshot table (as opposed to a preemptive updates table); used byRemoteQueryProcessorto set the isSnapshot flag onExportedTableCreationMessagemessages, so that a client knows if it has an appropriate type of table for its viewport.- Specified by:
isSnapshotin interfaceSubscribableTable- Returns:
- true if this is a subscription snapshot table.
-
setAttribute
Description copied from interface:TableSet the value of an attribute.- Specified by:
setAttributein interfaceTable- Overrides:
setAttributein classBaseTable- Parameters:
key- the name of the attributeobject- the value
-