Results of 1 - 10 of about 69 for size (0.007 sec.)
- Array Functions – DuckDB 13263
- 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
...te an ARRAY containing the argument values. array_cross_product(array1, array2) Compute the cross product of two arrays of size 3. The array elements can not be NULL . array_cosine_similarity(array1, array2) Compute the cosine similarity between two...arrays of the same size. The array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. arr...ay_cosine_distance(array1, array2) Compute the cosine distance between two arrays of the same size. The array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. Thi... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- Vectors – DuckDB 11001
- 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
...lumn_type . The type id of the logical type can then be obtained using duckdb_get_type_id . Vectors themselves do not have sizes. Instead, the parent data chunk has a size (that can be obtained through duckdb_data_chunk_get_size ). All vectors that b...elong 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 ar...propriate power-of-ten. Enums Enums are stored as unsigned integer values internally. The exact native type depends on the size of the enum dictionary, as shown in the following table: Dictionary size NativeType <= 255 uint8_t <= 65535 uint16_t <= 42... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Complete API – DuckDB 10619
- 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
...n , const char * query , bool qualified ); Configuration duckdb_state duckdb_create_config ( duckdb_config * out_config ); size_t duckdb_config_count (); duckdb_state duckdb_get_config_flag ( size_t index , const char ** out_name , const char ** out_...idx_t row ); bool duckdb_value_is_null ( duckdb_result * result , idx_t col , idx_t row ); Helpers void * duckdb_malloc ( size_t size ); void duckdb_free ( void * ptr ); idx_t duckdb_vector_size (); bool duckdb_string_is_inlined ( duckdb_string_t st...duckdb_create_union_value ( duckdb_logical_type union_type , idx_t tag_index , duckdb_value value ); idx_t duckdb_get_map_size ( duckdb_value value ); duckdb_value duckdb_get_map_key ( duckdb_value value , idx_t index ); duckdb_value duckdb_get_map_... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Data Chunks – DuckDB 10025
- 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
...s Data chunks represent a horizontal slice of a table. They hold a number of vectors , that can each hold up to the VECTOR_SIZE rows. The vector size can be obtained through the duckdb_vector_size function and is configurable, but is usually set to 2...unk ); duckdb_vector duckdb_data_chunk_get_vector ( duckdb_data_chunk chunk , idx_t col_idx ); idx_t duckdb_data_chunk_get_size ( duckdb_data_chunk chunk ); void duckdb_data_chunk_set_size ( duckdb_data_chunk chunk , idx_t size ); duckdb_create_data_...nk , idx_t col_idx ); Parameters chunk : The data chunk to get the data from Return Value The vector duckdb_data_chunk_get_size Retrieves the current number of tuples in a data chunk. Syntax idx_t duckdb_data_chunk_get_size ( duckdb_data_chunk chunk... - https://man.mtool.work/duckdb/1.3/clients/c/data_chunk.html
- Pragmas – DuckDB 9544
- 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
...e VARCHAR , -- default value of the column, or NULL if not specified pk BOOLEAN -- part of the primary key or not Database Size Get the file and memory size of each database: PRAGMA database_size ; CALL pragma_database_size (); database_size returns...information about the file and memory size of each database. The column types of the returned results are given below: database_name VARCHAR , -- database name datab...ase_size VARCHAR , -- total block count times the block size block_size BIGINT , -- database block size total_blocks BIGINT , -- to... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Limits – DuckDB 9276
- 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
...its This page contains DuckDB's built-in limit values. Limit Values Limit Default value Configuration option Comment Array size 100000 - BLOB size 4 GB - Expression depth 1000 max_expression_depth Memory allocation for a vector 128 GB - Memory use 80...% of RAM memory_limit Note: This limit only applies to the buffer manager. String size 4 GB - Temporary directory size unlimited max_temp_directory_size Size of Database Files DuckDB doesn't have a practical l...imit for the size of a single DuckDB database file. We have database files using 15 TB+ of disk space and they work fine. However, connectin... - https://man.mtool.work/duckdb/1.3/operations_manual/limits.html
- Parquet Tips – DuckDB 9049
- 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
...OPY ( FROM generate_series ( 10_000_000 )) TO 'test.parquet' ( FORMAT parquet , PER_THREAD_OUTPUT ); Selecting a ROW_GROUP_SIZE The ROW_GROUP_SIZE parameter specifies the minimum number of rows in a Parquet row group, with a minimum value equal to Du...ckDB's vector size, 2,048, and a default of 122,880. A Parquet row group is a partition of rows, consisting of a column chunk for each column...in the dataset. Compression algorithms are only applied per row group, so the larger the row group size, the more opportunities to compress the data. DuckDB can read Parquet row groups in parallel even within the same file and... - https://man.mtool.work/duckdb/1.3/data/parquet/tips.html
- Directly Reading Files – DuckDB 8781
- 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
..., and output the content of each file as a VARCHAR or BLOB , respectively, as well as additional metadata such as the file size and last modified time. read_text The read_text table function reads from the selected source(s) to a VARCHAR . Each file...results in a single row with the content field holding the entire content of the respective file. SELECT size , parse_path ( filename ), content FROM read_text ( 'test/sql/table_function/files/*.txt' ); size parse_path(filename) con...ting to use read_blob instead. read_blob The read_blob table function reads from the selected source(s) to a BLOB : SELECT size , content , filename FROM read_blob ( 'test/sql/table_function/files/*' ); size content filename 178 PK\x03\x04\x0A\x00\x0... - https://man.mtool.work/duckdb/1.3/guides/file_formats/read_file.html
- CSV Auto Detection – DuckDB 8413
- 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
..., we can override it by calling the read_csv with an explicit delimiter (e.g., read_csv('file.csv', delim = '|') ). Sample Size The type detection works by operating on a sample of the file. The size of the sample can be modified by setting the sampl...e_size parameter. The default sample size is 20,480 rows. Setting the sample_size parameter to -1 means the entire file is read f...or sampling: SELECT * FROM read_csv ( 'my_csv_file.csv' , sample_size = -1 ); The way sampling is performed depends on the type of file. If we are reading from a regular file on disk, we will... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Reading and Writing Parquet Files – DuckDB 8413
- 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
...appy.parquet' ( FORMAT parquet ); Write the results from a query to a Parquet file with specific compression and row group size: COPY ( FROM generate_series ( 100_000 )) TO 'test.parquet' ( FORMAT parquet , COMPRESSION zstd , ROW_GROUP_SIZE 100_000 )...or pushing filters and projections into the Parquet file scans. Parquet data sets differ based on the number of files, the size of individual files, the compression algorithm used, row group size, etc. These have a significant effect on performance....arquet' ( FORMAT parquet , COMPRESSION uncompressed ); Write a query to a Parquet file with zstd-compression and row group size: COPY ( FROM generate_series ( 100_000 )) TO 'row-groups-zstd.parquet' ( FORMAT parquet , COMPRESSION zstd , ROW_GROUP_SIZ... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
DuckDB 1.3 Documentation / man.mtool.work