Interface IQueryTable
Assembly: DeephavenOpenAPI.dll
Syntax
public interface IQueryTable : IDisposable
Properties
Scope
Declaration
IQueryScope Scope { get; }
Property Value
TableState
Declaration
TableState TableState { get; }
Property Value
Type |
Description |
Deephaven.OpenAPI.Client.Internal.TableState |
|
UniqueId
Declaration
Property Value
Type |
Description |
System.Int32 |
|
Methods
AbsSumBy(String[])
Declaration
IQueryTable AbsSumBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
AsOfJoin(IQueryTable, String)
Declaration
IQueryTable AsOfJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
AsOfJoin(IQueryTable, String, String)
Declaration
IQueryTable AsOfJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
AsOfJoin(IQueryTable, String[], String[])
Declaration
IQueryTable AsOfJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
AvgBy(String[])
Declaration
IQueryTable AvgBy(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
By(AggregateCombo, String[])
Declaration
IQueryTable By(AggregateCombo comboAggregate, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
AggregateCombo |
comboAggregate |
|
System.String[] |
groupByColumns |
|
Returns
By(String[])
Declaration
IQueryTable By(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
CountBy(String, String[])
Declaration
IQueryTable CountBy(string countByColumn, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String |
countByColumn |
|
System.String[] |
groupByColumns |
|
Returns
DropColumns(String[])
Declaration
IQueryTable DropColumns(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
ExactJoin(IQueryTable, String)
Declaration
IQueryTable ExactJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
ExactJoin(IQueryTable, String, String)
Declaration
IQueryTable ExactJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
ExactJoin(IQueryTable, String[], String[])
Declaration
IQueryTable ExactJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
FirstBy(String[])
Declaration
IQueryTable FirstBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
Flatten()
Declaration
Returns
Freeze()
Declaration
Returns
GetColumnsTask()
Declaration
Task<IColumn[]> GetColumnsTask()
Returns
GetColumnsTask(String[], Type[])
Declaration
Task<IColumn[]> GetColumnsTask(string[] names, Type[] types)
Parameters
Type |
Name |
Description |
System.String[] |
names |
|
Type[] |
types |
|
Returns
GetTableDataTask()
Declaration
Task<ITableData> GetTableDataTask()
Returns
GetTableDataTask(RowRangeSet, String[])
Declaration
Task<ITableData> GetTableDataTask(RowRangeSet rowRangeSet, params string[] columns)
Parameters
Type |
Name |
Description |
RowRangeSet |
rowRangeSet |
|
System.String[] |
columns |
|
Returns
GetTableDataTask(Int64, Int64)
Declaration
Task<ITableData> GetTableDataTask(long first, long last)
Parameters
Type |
Name |
Description |
System.Int64 |
first |
|
System.Int64 |
last |
|
Returns
GetTableDataTask(Int64, Int64, String[])
Declaration
Task<ITableData> GetTableDataTask(long first, long last, params string[] columns)
Parameters
Type |
Name |
Description |
System.Int64 |
first |
|
System.Int64 |
last |
|
System.String[] |
columns |
|
Returns
GetTableDataTask(String[])
Declaration
Task<ITableData> GetTableDataTask(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
Head(Int32)
Declaration
Parameters
Type |
Name |
Description |
System.Int32 |
n |
|
Returns
HeadBy(Int32, String[])
Declaration
IQueryTable HeadBy(int n, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.Int32 |
n |
|
System.String[] |
groupByColumns |
|
Returns
InnerJoin(IQueryTable, String)
Declaration
IQueryTable InnerJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
InnerJoin(IQueryTable, String, String)
Declaration
IQueryTable InnerJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
InnerJoin(IQueryTable, String[], String[])
Declaration
IQueryTable InnerJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
LastBy(String[])
Declaration
IQueryTable LastBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
LazyUpdate(String[])
Declaration
IQueryTable LazyUpdate(params string[] customColumns)
Parameters
Type |
Name |
Description |
System.String[] |
customColumns |
|
Returns
LeftJoin(IQueryTable, String)
Declaration
IQueryTable LeftJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
LeftJoin(IQueryTable, String, String)
Declaration
IQueryTable LeftJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
LeftJoin(IQueryTable, String[], String[])
Declaration
IQueryTable LeftJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
MaxBy(String[])
Declaration
IQueryTable MaxBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
Declaration
IQueryTable MedianBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
Merge(IQueryTable[])
Declaration
IQueryTable Merge(params IQueryTable[] sources)
Parameters
Returns
Merge(String, IQueryTable[])
Declaration
IQueryTable Merge(string keyColumn, params IQueryTable[] sources)
Parameters
Type |
Name |
Description |
System.String |
keyColumn |
|
IQueryTable[] |
sources |
|
Returns
MinBy(String[])
Declaration
IQueryTable MinBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
NaturalJoin(IQueryTable, String)
Declaration
IQueryTable NaturalJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
NaturalJoin(IQueryTable, String, String)
Declaration
IQueryTable NaturalJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
NaturalJoin(IQueryTable, String[], String[])
Declaration
IQueryTable NaturalJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
NewScope(out IQueryTable)
Declaration
IQueryScope NewScope(out IQueryTable selfInNewScope)
Parameters
Returns
PercentileBy(Double, Boolean, String[])
Declaration
IQueryTable PercentileBy(double percentile, bool avgMedian, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.Double |
percentile |
|
System.Boolean |
avgMedian |
|
System.String[] |
groupByColumns |
|
Returns
PercentileBy(Double, String[])
Declaration
IQueryTable PercentileBy(double percentile, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.Double |
percentile |
|
System.String[] |
groupByColumns |
|
Returns
Preemptive(Int32)
Declaration
IQueryTable Preemptive(int sampleIntervalMs)
Parameters
Type |
Name |
Description |
System.Int32 |
sampleIntervalMs |
|
Returns
ReverseAsOfJoin(IQueryTable, String)
Declaration
IQueryTable ReverseAsOfJoin(IQueryTable rhs, string columnsToMatch)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
Returns
ReverseAsOfJoin(IQueryTable, String, String)
Declaration
IQueryTable ReverseAsOfJoin(IQueryTable rhs, string columnsToMatch, string columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String |
columnsToMatch |
|
System.String |
columnsToAdd |
|
Returns
ReverseAsOfJoin(IQueryTable, String[], String[])
Declaration
IQueryTable ReverseAsOfJoin(IQueryTable rhs, string[] columnsToMatch, string[] columnsToAdd)
Parameters
Type |
Name |
Description |
IQueryTable |
rhs |
|
System.String[] |
columnsToMatch |
|
System.String[] |
columnsToAdd |
|
Returns
Select(String[])
Declaration
IQueryTable Select(params string[] customColumns)
Parameters
Type |
Name |
Description |
System.String[] |
customColumns |
|
Returns
Snapshot(IQueryTable, Boolean, String[])
Declaration
IQueryTable Snapshot(IQueryTable targetTable, bool doInitialSnapshot = true, string[] stampColumns = null)
Parameters
Type |
Name |
Description |
IQueryTable |
targetTable |
|
System.Boolean |
doInitialSnapshot |
|
System.String[] |
stampColumns |
|
Returns
Sort(SortDirection, Boolean, String[])
Declaration
IQueryTable Sort(SortDirection direction, bool abs, params string[] columns)
Parameters
Type |
Name |
Description |
SortDirection |
direction |
|
System.Boolean |
abs |
|
System.String[] |
columns |
|
Returns
Sort(SortPair[])
Declaration
IQueryTable Sort(params SortPair[] sorts)
Parameters
Returns
Sort(String[])
Declaration
IQueryTable Sort(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
SortAbs(String[])
Declaration
IQueryTable SortAbs(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
SortDescending(String[])
Declaration
IQueryTable SortDescending(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
SortDescendingAbs(String[])
Declaration
IQueryTable SortDescendingAbs(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
StdBy(String[])
Declaration
IQueryTable StdBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
SubscribeAllTask()
Declaration
Returns
SubscribeAllTask(String[])
Declaration
Task SubscribeAllTask(params string[] columns)
Parameters
Type |
Name |
Description |
System.String[] |
columns |
|
Returns
SubscribeTask(RowRangeSet, String[])
Declaration
Task SubscribeTask(RowRangeSet rows, params string[] columns)
Parameters
Type |
Name |
Description |
RowRangeSet |
rows |
|
System.String[] |
columns |
|
Returns
SumBy(String[])
Declaration
IQueryTable SumBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
Tail(Int32)
Declaration
Parameters
Type |
Name |
Description |
System.Int32 |
n |
|
Returns
TailBy(Int32, String[])
Declaration
IQueryTable TailBy(int n, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.Int32 |
n |
|
System.String[] |
groupByColumns |
|
Returns
Ungroup()
Declaration
Returns
Ungroup(Boolean)
Declaration
IQueryTable Ungroup(bool nullFill)
Parameters
Type |
Name |
Description |
System.Boolean |
nullFill |
|
Returns
Ungroup(Boolean, String[])
Declaration
IQueryTable Ungroup(bool nullFill, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.Boolean |
nullFill |
|
System.String[] |
groupByColumns |
|
Returns
Ungroup(String[])
Declaration
IQueryTable Ungroup(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
UnsubscribeTask()
Declaration
Returns
Update(String[])
Declaration
IQueryTable Update(params string[] customColumns)
Parameters
Type |
Name |
Description |
System.String[] |
customColumns |
|
Returns
UpdateSubscriptionTask(RowRangeSet, String[])
Declaration
Task UpdateSubscriptionTask(RowRangeSet rows, params string[] columns)
Parameters
Type |
Name |
Description |
RowRangeSet |
rows |
|
System.String[] |
columns |
|
Returns
UpdateView(String[])
Declaration
IQueryTable UpdateView(params string[] customColumns)
Parameters
Type |
Name |
Description |
System.String[] |
customColumns |
|
Returns
VarBy(String[])
Declaration
IQueryTable VarBy(params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String[] |
groupByColumns |
|
Returns
View(String[])
Declaration
IQueryTable View(params string[] customColumns)
Parameters
Type |
Name |
Description |
System.String[] |
customColumns |
|
Returns
WAvgBy(String, String[])
Declaration
IQueryTable WAvgBy(string weightColumn, params string[] groupByColumns)
Parameters
Type |
Name |
Description |
System.String |
weightColumn |
|
System.String[] |
groupByColumns |
|
Returns
Where(String)
Declaration
IQueryTable Where(string literalCondition)
Parameters
Type |
Name |
Description |
System.String |
literalCondition |
|
Returns
Events
OnTableSnapshot
Declaration
event QueryTableSnapshotHandler OnTableSnapshot
Event Type
OnTableUpdate
Declaration
event QueryTableUpdateHandler OnTableUpdate
Event Type
Extension Methods
IQueryTable_GetColumnExtensions.GetColumnsTask<TC1, TC2, TC3, TC4, TC5, TC6>(IQueryTable, String, String, String, String, String, String)
IQueryTable_GetColumnExtensions.GetColumns<TC1, TC2, TC3, TC4, TC5, TC6>(IQueryTable, String, String, String, String, String, String)
IQueryTable_GetColumnExtensions.GetColumnsTask<TC1, TC2, TC3, TC4, TC5, TC6, TC7>(IQueryTable, String, String, String, String, String, String, String)
IQueryTable_GetColumnExtensions.GetColumns<TC1, TC2, TC3, TC4, TC5, TC6, TC7>(IQueryTable, String, String, String, String, String, String, String)