Results of 1 - 10 of about 139 for without (0.002 sec.)
- Timestamp Types 14184
- 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
...stamp Types Name Aliases Description TIMESTAMP_NS Naive timestamp with nanosecond precision TIMESTAMP DATETIME , TIMESTAMP WITHOUT TIME ZONE Naive timestamp with microsecond precision TIMESTAMP_MS Naive timestamp with millisecond precision TIMESTAMP_S N...SELECT TIMESTAMPTZ_NS '1992-09-20 11:30:00.123456789+00'; 1992-09-20 11:30:00.123456789+00 DuckDB distinguishes timestamps WITHOUT TIME ZONE and WITH TIME ZONE . The time zone aware types are TIMESTAMPTZ (microsecond precision) and TIMESTAMPTZ_NS (nanos...ime zone , which defaults to the system time zone and is just UTC+00:00 in the examples above. The corresponding TIMESTAMP WITHOUT TIME ZONE stores the same INT64 , but arithmetic, binning and string formatting follow the straightforward rules of Coordi... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- TRY Expression 11235
- The TRY expression ensures that errors caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired by the TRY_CAST expression . Exa
...mples The following calls return errors when invoked without the TRY expression. When they are wrapped into a TRY expression, they return NULL : Casting Without TRY SELECT 'abc'::INTE...nversion Error: Could not convert string 'abc' to INT32 With TRY SELECT TRY('abc'::INTEGER); NULL Integer Division by Zero Without TRY SELECT 1 // 0; Invalid Input Error: Division by zero in expression (1 // 0). Use TRY(...) to return NULL for this expr...n_division_by_zero=false to return NULL for all divisions by zero. With TRY SELECT TRY(1 // 0); NULL Casting Multiple Rows Without TRY WITH cte AS (FROM (VALUES ('123'), ('test'), ('235')) t(a)) SELECT a::INTEGER AS x FROM cte; Conversion Error: Could n... - https://man.mtool.work/duckdb/2.0/sql/expressions/try.html
- Delta Extension 9277
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...ARCHAR) PARTITIONED BY (region); INSERT INTO events VALUES (1, 'eu'); Only CREATE TABLE needs the full events.events name: without the database name, it creates the table in the default database. The table can be read and written without attaching it ag...); ATTACH 's3://⟨my_bucket⟩/⟨path⟩' AS my_table_then (TYPE delta, TIMESTAMP TIMESTAMPTZ '2026-09-01 12:00:00+00'); -- Scan without attaching SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩', version => 5); -- since v1.5.4 SELECT * FROM delta_scan('s3:...latest version committed at or before it. One later than now() or earlier than the table's first commit fails. A timestamp without a time zone uses the session's TimeZone . Within a transaction, a timestamp always reads the same version. Checkpointing S... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Unity Catalog Extension 9134
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...Note Only Databricks reports a default namespace. When you attach a Unity Catalog OSS catalog, always set DEFAULT_SCHEMA : without it, queries against the catalog fail, even with fully qualified table names. Attach Options When attaching a Unity Catalog...options to ATTACH : Option Type Default Description SECRET VARCHAR unnamed secret Name of the unity_catalog secret to use. Without it, the unnamed unity_catalog secret is used. DEFAULT_SCHEMA VARCHAR detected Schema that unqualified table names resolve...to. Without it, DuckDB asks the server for the workspace's default namespace. READ_ONLY BOOLEAN false Attach the catalog in read-only... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Python 8716
- The DuckDB Python package has its own repository at duckdb/duckdb-python and uses nanobind 3 to create Python bindings with DuckDB. Prerequisites This guide assumes: You have a full clone of the DuckDB Python package source, including its g
...V for Python environment and dependency management. While using pip for a development environment with an editable install without build isolation is possible, we don't provide guidance for that approach in this guide. We use CLion as our IDE. This guid...duckdb-python git remote add upstream https://github.com/duckdb/duckdb-python.git git fetch --all If you've already cloned without submodules: git submodule update --init --recursive git remote add upstream https://github.com/duckdb/duckdb-python.git gi...indows 2. Install Dependencies and Build Set up the development environment in two steps: # Install the build dependencies without building the project uv sync --only-group build --no-install-project -p 3.13 # Build and install the project without build... - https://man.mtool.work/duckdb/2.0/dev/building/python.html
- Schema 8298
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...st experiment, we create the schema with a primary key, then load the data. In the second experiment, we create the schema without a primary key, then load the data. In the third experiment, we create the schema without a primary key, load the data and...z files, and measure the time required to perform the loading. Operation Execution time Load with primary key 461.6 s Load without primary key 121.0 s Load without primary key then add primary key 242.0 s For this dataset, primary keys will only have a... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- LIMIT and OFFSET Clauses 7737
- LIMIT is an output modifier. Logically it is applied at the very end of the query. The LIMIT clause restricts the amount of rows fetched. The OFFSET clause indicates at which position to start reading the values, i.e., the first OFFSET valu
...es are ignored. Note that while LIMIT can be used without an ORDER BY clause, the results might not be deterministic without the ORDER BY clause. This can still be useful, however,... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/limit.html
- Command Line Arguments 7450
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...ect arguments were introduced in DuckDB 2.0. The -serve argument starts a Quack server for the database opened by the CLI. Without a database path or additional configuration, it serves an in-memory database on localhost:9494 : duckdb -serve To serve a...ovide its path before -serve : duckdb analytics.duckdb -serve The -connect argument connects the CLI to a remote database. Without arguments, it connects to the Quack server on localhost:9494 using the default quack secret. If this secret does not exist...yet, -serve creates it as a persistent secret, so running duckdb -serve and duckdb -connect on the same machine works without further setup: duckdb -connect Both arguments accept a connection type and an optional named secret in the form TYPE:SECRE... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- PostgreSQL Extension Functions 7450
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...ange is applied and details are returned. When NULL (default) returns the current state of pools for all attached catalogs without changing their configuration. Must be specified and non-NULL when any other option is specified. acquire_mode ( VARCHAR ,...= ⟨number_higher_then_pool_size⟩ is used, then some of the worker threads are unable to obtain a connection - they return without doing any work and without throwing an error thread_local_cache_enabled ( BOOLEAN ): whether caching the connections cachi...thread_local_cache_hits ( UBIGINT ): the number of times connections were successfully acquired from a thread-local cache without going to the main pool thread_local_cache_misses ( UBIGINT ): the number of times connections were not available in a thre... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- CREATE MACRO Statement 7450
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...diately after the CREATE keyword, which causes an existing macro with the same name (within the schema) to be overwritten. Without OR REPLACE such an attempt will fail with a Macro Function already exists error. An IF NOT EXISTS clause may occur immedia...ault value cannot appear before a definition of a parameter that does not have a default value. In other words, parameters without default values have to be defined "in the front"; any parameters with default values appear "at the back". Multiple parame...eate a macro with a typed parameter: CREATE MACRO is_maximal(a INTEGER) AS a = 2^31 - 1; Table Macros Create a table macro without parameters: CREATE MACRO static_table() AS TABLE SELECT 'Hello' AS column1, 'World' AS column2; Create a table macro with... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
DuckDB 2.0 Documentation / man.mtool.work