Results of 1 - 10 of about 59 for reference (0.002 sec.)
- marimo Notebooks 11788
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...el. This panel lets you quickly navigate your schemas to pull tables and columns into your SQL queries. Data Sources Panel Reference a Local Dataframe Reference a local dataframe in your SQL cell by using the name of the Python variable that holds the dat...e table will be used instead. import polars as pl df = pl.DataFrame({"value": [1, 2, 3]}) SELECT * FROM df WHERE value > 2 Reference the Output of a SQL Cell Defining a non-private (non-underscored) output variable in the SQL cell allows you to reference...the resulting dataframe in other Python and SQL cells. Reference the SQL result in Python Reactive SQL Cells marimo allows you to create reactive SQL cells that automatically update when... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Geometry Data Type 11627
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...hich means that the execution engine will not be able to do any optimizations based on the geometry statistics. Coordinate Reference Systems As far as the execution engine is concerned, geometries are considered to exist in a Cartesian coordinate system....In practice, however, most geospatial data is associated with a specific Coordinate Reference System (CRS) that defines how the coordinates relate to real-world locations on the Earth's surface. A helpful analogy is...equivalent of "time zones", but for geospatial data. Just like how time zones define how local time relates to a standard reference time (e.g., UTC), CRSs define how the coordinates of a geometry relate to a standard reference system (e.g., WGS 84). CRSs... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Geometry Functions 11627
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...of the geometry ST_Intersects_Extent Returns true if the geometries bounding boxes intersect ST_CRS Returns the Coordinate Reference System (CRS) identifier of the geometry ST_SetCRS Sets the Coordinate Reference System (CRS) identifier of the geometry ST...INESTRING(0 0, 10 20)'::GEOMETRY | | Result | true | | Alias | && | ST_CRS function | Description | Returns the Coordinate Reference System (CRS) identifier of the geometry | | Example | ST_CRS('POINT(1 2)'::GEOMETRY('OGC:CRS84')) | | Result | OGC:CRS84 |...ST_SetCRS function | Description | Sets the Coordinate Reference System (CRS) identifier of the geometry | | Example | typeof(ST_SetCRS('POINT(1 2)'::GEOMETRY, 'OGC:CRS84')) | | Result |... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Lance Extension 10373
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...DB's core extensions repository and load it using the following commands: INSTALL AND LOAD lance; Usage Full SQL reference Cloud storage reference Query a Lance Dataset Local file: SELECT * FROM '⟨path/to/dataset.lance⟩' LIMIT 10; S3: SELECT * F...h/to/dataset.lance⟩', 'vec', [0.1, 0.2, 0.3, 0.4]::FLOAT[4], k = 5, prefilter = true ) ORDER BY _distance ASC; See the SQL reference for full parameter documentation . Full-Text Search (FTS) -- Search a text column, returning BM25-like scores in `_score`...e FROM lance_fts( '⟨path/to/dataset.lance⟩', 'text', 'puppy', k = 10, prefilter = true ) ORDER BY _score DESC; See the SQL reference for full parameter documentation . Hybrid Search (Vector + FTS) -- Combine vector and text scores, returning `_hybrid_scor... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
- Vectors 10212
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...db_destroy_data_chunk(&result); } // clean-up duckdb_destroy_result(&res); duckdb_disconnect(&con); duckdb_close(&db); API Reference Overview duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); void duckdb_destroy_vector ( du...kdb_vector dst , duckdb_selection_vector sel , idx_t src_count , idx_t src_offset , idx_t dst_offset ); void duckdb_vector_reference_value ( duckdb_vector vector , duckdb_value value ); void duckdb_vector_reference_vector ( duckdb_vector to_vector , duckd...er of items copied = src_count - src_offset). dst_offset : The offset in the dst vector to start copying to. duckdb_vector_reference_value Copies the value from value to vector . Syntax void duckdb_vector_reference_value ( duckdb_vector vector , duckdb_va... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- S3 and AWS Authentication 9906
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...ow explain which method to use and link to the relevant reference. Choosing an Authentication Method There are two S3 secret providers. Use the config provider when you have static credent...he credential_chain provider when you want DuckDB to fetch credentials automatically through the AWS SDK. Situation Method Reference You have a static access key and secret config provider config provider Credentials come from ~/.aws/credentials or ~/.aws... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- R Client 9278
- Installation To use the DuckDB R client, visit the R installation page . The latest stable version of the DuckDB R client is 2.0.0. Installation duckdb : R Client The DuckDB R client can be installed using the following command: install.pac
...e duckplyr package. It can be installed using install.packages("duckplyr") . For details, see the duckplyr documentation . Reference Manual The reference manual for the DuckDB R client is available at r.duckdb.org . Basic Client Usage The standard DuckDB...LIMIT 1") print(res) # Sepal.Length Sepal.Width Petal.Length Petal.Width Species # 1 5.1 3.5 1.4 0.2 setosa DuckDB keeps a reference to the R data frame after registration. This prevents the data frame from being garbage-collected. The reference is cleare...lopen(/Library/Frameworks/R.framework/Resources/modules//R_X11.so, 0x0006): Library not loaded: /opt/X11/lib/libSM.6.dylib Referenced from: <31EADEB5-0A17-3546-9944-9B3747071FE8> /Library/Frameworks/R.framework/Versions/4.4-arm64/Resources/modules/R_X11.s... - https://man.mtool.work/duckdb/2.0/clients/r.html
- Share a DuckDB Database That Only Stores Views 8797
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...SQL command. This only needs to be run once. Building the Catalog Create a persistent database file and define views that reference the remote data. Use fully qualified locations (remote URLs or absolute paths) so that the views resolve regardless of the...//my-bucket/rail/stations.parquet'); Because the file stores only view definitions, it stays small no matter how large the referenced datasets are. Hosting the Catalog Upload the catalog.duckdb file to any location that DuckDB can read over the network, f...attach the catalog read-only and query the views as if they were local tables. Each query reads the current data from the referenced remote files: ATTACH 'https://example.com/catalog.duckdb' AS catalog (READ_ONLY); SELECT count(*) AS num_stations FROM ca... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- QUALIFY Clause 8491
- The QUALIFY clause is used to filter the results of WINDOW functions . This filtering of results is similar to how a HAVING clause filters the results of aggregate functions applied based on the GROUP BY clause . The QUALIFY clause avoids t
...QUALIFY clause: SELECT schema_name, function_name, -- In this example the function_rank column in the select clause is for reference row_number() OVER (PARTITION BY schema_name ORDER BY function_name) AS function_rank FROM duckdb_functions() QUALIFY row_n...WINDOW clause: SELECT schema_name, function_name, -- In this example the function_rank column in the select clause is for reference row_number() OVER my_window AS function_rank FROM duckdb_functions() WINDOW my_window AS (PARTITION BY schema_name ORDER B... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/qualify.html
- Overview of DuckDB Internals 8330
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...s as specified. ParsedExpression The ParsedExpression represents an expression within a SQL statement. This can be e.g., a reference to a column, an addition operator or a constant value. The type of the ParsedExpression indicates what it represents, e.g....xpressions are resolved in the Binder, not in the Parser. TableRef The TableRef represents any table source. This can be a reference to a base table, but it can also be a join, a table-producing function or a subquery. QueryNode The QueryNode represents e...lumn binding resolver converts logical BoundColumnRefExpression nodes that refer to a column of a specific table into BoundReferenceExpression nodes that refer to a specific index into the DataChunks that are passed around in the execution engine. Physica... - https://man.mtool.work/duckdb/2.0/internals/overview.html
DuckDB 2.0 Documentation / man.mtool.work