Results of 1 - 10 of about 26 for long (0.005 sec.)
- Array Functions – DuckDB 15092
- 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
...osine 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. array_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. This is equivalent to 1.0 - array_cosine_similarity . array_distance(array1, a...ute the 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. array_inner_product(array1, array2) Compute the inner product between two arra... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- Create Synthetic Data – DuckDB 12332
- 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
...andom_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" , rando...om_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, random_date() AS creationDate, 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/1.3/guides/snippets/create_synthetic_data.html
- Configuration – DuckDB 8463
- 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
...memory_limit = '10GB' ; Configure the system to use 1 thread. SET threads TO 1 ; Enable printing of a progress bar during long-running queries. SET enable_progress_bar = true ; Set the default null order to NULLS LAST . SET default_null_order = 'nul...ble_progress_bar' is true BOOLEAN true enable_progress_bar Enables the progress bar, printing progress to the terminal for long queries BOOLEAN true errors_as_json Output error messages as structured JSON instead of as a raw string BOOLEAN false expl...filing_mode The profiling mode ( STANDARD or DETAILED ) VARCHAR NULL progress_bar_time Sets the time (in milliseconds) how long a query needs to take before we start printing a progress bar BIGINT 2000 scalar_subquery_error_on_multiple_rows When a sc... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Data Types – DuckDB 8463
- 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
...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 BOO...d constraint violations . Nesting ARRAY , LIST , MAP , STRUCT , 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 , '... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Complete API – DuckDB 8331
- 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
...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 developers plan to carry out...y deprecated in v1.0 is to denote that they are not part of the v1.0 stable API, which contains methods that are available long-term. API Reference Overview Open Connect duckdb_instance_cache duckdb_create_instance_cache (); duckdb_state duckdb_get_o...MinValue if the value cannot be converted duckdb_get_value_type Returns the type of the given value. The type is valid as long as the value is not destroyed. The type itself must not be destroyed. Syntax duckdb_logical_type duckdb_get_value_type ( d... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Friendly SQL – DuckDB 8331
- 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
...lows replacing specific columns with different expressions in a * expression. UNION BY NAME : perform the UNION operation along the names of columns (instead of relying on positions). Prefix aliases in the SELECT and FROM clauses : write x: 42 instea...e table size for the LIMIT clause : write LIMIT 10% to return 10% of the query results. Transforming tables: PIVOT to turn long tables to wide tables. UNPIVOT to turn wide tables to long tables. Defining SQL-level variables: SET VARIABLE RESET VARIAB... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Vectors – DuckDB 8182
- 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
.... Instead, the parent data chunk has a size (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 du...special struct that stores the string inline (if it is short, i.e., <= 12 bytes ) or a pointer to the string data if it is longer than 12 bytes. typedef struct { union { struct { uint32_t length ; char prefix [ 4 ]; char * ptr ; } pointer ; struct {...ect ( db , & con ); duckdb_result res ; duckdb_query ( con , "SELECT CASE WHEN i%2=0 THEN CONCAT('short_', i) ELSE CONCAT('longstringprefix', i) END FROM range(10) t(i)" , & res ); // iterate until result is exhausted while ( true ) { duckdb_data_chu... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- UNPIVOT Statement – DuckDB 8182
- 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
...d a simplified UNPIVOT syntax. Both can utilize a COLUMNS expression to automatically detect the columns to unpivot. PIVOT_LONGER may also be used in place of the UNPIVOT keyword. For details on how the UNPIVOT statement is implemented, see the Pivot...h 1, 2, or 3), and a separate row for each quarter. Since there are fewer quarters than months, this does make the dataset longer, but not as long as the above. To accomplish this, multiple sets of columns are included in the ON clause. The q1 and q2...CT statement as a CTE ( a Common Table Expression, or WITH clause ), or a subquery. This allows for an UNPIVOT to be used alongside other SQL logic, as well as for multiple UNPIVOT s to be used in one query. No SELECT is needed within the CTE, the UN... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- Concurrency – DuckDB 7769
- 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
...ncurrency within a Single Process DuckDB supports concurrency within a single process according to the following rules. As long as there are no write conflicts, multiple concurrent writes will succeed. Appends will never conflict, even on the same ta... - https://man.mtool.work/duckdb/1.3/connect/concurrency.html
- Combining Schemas – DuckDB 7769
- 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
...chema of the first file provided, and then unifies columns in subsequent files by column position. This works correctly as long as all files have the same schema. If the schema of the files differs, you might want to use the union_by_name option to a... - https://man.mtool.work/duckdb/1.3/data/multiple_files/combining_schemas.html
DuckDB 1.3 Documentation / man.mtool.work