Columnar Query Engine for Larger-than-RAM Data

---

Documentation for package ‘vectra’ version 0.5.1

• DESCRIPTION file
• User guides, package vignettes and other documentation
• Package NEWS
• Package README

Help Pages

across	Apply a function across multiple columns
anti_join	Join two vectra tables
append_vtr	Append rows to an existing .vtr file
arrange	Sort rows by column values
bind_cols	Bind rows or columns from multiple vectra tables
bind_rows	Bind rows or columns from multiple vectra tables
block_fuzzy_lookup	Fuzzy-match query keys against a materialized block
block_lookup	Probe a materialized block by column value
collect	Execute a lazy query and return a data.frame
count	Count observations by group
create_index	Create a hash index on a .vtr file column
cross_join	Cross join two vectra tables
delete_vtr	Logically delete rows from a .vtr file
desc	Mark a column for descending sort order
diff_vtr	Compute the logical diff between two .vtr files
distinct	Keep distinct/unique rows
explain	Print the execution plan for a vectra query
filter	Filter rows of a vectra query
full_join	Join two vectra tables
fuzzy_join	Fuzzy join two vectra tables by string distance
glimpse	Get a glimpse of a vectra table
group_by	Group a vectra query by columns
has_index	Check if a hash index exists for a .vtr column
head.vectra_node	Limit results to first n rows
inner_join	Join two vectra tables
left_join	Join two vectra tables
link	Define a link between a fact table and a dimension table
lookup	Look up columns from linked dimension tables
materialize	Materialize a vectra node into a reusable in-memory block
mutate	Add or transform columns
print.vectra_node	Print a vectra query node
pull	Extract a single column as a vector
reframe	Summarise with variable-length output per group
relocate	Relocate columns
rename	Rename columns
right_join	Join two vectra tables
select	Select columns from a vectra query
semi_join	Join two vectra tables
slice	Select rows by position
slice_head	Select first or last rows
slice_max	Select first or last rows
slice_min	Select first or last rows
slice_tail	Select first or last rows
summarise	Summarise grouped data
summarize	Summarise grouped data
tally	Count observations by group
tbl	Create a lazy table reference from a .vtr file
tbl_csv	Create a lazy table reference from a CSV file
tbl_sqlite	Create a lazy table reference from a SQLite database
tbl_tiff	Create a lazy table reference from a GeoTIFF raster
tbl_xlsx	Create a lazy table reference from an Excel (.xlsx) file
tiff_extract_points	Extract raster values at point coordinates
tiff_metadata	Read GDAL_METADATA from a GeoTIFF
transmute	Keep only columns from mutate expressions
ungroup	Remove grouping from a vectra query
vtr_schema	Create a star schema over linked vectra tables
write_csv	Write query results or a data.frame to a CSV file
write_sqlite	Write query results or a data.frame to a SQLite table
write_tiff	Write query results to a GeoTIFF file
write_vtr	Write data to a .vtr file