Results of 1 - 10 of about 17 for specification (0.004 sec.)
- Relational API 14777
- 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
...list of columns to include in the GROUP BY ; cannot be combined with window_spec . * window_spec : str, default: '' Window specification, written as OVER (PARTITION BY ... ORDER BY ...) ; cannot be combined with groups . * projected_columns : str, default: ''...list of columns to include in the GROUP BY ; cannot be combined with window_spec . * window_spec : str, default: '' Window specification, written as OVER (PARTITION BY ... ORDER BY ...) ; cannot be combined with groups . * projected_columns : str, default: ''...list of columns to include in the GROUP BY ; cannot be combined with window_spec . * window_spec : str, default: '' Window specification, written as OVER (PARTITION BY ... ORDER BY ...) ; cannot be combined with groups . * projected_columns : str, default: ''... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Parquet Encryption 10207
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...ion currently has the following limitations. DuckDB encrypts the footer and all columns using the footer_key . The Parquet specification allows encryption of individual columns with different keys, e.g.: COPY tbl TO 'tbl.parquet' (ENCRYPTION_CONFIG { footer_k... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- Timestamp Types 9380
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...common data cleaning problem to disambiguate such observations, which may also be stored in raw strings without time zone specification or UTC offsets, into unambiguous TIMESTAMP WITH TIME ZONE instants. One possible solution to this is to append UTC offsets...P WITH TIME ZONE . Alternatively, a TIMESTAMP WITHOUT TIME ZONE may be created first and then be combined with a time zone specification to obtain a time zone aware TIMESTAMP WITH TIME ZONE . Conversion between Strings and Naïve / Time Zone-Aware Timestamps T...n the configured time zone. When strings with UTC offsets are passed to a WITHOUT TIME ZONE type, the offsets or time zone specifications are ignored. Starting with DuckDB 2.0, time zone names in strings passed to a WITHOUT TIME ZONE type are also ignored (in... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- DuckDB Repositories 9052
- Several components of DuckDB are maintained in separate repositories. Main Repositories duckdb : core DuckDB project duckdb-web : documentation and blog duckdb-quack : Quack remote protocol Clients duckdb-go : Go client duckdb-java : Java (
...tories are linked in the Official Extensions page Community extensions are served from the Community Extensions repository Specifications DuckLake specification... - https://man.mtool.work/duckdb/2.0/dev/repositories.html
- SELECT Clause 9052
- The SELECT clause specifies the list of columns that will be returned by the query. While it appears first in the clause, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that
...ion of values relative to other rows in a result. Window functions are marked by the OVER clause which contains the window specification . The window specification defines the frame or context in which the window function is computed. See the window functions... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/select.html
- Versioning of Extensions 8569
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...s compiled from the source code corresponding to the tag. Semantic Versioning semantics apply. See the Semantic Versioning specification for details. The extension follows a release cycle where new features are tested in nightly builds before being grouped in...should now be stable and will only change in backwards incompatible ways when the major version is bumped. See the SemVer specification for details Release Cycle of Pre-Release and Stable Core Extensions In general for extensions the release cycle depends on... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
- Java (JDBC) Client 8242
- Installation To use the DuckDB Java (JDBC) client, visit the Java installation page . The latest stable version of the DuckDB Java (JDBC) client is 2.0.0. The DuckDB Java (JDBC) client lets Java applications query DuckDB through the standar
...DuckDB-specific parts. Refer to the externally hosted API Reference for more information about our extensions to the JDBC specification, or the Arrow Methods . Opening a Connection In JDBC, database connections are created through the standard java.sql.Drive... - https://man.mtool.work/duckdb/2.0/clients/java/overview.html
- TPC-H Extension 8242
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...6 GB) Warning Note that the TPC-H databases generated by the tpch extension have small differences from the official TPC-H specification. To obtain fully TPC-compliant datasets, use the tpchgen-cli project . Limitation The tpch(⟨query_id⟩) function runs a fix... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- ADBC Client 7914
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...scussion on ADBC and a detailed API explanation. Implemented Functionality The DuckDB-ADBC driver implements the full ADBC specification, with the exception of the ConnectionReadPartition , StatementExecutePartitions and StatementSetSubstraitPlan functions. T...R_VERSION Driver version. 102 ADBC_INFO_DRIVER_ARROW_VERSION Arrow library version. 103 ADBC_INFO_DRIVER_ADBC_VERSION ADBC specification version supported by the driver (as an integer, e.g., 1001000 for 1.1.0). A set of functions with transaction semantics fo... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
- DuckLake 7914
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...s_created . Parameter name Parameter type Named parameter Description catalog VARCHAR no Compatibility Matrix The DuckLake specification and the ducklake DuckDB extension are currently released together. See the Compatibility Matrix .... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
DuckDB 2.0 Documentation / man.mtool.work