Results of 1 - 10 of about 52 for cannot (0.006 sec.)
- Values – DuckDB 14039
- 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
...l ( duckdb_value val ); Parameters val : A duckdb_value containing a boolean Return Value A boolean, or false if the value cannot be converted duckdb_get_int8 Returns the int8_t value of the given value. Syntax int8_t duckdb_get_int8 ( duckdb_value val...); Parameters val : A duckdb_value containing a tinyint Return Value A int8_t, or MinValue if the value cannot be converted duckdb_get_uint8 Returns the uint8_t value of the given value. Syntax uint8_t duckdb_get_uint8 ( duckdb_value...val ); Parameters val : A duckdb_value containing a utinyint Return Value A uint8_t, or MinValue if the value cannot be converted duckdb_get_int16 Returns the int16_t value of the given value. Syntax int16_t duckdb_get_int16 ( duckdb_value... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Complete API – DuckDB 13606
- 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
...r code-bases. If this function is used, none of the other result functions can be used and vice versa (i.e., this function cannot be mixed with the legacy result functions). Use duckdb_result_chunk_count to figure out how many chunks there are in the r...scheduled for removal in a future release. Return Value The boolean value at the specified location, or false if the value cannot be converted. Syntax bool duckdb_value_boolean ( duckdb_result * result , idx_t col , idx_t row ); duckdb_value_int8 Warni...d is scheduled for removal in a future release. Return Value The int8_t value at the specified location, or 0 if the value cannot be converted. Syntax int8_t duckdb_value_int8 ( duckdb_result * result , idx_t col , idx_t row ); duckdb_value_int16 Warni... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Securing DuckDB – DuckDB 10126
- 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
...the enable_external_access option option to false . SET enable_external_access = false ; This setting implies that: ATTACH cannot attach to a database in a file. COPY cannot read to or write from files. Functions such as read_csv , read_parquet , read_...json , etc. cannot read from an external source. The allowed_directories and allowed_paths Options You can restrict DuckDB's access to certai...est.csv' ); With the setting applied, DuckDB will refuse to read files in the current working directory: Permission Error: Cannot access file "test.csv" - file system operations are disabled by configuration Secrets Secrets are used to manage credentia... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- Safe Mode – DuckDB 10021
- 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 targets. The getenv function is disabled. The enable_external_access option is set to false . This implies that: ATTACH cannot attach to a database in a file. COPY cannot read to or write from files. Functions such as read_csv , read_parquet , read_...json , etc. cannot read from an external source. Once safe mode is activated, it cannot be deactivated in the same DuckDB CLI session. For mo...re information on running DuckDB in secure environments, see the “Securing DuckDB” page . 関連キーワード read DuckDB cannot safe mode external files prevented database file system following disabled complete Documentation Client APIs Copy Markdow... - https://man.mtool.work/duckdb/1.3/clients/cli/safe_mode.html
- CSV Auto Detection – DuckDB 8543
- 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
...will jump into the file and try to sample from different locations in the file. If we are reading from a file in which we cannot jump – such as a .gz compressed CSV file or stdin – samples are taken only from the beginning of the file. sniff_csv Funct...e cast to VARCHAR , therefore, this type has the lowest priority meaning that all columns are converted to VARCHAR if they cannot be cast to anything else. In flights.csv the FlightDate column will be cast to a DATE , while the other columns will be ca...row. In files that do not have a header row, the column names are generated as column0 , column1 , etc. Note that headers cannot be detected correctly if all columns are of type VARCHAR – as in this case the system cannot distinguish the header row fr... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Literal Types – DuckDB 8543
- 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
...he value fits. For example, the integer literal 42 can be implicitly converted to a TINYINT , but the integer literal 1000 cannot be. Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character (...sing underscores are as follows: Underscores are allowed in integer, decimal, hexadecimal and binary notation. Underscores can not be the first or last character in a literal. Underscores have to have an integer/numeric part on either side of them, i.e...., there can not be multiple underscores in a row and not immediately before/after a decimal or exponent. Examples: SELECT 100_000_000 ; -... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Collations – DuckDB 8438
- 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
...be combined together. In general, the NOCASE collation can be combined with any other collator, but most other collations cannot be combined. SELECT 'hello' COLLATE NOCASE = 'hElLÖ' ; false SELECT 'hello' COLLATE NOACCENT = 'hElLÖ' ; false SELECT 'hel...LUES ( 'hännes' ); SELECT name FROM names WHERE name = 'hannes' ; hännes Be careful here, however, as different collations cannot be combined. This can be problematic when you want to compare columns that have a different collation specified. SELECT na...me FROM names WHERE name = 'hannes' COLLATE NOCASE ; ERROR: Cannot combine types with different collation! CREATE TABLE other_names ( name VARCHAR COLLATE NOCASE ); INSERT INTO other_names... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- TRY expression – DuckDB 8438
- 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
...to INT32 With TRY SELECT TRY ( 'abc' :: INTEGER ); NULL Logarithm on Zero Without TRY SELECT ln ( 0 ); Out of Range Error: cannot take logarithm of zero With TRY SELECT TRY ( ln ( 0 )); NULL Casting Multiple Rows Without TRY WITH cte AS ( FROM ( VALUES...LUES ( '123' ), ( 'test' ), ( '235' )) t ( a )) SELECT TRY ( a :: INTEGER ) AS x FROM cte ; x 123 NULL 235 Limitations TRY cannot be used in combination with a volatile function or with a scalar subquery . For example: SELECT TRY ( random ()) Binder Er...ror: TRY can not be used in combination with a volatile function 関連キーワード expression Without errors rows scalar return they Casting... - https://man.mtool.work/duckdb/1.3/sql/expressions/try.html
- Typecasting – DuckDB 8333
- 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
...red type. Implicit casts can only be added for a number of type combinations, and is generally only possible when the cast cannot fail. For example, an implicit cast can be added from INTEGER to DOUBLE – but not from DOUBLE to INTEGER . Consider the fu...T ), and nested type constructors ( list_value / [...] / MAP ). Casting Operations Matrix Values of a particular data type cannot always be cast to any arbitrary target data type. The only exception is the NULL value – which can always be converted bet...T ( 42.5 AS VARCHAR ); Casting from VARCHAR to another data type is supported, but can raise an error at runtime if DuckDB cannot parse and convert the provided text to the target data type. SELECT CAST ( 'NotANumber' AS INTEGER ); In general, casting... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Tuning Workloads – DuckDB 7811
- 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
...he available system memory (also known as out-of-core processing ). It can also run queries where the intermediate results cannot fit into memory. This section explains the prerequisites, scope, and known limitations of larger-than-memory processing in...p_directory configuration option , e.g.: SET temp_directory = '/path/to/temp_dir.tmp/' ; Blocking Operators Some operators cannot output a single row until the last row of their input has been seen. These are called blocking operators as they require t...Aggregate functions that use sorting are holistic, i.e., they need all inputs before the aggregation can start. As DuckDB cannot yet offload some complex intermediate aggregate states to disk, these functions can cause an out-of-memory exception when... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
DuckDB 1.3 Documentation / man.mtool.work