Results of 1 - 8 of about 8 for primitive (0.004 sec.)
- Import Data 13537
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...gurable flush count, so adding an application-level batch size on top of the Appender does not improve performance. Prefer primitive columns over complex types. Nested types such as STRUCT , LIST , and UNION cost more per value than flat, primitive column...s. A schema built from primitive columns appends fastest. Avoid allocating a Java object per row. Boxing values or constructing a new object for every row...adds allocation and garbage-collection pressure. Prefer the primitive append() overloads and reuse buffers where you can. Keep strings short where possible. DuckDB stores strings of up to 12 b... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Types 9290
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...nested. Types in the C API are modeled using an enum ( duckdb_type ) and a complex class ( duckdb_logical_type ). For most primitive types, e.g., integers or varchars, the enum is sufficient. For more complex types, such as lists, structs or decimals, the...decimal value. Return Value The converted double element. duckdb_create_logical_type Creates a duckdb_logical_type from a primitive type. The resulting logical type must be destroyed with duckdb_destroy_logical_type . Returns an invalid logical type, if..., or DUCKDB_TYPE_UNION . Syntax duckdb_logical_type duckdb_create_logical_type ( duckdb_type type ); Parameters type : The primitive type to create. Return Value The logical type. duckdb_logical_type_get_alias Returns the alias of a duckdb_logical_type, i... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Write User Defined Functions 9037
- 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
...est functions map directly to a Java functional interface. Pick the overload that matches the number of arguments and, for primitives, their type: withFunction(Supplier) , withFunction(Function) , and withFunction(BiFunction) take zero, one, or two boxed...ction , BiFunction , and the varargs form) receive 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 pass...hParameter() , withParameters() , and withReturnType() accept three forms of type declaration: a Java Class<?> , including primitive class literals such as int.class or Integer.TYPE a DuckDBColumnType enum value a DuckDBLogicalType instance When a type is... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Geometry Data Type 8766
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...metry type and vertex dimensions. When a row group qualifies, DuckDB splits the geometry segment within the row group into primitive STRUCT , LIST , and DOUBLE segments that can be compressed independently using lightweight algorithms - far more efficient...─────────────┤ │ GEOMETRY │ │ VALIDITY │ └──────────────┘ -- While the geometry column in `shredded_db` is decomposed into primitive DOUBLE segments, -- which can be compressed much more efficiently! SELECT DISTINCT(segment_type) FROM pragma_storage_info(... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Vectors 8495
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...ze (that can be obtained through duckdb_data_chunk_get_size ). All vectors that belong to a data chunk have the same size. Primitive Types For primitive types, the underlying array can be obtained using the duckdb_vector_get_data method. The array can the... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Delta Extension 7970
- 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
...T columns scanning tables with deletion vectors column mapping in name and id mode time travel by version or timestamp all primitive types except intervals nested types (structs, lists and maps) creating tables ( CREATE TABLE ) blind appends ( INSERT INTO... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Node.js Client (Neo) 7699
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...'b': 42, 'c': listValue([10, 11, 12]), }); Specifying Values Values of many data types are represented using one of the JS primitives boolean , number , bigint , or string . Also, any type can have null values. Values of some data types need to be constru...DuckDB NULL is always represented as JavaScript null , regardless of the column's type. Types represented as a JavaScript primitive: DuckDB type JavaScript representation BOOLEAN boolean TINYINT , SMALLINT , INTEGER , UTINYINT , USMALLINT , UINTEGER numb... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
- Complete API 7446
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...inated string. The result must be freed with duckdb_free . duckdb_create_logical_type Creates a duckdb_logical_type from a primitive type. The resulting logical type must be destroyed with duckdb_destroy_logical_type . Returns an invalid logical type, if..., or DUCKDB_TYPE_UNION . Syntax duckdb_logical_type duckdb_create_logical_type ( duckdb_type type ); Parameters type : The primitive type to create. Return Value The logical type. duckdb_logical_type_get_alias Returns the alias of a duckdb_logical_type, i... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work