Results of 1 - 10 of about 16 for scanning (0.002 sec.)
- Troubleshoot 14209
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
.... When a time.Time is passed to the client, it is converted to that instant with UnixMicro() , even for TIMESTAMP_TZ , and scanning either type back returns an instant, because SQL types do not model a per-value time zone. A bare time.Time binds as TIMES...ped(start, duckdb.TYPE_TIMESTAMP_NS), duckdb.Typed(end, duckdb.TYPE_TIMESTAMP_NS), ) See Run Queries for the full example. Scanning JSON Values Starting with v2, scanning a JSON value directly into a string or []byte is no longer supported. Scan into any...plain string or byte result is needed and the JSON structure is not, cast the column to ::VARCHAR or ::BLOB in SQL before scanning. Further Reading Go Client — installation, build tags, and the bundled extensions. Connect — opening databases and the con... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Run Queries 10518
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...elled or time out. The sections below cover sending statements, binding parameters, prepared statements, transactions, and scanning results. For opening the database these run on, see Connect . Sending Statements Use Exec (or ExecContext ) for a statemen...ers VALUES ('gru', 25)`); err != nil { tx.Rollback() log.Fatal(err) } if err := tx.Commit(); err != nil { log.Fatal(err) } Scanning Results QueryContext returns a *sql.Rows cursor. Advance it with Next() , read the current row's columns into pointers wit...err != nil { log.Fatal(err) } When the column set is not known ahead of time, rows.Columns() returns the column names, and scanning into a slice of any reads each column into a driver.Value . Remember that a scanned value can be nil for a SQL NULL . Read... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- HTTP(S) Support 10085
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...column_a FROM db.tbl; As with Parquet, queries that only need the metadata, such as count(*) , do not read any table data. Scanning Multiple Files Scanning multiple files over HTTP(S) is also supported: SELECT * FROM read_parquet([ 'https://domain.tld/fi... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- MySQL Import 9218
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...list of supported operations, see the MySQL extension documentation . To run entire queries on the MySQL server instead of scanning its tables from DuckDB, see the CONNECT statement .... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- Go Client 8993
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...lean up. go mod tidy Moving to v2 also introduced a few breaking changes, including opt-in Arrow support and stricter JSON scanning. See Troubleshoot and the README for the complete list. Further Reading Connect — opening in-memory and file-backed databa...ctors, and the connection lifetime. Run Queries — Exec , Query , prepared statements, parameter binding, transactions, and scanning results into Go values. Import Data — bulk loading with the Appender and reading directly from Parquet, CSV, and JSON file... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- PostgreSQL Import 8993
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...or more information see the PostgreSQL extension documentation . To run entire queries on the PostgreSQL server instead of scanning its tables from DuckDB, see the CONNECT statement .... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- Hugging Face Support 8127
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...This is a special branch where Hugging Face automatically generates the Parquet files of every dataset to enable efficient scanning. Authentication Configure your Hugging Face Token in the DuckDB Secrets Manager to access private or gated datasets. First... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- Julia Client 7901
- The DuckDB Julia package provides a high-performance front-end for DuckDB. Much like SQLite, DuckDB runs in-process within the Julia client, and provides a DBInterface front-end. The package also supports multi-threaded execution. It uses J
...() . Instead they can be run with DuckDB.query() instead of DuckDB.execute() and will always return a materialized result. Scanning DataFrames The DuckDB Julia package also provides support for querying Julia DataFrames. Note that the DataFrames are dire... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/julia.html
- Iceberg Extension 7901
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...aths = true); count_star() 51793 The allow_moved_paths option ensures that some path resolution is performed, which allows scanning Iceberg tables that are moved. You can also directly specify the current manifest in the query, this may be resolved from... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Indexing 7901
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...on, and sorting queries. ART Index Scans ART index scans probe a single-column ART index for the requested data instead of scanning a table sequentially. Probing can improve the performance of some queries. DuckDB will try to use an index scan for equali... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
DuckDB 2.0 Documentation / man.mtool.work