Results of 1 - 10 of about 35 for resulting (0.007 sec.)
- Excel Extension – DuckDB 13382
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/core_extensions/excel.html
- Complete API – DuckDB 12141
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...: 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/1.3/clients/c/api.html
- Appender – DuckDB 11632
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..._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_column_count Returns the... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- Building Extensions – DuckDB 10391
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Development / Building DuckDB Copy Markdown Building Extensions Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the CORE_EXTENSIONS flag to the list of extensions t...SIONS = 'autocomplete;httpfs;icu;json;tpch;delta' GEN = ninja make In most cases, extension will be directly linked in the resulting DuckDB executable. Special Extension Flags BUILD_JEMALLOC When this flag is set, the jemalloc extension is built. BUILD_TP...ions make enabled these crash checks Building DuckDB Extensions built autocomplete json ninja used debug builds don't sure resulting using 関連するページ Building Configuration Advanced Installation Methods Extension Distribution Python Raspberry Pi Linux... - https://man.mtool.work/duckdb/1.3/dev/building/building_extensions.html
- Types – DuckDB 9627
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/clients/c/types.html
- Vectors – DuckDB 9627
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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/1.3/clients/c/vector.html
- Star Expression – DuckDB 8386
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...NS expression is similar to the regular star expression, but additionally allows you to execute the same expression on the resulting columns. CREATE TABLE numbers ( id INTEGER , number INTEGER ); INSERT INTO numbers VALUES ( 1 , 10 ), ( 2 , 20 ), ( 3 , NU...b , true c ); result result result NULL 42 true With *COLUMNS , the expression expands in its parent expression coalesce , resulting in a single result column: SELECT coalesce ( * COLUMNS ([ 'a' , 'b' , 'c' ])) AS result FROM ( SELECT NULL AS a , 42 AS b... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- Spatial Functions – DuckDB 7876
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...y Simplify the edges in a polygonal coverage, preserving the coverange by ensuring that the 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 case-i...n Simplify the edges in a polygonal coverage, preserving the coverange by ensuring that the 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/1.3/core_extensions/spatial/functions.html
- JSON Processing Functions – DuckDB 7876
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rom the same JSON, it is more efficient to extract a list of paths: The following will cause the JSON to be parsed twice,: Resulting in a slower query that uses more memory: SELECT json_extract ( j , 'family' ) AS family , json_extract ( j , 'species' ) A...e optional path argument is supplied, traversal starts from the element at the given path instead of the root element. The resulting table has the following columns: Field Type Description key VARCHAR Key of element relative to its parent value JSON Value... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Bitstring Type – DuckDB 7638
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...01010' :: BITSTRING AS b ; b 101010 Create a BITSTRING with 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 (integ... - https://man.mtool.work/duckdb/1.3/sql/data_types/bitstring.html
DuckDB 1.3 Documentation / man.mtool.work