Results of 1 - 10 of about 14 for lazy (0.004 sec.)
- Integration with Polars 12446
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...ork. Installation pip install -U duckdb 'polars[pyarrow]' Polars to DuckDB DuckDB can natively query Polars DataFrames and LazyFrames by referring to their names as they exist in the current scope. DuckDB pushes the column selections of a query, and...the filters it can translate, into a LazyFrame, so Polars collects only the rows and columns the query needs. A DataFrame is converted in full and filtered afterwar...it │ │ --- ┆ --- │ │ i32 ┆ str │ ╞═════╪════════╡ │ 1 ┆ banana │ │ 2 ┆ apple │ │ 3 ┆ mango │ └─────┴────────┘ The optional lazy parameter allows returning Polars LazyFrames. df = duckdb.sql(""" SELECT 1 AS id, 'banana' AS fruit UNION ALL SELECT 2, 'a... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- Troubleshooting Quack 12148
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...skip the problematic table. A common cause is an Iceberg catalog attached on the server with the default TABLE_RESOLUTION 'lazy' . Lazily resolved tables are listed with a placeholder column of type UNKNOWN , which the client receives through duckdb_...the problem back, so eager server-side resolution is the more reliable fix. Querying Without Attaching If you want to keep lazy resolution, use quack_query() , which runs SQL directly on the server without importing its catalog: {:.codebox-client} FR... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- Iceberg Options 10625
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...that do not assign a table location server-side. Note: this feature was introduced in DuckDB 2.0. TABLE_RESOLUTION VARCHAR lazy Controls when table schemas are resolved. Accepted values: lazy , eager . With lazy (the default), a table's schema is res... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Relational API on Pandas 9715
- DuckDB offers a relational API that can be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can poin
...) # create a DuckDB relation from a dataframe rel = con.from_df(input_df) # chain together relational operators (this is a lazy operation, so the operations are not yet executed) # equivalent to: SELECT i, j, i*2 AS two_i FROM input_df WHERE i >= 2 O... - https://man.mtool.work/duckdb/2.0/guides/python/relational_api_pandas.html
- marimo Notebooks 8805
- 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
...hen their dependencies change. Working with expensive queries or large datasets? You can configure marimo's runtime to be “lazy”. By doing so, dependent cells are only marked as stale, letting the user choose when they should be re-run. digits = mo.u... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- What's New in the Docs for 2.0 8507
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...sed for row-group pruning Storage Format v2.0 New database files use the v2.0.0 storage format by default. The format adds lazy metadata loading, better compression and corruption validation. DuckDB versions before 2.0 cannot read files in the new fo... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Python API 7894
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...s result. Reading it again runs the query again. Use duckdb.execute() for statements such as CREATE TABLE and INSERT . See Lazy Evaluation for details. Relations can be referenced in subsequent queries by storing them inside variables, and using them... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
- Quack Remote Protocol 7894
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...le definition that cannot be bound fails the whole attachment. If this happens (for example, with an Iceberg catalog using lazy table resolution), see ATTACH Fails to Bind a Remote Table Definition . Routing a Session with CONNECT Once a remote is at... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Conversion between DuckDB and Python 7597
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...nit of the original Arrow type are not preserved. Polars pl() fetches the data of a relation as a Polars DataFrame, and pl(lazy=True) returns a Polars LazyFrame Object Conversion: Python Object to DuckDB Python objects are converted when they are pas... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Relational API 7597
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...alled on. Lazy Evaluation Building a relation runs nothing: DuckDB binds the text once to learn the columns and their types, and holds no...─────┼────────┤ │ 3 │ 3 │ │ 10 │ 3 │ │ 17 │ 3 │ └───────┴────────┘ Only a statement that reads, such as a SELECT , gives a lazy relation. Any other statement passed to sql() , such as CREATE TABLE or INSERT , runs at the call, and the relation holds...)] Relation Creation This section contains the details on how a relation is created. A relation over a query that reads is lazy evaluated . Name Description from_arrow Create a relation object from an Arrow object. from_csv_auto Alias of read_csv() .... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
DuckDB 2.0 Documentation / man.mtool.work