Results of 1 - 10 of about 21 for tags (0.002 sec.)
- Go Client 12380
- 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
...The README has the full mapping table for earlier releases. The DuckDB 1.4 Andium LTS release line is published as its own tags, which still follow the client's older versioning scheme. Select one in go.mod the same way as any other version; see the...releases page for the available tags. This project moved from github.com/marcboeker/go-duckdb to github.com/duckdb/duckdb-go starting with v2.5.0. All versions...database with sql.OpenDB() and a Connector . See Connect for connectors, configuration, and the connection lifetime. Build Tags Some client features are gated behind Go build tags , passed to go build with the -tags flag, for example go build -tags=d... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- GROUP BY Clause 10740
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...group by the elements of a list. This is useful for aggregating over the individual values of a list column: SELECT unnest(tags) AS tag, count(*) AS n FROM (VALUES (['a', 'b']), (['b', 'c']), (['b'])) t(tags) GROUP BY unnest(tags) ORDER BY tag; tag n... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- Conversion between DuckDB and Python 10587
- 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
...} │ └─────────────────────────┘ A dict with string keys becomes a STRUCT : my_struct_dict = { "name": "duck", "count": 2, "tags": [1, 2, 3], "active": True } duckdb.values(my_struct_dict).show() ┌──────────────────────────────────────────────────────...─────────────────┐ │ col0 │ │ struct("name" varchar, count integer, tags integer[], active boolean) │ ├───────────────────────────────────────────────────────────────────────┤ │ {'name': duck, 'c...ount': 2, 'tags': [1, 2, 3], 'active': true} │ └───────────────────────────────────────────────────────────────────────┘ As a query parame... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- DuckDB_% Metadata Functions 10452
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...R path The file path associated with the database. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) internal true indicates a system or built-in database. false indica...n of this function, or NULL if none is registered. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) return_type The logical data type name of the returned value. Appli...oid Internal identifier (name) of the table object. BIGINT comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) is_unique true if the index was created with the UNIQUE modifier, f... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Handle Results 10300
- Overview DuckDB is columnar, and beyond reading a result set row by row through database/sql , the Go client can exchange whole results with Apache Arrow as a stream of record batches, and register an Arrow stream as a queryable view. Both
...w interface is a heavy dependency, so starting with v2 it is opt-in. Enable it with the duckdb_arrow build tag : go build -tags=duckdb_arrow Without the tag, the Arrow types and functions described here are not compiled in. The interface builds on ap...tines. Further Reading Run Queries — sending the queries whose results this page reads, and reading them row by row. Build Tags — the duckdb_arrow tag that enables the Arrow interface, and the other build tags. Write User Defined Functions — replacem... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
- Union Functions 9843
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...n_value(k := 'hello')).k | | Result | hello | union_extract(union, 'tag') | Description | Extract the value with the named tags from the union. NULL if the tag is not currently selected. | | Example | union_extract(s, 'k') | | Result | hello | union_... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Building Configuration 9556
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...rom sources that are not part of a complete Git repository (e.g., an archive file with no information on commit hashes and tags). For example: OVERRIDE_GIT_DESCRIBE=v0.10.0-843-g09ea97d0a9 GEN=ninja make Will result in the following output when runni...it checkout. The version and commit hash are resolved as follows: If OVERRIDE_GIT_DESCRIBE is set to a full git describe --tags --long string (for example, v1.0.0-843-g09ea97d0a9 ), the version, the development iteration, and the commit hash are all...ent Git commit when Git is available. If OVERRIDE_GIT_DESCRIBE is not set and Git is available, DuckDB runs git describe --tags --long to determine the version and commit hash. If OVERRIDE_GIT_DESCRIBE is not set and Git is not available, DuckDB fall... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Troubleshoot 9251
- 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
...ld and run with the library on the loader path: # On Linux. CGO_ENABLED=1 CGO_LDFLAGS="-lduckdb -L/path/to/libs" go build -tags=duckdb_use_lib main.go LD_LIBRARY_PATH=/path/to/libs ./main # On macOS. CGO_ENABLED=1 CGO_LDFLAGS="-lduckdb -L/path/to/lib...s" go build -tags=duckdb_use_lib main.go DYLD_LIBRARY_PATH=/path/to/libs ./main TIMESTAMP versus TIMESTAMP_TZ In the C API, DuckDB stores bo...ure 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 connection lifetime, whose failures are often build or li... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Storage Versions and Format 8355
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
.... If you attach to DuckDB databases, you can query the storage versions using the following command: SELECT database_name, tags FROM duckdb_databases(); This shows the storage versions: ┌───────────────┬───────────────────────────┐ │ database_name │...le. import duckdb con = duckdb.connect() con.execute("ATTACH 'file.db' AS file_db (READ_ONLY)") print(con.execute( "SELECT tags['storage_version'] FROM duckdb_databases() WHERE database_name = 'file_db'" ).fetchone()[0]) v2.0.0+ Storage Version Table... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Union Type 8219
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...ns UNION types can be cast between each other if the source type is a “subset” of the target type. In other words, all the tags in the source UNION must be present in the target UNION , and all the types of the matching tags must be implicitly castab... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
DuckDB 2.0 Documentation / man.mtool.work