vastdb.table

VAST Database table.

class vastdb.table.ITable

Bases: ABC

Interface for VAST Table operations.

abstract property arrow_schema: pyarrow.Schema

Table arrow schema.

abstract delete(rows: pyarrow.RecordBatch | pyarrow.Table) → None

Delete rows from table.

abstract import_files(files_to_import: Iterable[str], config: ImportConfig | None = None) → None

Import files into table.

abstract import_partitioned_files(files_and_partitions: dict[str, pyarrow.RecordBatch], config: ImportConfig | None = None) → None

Import partitioned files.

abstract imports_table() → ITable | None

Get imports table.

abstract insert(rows: pyarrow.RecordBatch | pyarrow.Table) → pyarrow.ChunkedArray

Insert rows into table.

abstract property name: str

Table name.

abstract property path: str

Return table’s path.

abstract projection(name: str) → Projection

Get a specific semi-sorted projection of this table.

abstract projections(projection_name: str = '') → Iterable[Projection]

List semi-sorted projections.

abstract property ref: TableRef

Return Table Ref.

abstract reload_schema() → None

Reload Arrow Schema.

abstract reload_sorted_columns() → None

Reload Sorted Columns.

abstract reload_stats() → None

Reload Table Stats.

abstract select(columns: list[str] | None = None, predicate: ibis.expr.types.BooleanColumn | ibis.common.deferred.Deferred = None, config: QueryConfig | None = None, *, internal_row_id: bool = False, limit_rows: int | None = None) → pyarrow.RecordBatchReader

Execute a query.

abstract sorted_columns() → list[str]

Return sorted columns’ names.

abstract sorting_done() → bool

Check if sorting is done.

abstract sorting_score() → int

Get sorting score.

abstract update(rows: pyarrow.RecordBatch | pyarrow.Table, columns: list[str] | None = None) → None

Update rows in table.

class vastdb.table.Projection(name: str, table_metadata: TableMetadata, stats: TableStats, handle: int, tx: Transaction)

Bases: object

VAST semi-sorted projection.

columns() → pyarrow.Schema

Return this projections’ columns as an Arrow schema.

drop() → None

Drop this projection.

handle: int

name: str

rename(new_name: str) → None

Rename this projection.

stats: TableStats

table_metadata: TableMetadata

tx: Transaction

class vastdb.table.Table(metadata: TableMetadata, handle: int, tx: Transaction)

Bases: TableInTransaction

Vast Interactive Table.

add_column(new_column: pyarrow.Schema) → None

Add a new column.

add_sorting_key(sorting_key: list[int]) → None

Add a sorting key to a table that doesn’t have any.

columns() → pyarrow.Schema

Return columns’ metadata.

create_imports_table(fail_if_exists=True) → ITable

Create imports table.

create_projection(projection_name: str, sorted_columns: list[str], unsorted_columns: list[str]) → Projection

Create a new semi-sorted projection.

drop() → None

Drop this table.

drop_column(column_to_drop: pyarrow.Schema) → None

Drop an existing column.

get_stats() → TableStats

Get the statistics of this table.

property handle: int

Table Handle.

imports_table() → Table | None

Get the imports table of this table.

rename(new_name: str) → None

Rename this table.

rename_column(current_column_name: str, new_column_name: str) → None

Rename an existing column.

sorted_columns() → list

Return sorted columns’ metadata.

property sorted_table: bool

Is table a sorted table.

property stats: TableStats

Fetch table’s statistics from server.

property tx

Return transaction.

class vastdb.table.TableInTransaction(metadata: TableMetadata, tx: Transaction)

Bases: ITable

VAST Table.

property arrow_schema: pyarrow.Schema

Table arrow schema.

delete(rows: pyarrow.RecordBatch | pyarrow.Table) → None

Delete a subset of rows in this table.

Row IDs are specified using a special field (named “$row_id” of uint64 type).

import_files(files_to_import: Iterable[str], config: ImportConfig | None = None) → None

Import a list of Parquet files into this table.

The files must be on VAST S3 server and be accessible using current credentials.

import_partitioned_files(files_and_partitions: dict[str, pyarrow.RecordBatch], config: ImportConfig | None = None) → None

Import a list of Parquet files into this table.

The files must be on VAST S3 server and be accessible using current credentials. Each file must have its own partition values defined as an Arrow RecordBatch.

imports_table() → ITable | None

Get the imports table of this table.

imports_table_metadata() → TableMetadata

Get TableMetadata for import table.

insert(rows: pyarrow.RecordBatch | pyarrow.Table, by_columns: bool = False) → pyarrow.ChunkedArray

Insert a RecordBatch into this table.

insert_in_column_batches(rows: pyarrow.RecordBatch) → pyarrow.ChunkedArray

Split the RecordBatch into max_columns that can be inserted in single RPC.

Insert first MAX_COLUMN_IN_BATCH columns and get the row_ids. Then loop on the rest of the columns and update in groups of MAX_COLUMN_IN_BATCH.

property name: str

Table name.

property path: str

Return table’s path.

projection(name: str, include_stats: bool = True) → Projection

Get a specific semi-sorted projection of this table.

projections(projection_name: str = '', include_stats: bool = True) → Iterable[Projection]

List all semi-sorted projections of this table if projection_name is empty.

Otherwise, list only the specific projection (if exists).

property ref: TableRef

Table Reference.

reload_schema() → None

Reload Arrow Schema.

reload_sorted_columns() → None

Reload Sorted Columns.

reload_stats() → None

Reload Table Stats.

select(columns: list[str] | None = None, predicate: ibis.expr.types.BooleanColumn | ibis.common.deferred.Deferred = None, config: QueryConfig | None = None, *, internal_row_id: bool = False, limit_rows: int | None = None) → pyarrow.RecordBatchReader

Execute a query over this table.

To read a subset of the columns, specify their names via columns argument. Otherwise, all columns will be read.

In order to apply a filter, a predicate can be specified. See https://github.com/vast-data/vastdb_sdk/blob/main/README.md#filters-and-projections for more details.

Query-execution configuration options can be specified via the optional config argument.

select_splits(columns: list[str] | None = None, predicate: ibis.expr.types.BooleanColumn | ibis.common.deferred.Deferred = None, config: QueryConfig | None = None, *, internal_row_id: bool = False, limit_rows: int | None = None) → list[pyarrow.RecordBatchReader]

Return pa.RecordBatchReader for each split.

sorted_columns() → list[str]

Return sorted columns’ metadata.

sorting_done() → bool

Sorting done indicator for the table. Always False for unsorted tables.

sorting_score() → int

Sorting score for the table. Always 0 for unsorted tables.

property stats: TableStats | None

Table’s statistics.

update(rows: pyarrow.RecordBatch | pyarrow.Table, columns: list[str] | None = None) → None

Update a subset of cells in this table.

Row IDs are specified using a special field (named “$row_id” of uint64 type) - this function assume that this special field is part of arguments.

A subset of columns to be updated can be specified via the columns argument.