Results of 1 - 10 of about 49 for long (0.002 sec.)
- Array Functions 14217
- All LIST functions work with the ARRAY data type . Additionally, several ARRAY -native functions are also supported. Array-Native Functions Function Description array_cosine_distance(array1, array2) Computes the cosine distance between two
...arrays of the same size. The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cosine_similarity(array1, array2) Computes the cosine similarity between...two arrays of the same size. The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cross_product(array, array) Computes the cross product of two arrays of...utes the distance between two arrays of the same size. The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_dot_product(array1, array2) Alias for array_inner_product . array_inner_... - https://man.mtool.work/duckdb/2.0/sql/functions/array.html
- Write User Defined Functions 13990
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...rized interface, along with type mapping and the function registry. Scalar Functions Build a scalar function with the DuckDBFunctions.scalarFunct...nction(Function) , and withFunction(BiFunction) take zero, one, or two boxed ( Object ) arguments. withIntFunction() , withLongFunction() , and withDoubleFunction() take a unary or binary operator over INTEGER , BIGINT , or DOUBLE and avoid boxing. i...eive null for a NULL input and may return null to produce a NULL result. The primitive callbacks ( withIntFunction() , withLongFunction() , and withDoubleFunction() ) are never handed a null . When DuckDB passes a NULL , the driver skips the Java cal... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Create Synthetic Data 10504
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...aker() def random_date(): return fake.date_between() def random_short_text(): return fake.text(max_nb_chars=20) def random_long_text(): return fake.text(max_nb_chars=200) con = duckdb.connect() con.create_function("random_date", random_date, [], DATE...unction("random_short_text", random_short_text, [], VARCHAR, type="native", side_effects=True) con.create_function("random_long_text", random_long_text, [], VARCHAR, type="native", side_effects=True) res = con.sql(""" SELECT hash(i * 10 + j) AS id, r...andom_date() AS creation_date, random_short_text() AS short, random_long_text() AS long, IF (j % 2, TRUE, FALSE) AS bool FROM generate_series(1, 5) s(i) CROSS JOIN generate_series(1, 2) t(j) """)... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Profile and Monitor 8874
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...nnection. Setting Statement.setQueryTimeout(seconds) arms an automatic cancellation after the given number of seconds. For long-running queries, DuckDBPreparedStatement.getQueryProgress() returns a QueryProgress snapshot while the query executes. It...JFR-aware tool — JDK Mission Control, the jfr command line tool, continuous profilers — can ingest DuckDB memory metrics alongside the rest of the JVM signal. The feature is strictly opt-in and is a silent no-op on JVMs without JFR support: nothing...he jdbc_jfr_memory_monitor value. tag String DuckDB memory tag, such as BASE_TABLE , HASH_TABLE , or ALLOCATOR . dbAddress long Native address of the DuckDB instance, a stable per-instance identifier. memoryUsageBytes long Bytes currently allocated f... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Run Queries 8436
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...g.duckdb.DuckDBDate; import org.duckdb.DuckDBTime; import org.duckdb.DuckDBTimestamp; import org.duckdb.DuckDBTimestampTZ; long days = new DuckDBDate(Date.valueOf("2024-01-15")).getDaysSinceEpoch(); // 19737 long micros = new DuckDBTimestamp(Timestam...p.valueOf("2024-01-15 12:30:00")).getMicrosEpoch(); long zonedMicros = new DuckDBTimestampTZ(OffsetDateTime.parse("2024-01-15T12:30:00Z")).getMicrosEpoch(); long timeMicros = new... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Profile and Monitor 8436
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...with total_time . Read a node's metrics through its metrics map and its children through children . Interrupting Queries A long-running query can be cancelled from another thread. Call interrupt_handle() on the connection to get an Arc<InterruptHandl... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Building Configuration 7893
- 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
...: BUILD_BENCHMARK=1 make debug The Python, Java (JDBC) and ODBC clients are maintained in separate repositories and are no longer built from the main DuckDB repository. See the Python , Java and ODBC repositories for their build instructions. BUILD_B...kout. 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 extract...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 falls back... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Data Types 7893
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...standard and hence might not be accepted by other database engines. Name Aliases Description BIGINT INT8 , LONG Signed eight-byte integer BIT BITSTRING String of 1s and 0s BLOB BYTEA , BINARY , VARBINARY Variable-length binary data BI...traint violations . Nesting ARRAY , LIST , MAP , STRUCT , TUPLE and UNION types can be arbitrarily nested to any depth, so long as the type rules are observed. Struct with LIST s: SELECT {'birds': ['duck', 'goose', 'heron'], 'aliens': NULL, 'amphibia... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Handle Results 7787
- Overview Beyond the standard JDBC ResultSet , the DuckDB driver can hand results to Apache Arrow , stream large results instead of materializing them, and expose raw columnar data chunks. This page covers each of these result-handling optio
...from the result DuckDBDataChunkReader chunk = res.chunk(); // iterate over the chunk columns, all indices are 0-based for (long col = 0; col < chunk.columnCount(); col++) { // get a vector for the specified column DuckDBReadableVector vector = chunk....vector(col); // iterate over the vector rows for (long row = 0; row < chunk.rowCount(); row++) { int val = vector.getInt(row); System.out.println(val); } } } } } Statement param... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- Release Cycle 7787
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
...2026 and v2.0.0 in October 2026 Patch releases are issued as needed for all supported versions: The latest stable version Long Term Support (LTS) versions within their support period Versions with extended support (e.g., v1.5, which is supported unt...e Three branch extension : Extension with three active branches: main, vx.y-codename , and vx.<y+1>-codename LTS release : Long term support release. These releases will receive support (patch releases) beyond their lifetime in the active release cyc...release of DuckDB. These tags are write-only and will always be tied to the same commit The Main DuckDB Release Cycle LTS (Long-Term Support) releases follow a separate maintenance cycle to provide extended support and stability. The main DuckDB rele... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
DuckDB 2.0 Documentation / man.mtool.work