Results of 1 - 10 of about 46 for resulting (0.005 sec.)
- Excel Extension 13944
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...pe Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of the sheet in the xlsx file to read. Default is the first sheet....he range of cells to read, in spreadsheet notation. For example, A1:B2 reads the cells from A1 to B2. If not specified the resulting range will be inferred as rectangular region of cells between the first row of consecutive non-empty cells and the first e...pecified explicitly, (e.g., when using the read_xlsx function instead of COPY TO ... FROM '⟨file⟩.xlsx' ) the types of the resulting columns are inferred based on the first "data" row in the sheet, that is: If no explicit range is given The first row afte... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Appender 11869
- Appenders are the most efficient way of loading data into DuckDB from within the C interface, and are recommended for fast data loading. The appender is much faster than using prepared statements or individual INSERT INTO statements. Append
..._row . After all rows have been appended, duckdb_appender_destroy should be used to finalize the appender and clean up the resulting memory. Note that duckdb_appender_destroy should always be called on the resulting appender, even if the function returns...hema of the table to append to, or nullptr for the default schema. table : The table name to append to. out_appender : The resulting appender object. Return Value DuckDBSuccess on success or DuckDBError on failure. duckdb_appender_create_ext Creates an ap...hema of the table to append to, or nullptr for the default schema. table : The table name to append to. out_appender : The resulting appender object. Return Value DuckDBSuccess on success or DuckDBError on failure. duckdb_appender_create_query Creates an... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Complete API 11609
- 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
...: Path to the database file on disk. Both nullptr and :memory: open or retrieve an in-memory database. out_database : The resulting cached database. config : (Optional) configuration used to create the database. out_error : If set and the function return...This will always succeed unless there is a malloc failure. Note that duckdb_destroy_config should always be called on the resulting config, even if the function returns DuckDBError . Syntax duckdb_state duckdb_create_config ( duckdb_config * out_config )...ers result : The result object to fetch the data chunk from. chunk_index : The chunk index to fetch from. Return Value The resulting data chunk. Returns NULL if the chunk index is out of bounds. duckdb_result_is_streaming Warning Deprecation notice. This... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Unofficial and Unsupported Platforms 9779
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
...n architectures (such as PowerPC) are not supported by DuckDB. While DuckDB can likely be built on such architectures, the resulting binary may exhibit correctness errors on certain operations. Therefore, its use is not recommended. RISC-V Architectures N...uild cmake .. -DCMAKE_BUILD_TYPE=Release make -j$(nproc) Build time is approximately 2 hours on an 8-core SpacemiT K1. The resulting binary works out of the box: ./duckdb -c “SELECT 'Hello from RISC-V' AS message;” ┌───────────────────┐ │ message │ │ varc... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- Types 9519
- 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
...ers result : The result object to fetch the data chunk from. chunk_index : The chunk index to fetch from. Return Value The resulting data chunk. Returns NULL if the chunk index is out of bounds. duckdb_result_is_streaming Warning Deprecation notice. This...rn 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 type is: DUCKDB_TYPE...s. Return Value The logical type. duckdb_create_struct_type Creates a STRUCT type based on the member types and names. The resulting type must be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logical_type duckdb_create_struct_type ( duckdb_lo... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Vectors 8741
- 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
...tr_len : The length of the string (in bytes) duckdb_list_vector_get_child Retrieves the child vector of a list vector. The resulting vector is valid as long as the parent vector is valid. Syntax duckdb_vector duckdb_list_vector_get_child ( duckdb_vector v...ns DuckDBError if the vector is nullptr. duckdb_struct_vector_get_child Retrieves the child vector of a struct vector. The resulting vector is valid as long as the parent vector is valid. Syntax duckdb_vector duckdb_struct_vector_get_child ( duckdb_vector...child index Return Value The child vector duckdb_array_vector_get_child Retrieves the child vector of an array vector. The resulting vector is valid as long as the parent vector is valid. The resulting vector has the size of the parent vector multiplied b... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Bitstring Type 8741
- Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is of variable length. A bitstring value requires 1 byte for each group of 8 bits, plus a fixed amount to sto
...as the VARCHAR string 'b0101' . Creating a BITSTRING with a predefined length is possible with the bitstring function. The resulting bitstring will be left-padded with zeroes. SELECT bitstring('0101011', 12) AS b; b 000000101011 Numeric values (integer an... - https://man.mtool.work/duckdb/2.0/sql/data_types/bitstring.html
- Spatial Functions 8482
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...mplify Simplify the edges in a polygonal coverage, preserving the coverage by ensuring that there are no seams between the resulting simplified polygons. ST_CoverageUnion Union all geometries in a polygonal coverage into a single geometry. ST_CoveredBy Re...presents how many triangles that will be produced to approximate a quarter circle. The larger the number, the smoother the resulting geometry. The default value is 8. cap_style must be one of 'CAP_ROUND' , 'CAP_FLAT' , 'CAP_SQUARE' . This parameter is cas...iption Simplify the edges in a polygonal coverage, preserving the coverage by ensuring that there are no seams between the resulting simplified polygons. By default, the boundary of the coverage is also simplified, but this can be controlled with the opti... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Timestamp with Time Zone Functions 8223
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...d scalar functions for TIMESTAMP WITH TIME ZONE values. Name Description age(timestamptz, timestamptz) Subtract arguments, resulting in the time difference between the two timestamps. age(timestamptz) Subtract from current_date. date_diff(part, starttimes...lt timezone is 'UTC' . Note that 2000-01-03 is a Monday. age(timestamptz, timestamptz) | Description | Subtract arguments, resulting in the time difference between the two timestamps. | | Example | age(TIMESTAMPTZ '2001-04-10', TIMESTAMPTZ '1992-09-20') |...dar. Daylight Saving Time (DST) Transitions When adding calendar intervals such as INTERVAL '1 day' to a TIMESTAMPTZ , the resulting local timestamp may fall on a non-existent time during daylight saving time transitions. DuckDB follows PostgreSQL behavio... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Transaction Management 8223
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...nsaction (inserting “Ada”) was committed but the second (deleting “Ada” and inserting “Bruce”) was aborted. Therefore, the resulting table will only contain <'Ada', 52> .... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
DuckDB 2.0 Documentation / man.mtool.work