Results of 1 - 10 of about 35 for require (0.003 sec.)
- Catch C/C++ Tests – DuckDB 14958
- 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
...tabase ); { // create a database and insert values DuckDB db ( storage_database , config . get ()); Connection con ( db ); REQUIRE_NO_FAIL ( con . Query ( "CREATE TABLE test (a INTEGER, b INTEGER);" )); REQUIRE_NO_FAIL ( con . Query ( "INSERT INTO test...VALUES (11, 22), (13, 22), (12, 21), (NULL, NULL)" )); REQUIRE_NO_FAIL ( con . Query ( "CREATE TABLE test2 (a INTEGER);" )); REQUIRE_NO_FAIL ( con . Query ( "INSERT INTO test2 VALUES (1...db ( storage_database , config . get ()); Connection con ( db ); result = con . Query ( "SELECT * FROM test ORDER BY a" ); REQUIRE ( CHECK_COLUMN ( result , 0 , { Value (), 11 , 12 , 13 })); REQUIRE ( CHECK_COLUMN ( result , 1 , { Value (), 22 , 21 , 22... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/catch.html
- sqllogictest Introduction – DuckDB 12364
- 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
...of the temporary testing directory. statement ok COPY csv_data TO '__TEST_DIR__/output_file.csv.gz' ( COMPRESSION gzip ); Require & Extensions To avoid bloating the core system, certain functionality of DuckDB is available only as an extension. Tests c...an be build for those extensions by adding a require field in the test. If the extension is not loaded, any statements that occurs after the require field will be skipped. Exa...mples of this are require parquet or require icu . Another usage is to limit a test to a specific vector size. For example, adding require vector_si... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Environment – 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
...n both AMD64 (x86_64) and ARM64 (AArch64) CPU architectures. Memory Bestpractice Aim for 1-4 GB memory per thread. Minimum Required Memory As a rule of thumb, DuckDB requires a minimum of 125 MB of memory per thread. For example, if you use 8 threads, y...der limiting the number of threads , e.g., by issuing: SET threads = 4 ; Memory for Ideal Performance The amount of memory required for ideal performance depends on several factors, including the data set size and the queries to execute. Maybe surprisin...gly, the queries have a larger effect on the memory requirement. Workloads containing large joins over many-to-many tables yield large intermediate datasets and thus require more mem... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
- Set Operations – 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
...plicates, while the variants with ALL use bag semantics. Traditional set operations unify queries by column position , and require the to-be-combined queries to have the same number of input columns. If the columns are not of the same type, casts may be...ery. DuckDB also supports UNION [ALL] BY NAME , which joins columns by name instead of by position. UNION BY NAME does not require the inputs to have the same number of columns. NULL values will be added in case of missing columns. UNION The UNION claus...e can be used to combine rows from multiple queries. The queries are required to return the same number of columns. Implicit casting to one of the returned types is performed to combine columns of di... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- Securing Extensions – DuckDB 8990
- 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
...ension repositories and have picked what we think is a sensible approach: we do not attempt to review the submissions, but require that the source code of extensions is available . We do take over the complete build, sign and distribution process. Note...xtensions = false ; To lock this configuration, use the lock_configuration option : SET lock_configuration = true ; Always Require Signed Extensions By default, DuckDB requires extensions to be either signed as core extensions (created by the DuckDB dev...ew of Security Levels for Extensions Community Extensions Disabling Autoinstalling and Autoloading Known Extensions Always Require Signed Extensions... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/securing_ext...
- Overview – DuckDB 8592
- 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
...DuckDB's SQL dialect is based on PostgreSQL. DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior. For example, interchangeability with data frame libraries necessitates order preservation of...ド DuckDB PostgreSQL Documentation Dialect Copy Markdown Overview dialect based tries closely match semantics however cases require slightly different behavior example interchangeability frame libraries necessitates order 関連するページ SQL Quirks Non Po... - https://man.mtool.work/duckdb/1.3/sql/dialect/overview.html
- Legacy Authentication Scheme for S3 API – DuckDB 8210
- 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
...ng between path-style and vhost-style URLs is possible using: SET s3_url_style = 'path' ; However, note that this may also require updating the endpoint. For example for AWS S3 it is required to change the endpoint to s3 . region .amazonaws.com . After...; SET s3_secret_access_key = ' aws_secret_access_key ' ; Alternatively, temporary S3 credentials are also supported. They require setting an additional session token: SET s3_session_token = ' aws_session_token ' ; The aws extension allows for loading A... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api_legacy_authentica...
- Iceberg REST Catalogs – DuckDB 8210
- 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
...RI VARCHAR NULL OAuth2 server url for getting a Bearer Token AUTHORIZATION_TYPE VARCHAR OAUTH2 Pass SigV4 for Catalogs the require SigV4 authorization The following options can only be passed to a CREATE SECRET statement, and they require AUTHORIZATION_... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
- Node.js API – DuckDB 8083
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...he SQLite Node.js client for easier transition. Initializing Load the package and create a database object: const duckdb = require ( ' duckdb ' ); const db = new duckdb . Database ( ' :memory: ' ); // or a file name for a persistent DB All options as de...}); }); Inserting Data via Arrow Apache Arrow can be used to insert data into DuckDB without making a copy: const arrow = require ( ' apache-arrow ' ); const db = new duckdb . Database ( ' :memory: ' ); const jsonData = [ { " userId " : 1 , " id " : 1... - https://man.mtool.work/duckdb/1.3/clients/nodejs/overview.html
- Storage Versions and Format – DuckDB 7956
- 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
...ion methods used, etc. As a rough approximation, loading 100 GB of uncompressed CSV files into a DuckDB database file will require 25 GB of disk space, while loading 100 GB of Parquet files will require 120 GB of disk space. Row Groups DuckDB's storage... - https://man.mtool.work/duckdb/1.3/internals/storage.html
DuckDB 1.3 Documentation / man.mtool.work