@deephaven/jsapi-types
    Preparing search index...

    Interface JoinableTable

    Represents a table that can be joined to another table. Current implementations are Table and TotalsTable.

    interface JoinableTable {
        asOfJoin(
            rightTable: TableReference,
            columnsToMatch: readonly (string | Column)[],
            columnsToAdd?: readonly (string | Column)[],
            asOfMatchRule?: string,
        ): Promise<Table>;
        crossJoin(
            rightTable: TableReference,
            columnsToMatch: readonly (string | Column)[],
            columnsToAdd?: readonly (string | Column)[],
            reserveBits?: number,
        ): Promise<Table>;
        exactJoin(
            rightTable: TableReference,
            columnsToMatch: readonly (string | Column)[],
            columnsToAdd?: readonly (string | Column)[],
        ): Promise<Table>;
        freeze(): Promise<Table>;
        join(
            joinType: string,
            rightTable: TableReference,
            columnsToMatch: readonly (string | Column)[],
            columnsToAdd?: readonly (string | Column)[],
            asOfMatchRule?: string,
        ): Promise<Table>;
        naturalJoin(
            rightTable: TableReference,
            columnsToMatch: readonly (string | Column)[],
            columnsToAdd?: readonly (string | Column)[],
        ): Promise<Table>;
        snapshot(
            baseTable: TableReference,
            doInitialSnapshot?: boolean,
            stampColumns?: readonly (string | Column)[],
        ): Promise<Table>;
    }

    Hierarchy (View Summary)

    Implemented by

    Index
    • Performs an inexact timeseries join, where rows in this table will have columns added from the closest matching row from the right table.

      The asOfMatchRule value can be one of:

      • LESS_THAN_EQUAL
      • LESS_THAN
      • GREATER_THAN_EQUAL
      • GREATER_THAN

      Parameters

      • rightTable: TableReference

        The table to match to values in this table.

      • columnsToMatch: readonly (string | Column)[]

        The columns that should match, according to the asOfMatchRole.

      • OptionalcolumnsToAdd: readonly (string | Column)[]

        Columns from the right table to add to the resulting table, empty/null/absent to add all columns.

      • OptionalasOfMatchRule: string

        The match rule to use, see above.

      Returns Promise<Table>

      A promise that will resolve to the joined table.

    • A promise that will be resolved with the newly created table holding the results of the specified cross join operation. The columnsToAdd parameter is optional, not specifying it will result in all columns from the right table being added to the output. The reserveBits optional parameter lets the client control how the key space is distributed between the rows in the two tables, see the Java Table class for details.

      Parameters

      • rightTable: TableReference

        The table to match to values in this table.

      • columnsToMatch: readonly (string | Column)[]

        The columns that should match exactly.

      • OptionalcolumnsToAdd: readonly (string | Column)[]

        Columns from the right table to add to the resulting table, empty/null/absent to add all columns.

      • OptionalreserveBits: number

        The number of bits of key-space to initially reserve per group, null/absent will let the server select a value.

      Returns Promise<Table>

      A promise that will resolve to the joined table.

    • A promise that will be resolved with the newly created table holding the results of the specified exact join operation. The columnsToAdd parameter is optional, not specifying it will result in all columns from the right table being added to the output.

      Parameters

      • rightTable: TableReference

        The table to match to values in this table.

      • columnsToMatch: readonly (string | Column)[]

        The columns that should match exactly.

      • OptionalcolumnsToAdd: readonly (string | Column)[]

        Columns from the right table to add to the resulting table, empty/null/absent to add all columns.

      Returns Promise<Table>

      A promise that will resolve to the joined table.

    • Joins this table to the provided table, using one of the specified join types:

      • AJ, ReverseAJ (or RAJ) - Inexact timeseries joins, based on the provided matching rule.
      • CROSS_JOIN (or Join) - Cross join of all rows that have matching values in both tables.
      • EXACT_JOIN (or ExactJoin) - Matches values in exactly one row in the right table, with errors if there is not exactly one.
      • NATURAL_JOIN (or Natural) - Matches values in at most one row in the right table, with nulls if there is no match or errors if there are multiple matches.

      Note that Left join is not supported here, unlike DHE.

      See the Choose a join method document for more guidance on picking a join operation.

      Parameters

      • joinType: string

        The type of join to perform, see the list above.

      • rightTable: TableReference

        The table to match to values in this table.

      • columnsToMatch: readonly (string | Column)[]

        Columns that should match.

      • OptionalcolumnsToAdd: readonly (string | Column)[]

        Columns from the right table to add to the result - empty/null/absent to add all columns.

      • OptionalasOfMatchRule: string

        If joinType is AJ/RAJ/ReverseAJ, the match rule to use.

      Returns Promise<Table>

      A promise that will resolve to the joined table.

      Instead, call the specific method for the join type.

    • A promise that will be resolved with the newly created table holding the results of the specified natural join operation. The columnsToAdd parameter is optional, not specifying it will result in all columns from the right table being added to the output.

      Parameters

      • rightTable: TableReference

        The table to match to values in this table.

      • columnsToMatch: readonly (string | Column)[]

        The columns that should match exactly.

      • OptionalcolumnsToAdd: readonly (string | Column)[]

        Columns from the right table to add to the resulting table. Empty/null/absent to add all columns.

      Returns Promise<Table>

      A promise that will resolve to the joined table.

    • Creates a server-side snapshot of baseTable when this table updates.

      Parameters

      • baseTable: TableReference

        The table to snapshot.

      • OptionaldoInitialSnapshot: boolean

        Whether to create an initial snapshot immediately.

      • OptionalstampColumns: readonly (string | Column)[]

        Optional list of stamp column match pairs to include in the result.

      Returns Promise<Table>

      A promise that resolves to the snapshot table.