Results of 1 - 10 of about 19 for throw (0.005 sec.)
- Python Function API – DuckDB 14411
- 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
...ior for NULL values by setting null_handling = 'special' . exception_handling (optional): By default, when an exception is thrown from the Python function, it will be re-thrown in Python. Users can disable this behavior, and instead return NULL , by s..."SELECT return_str_or_none('')" ). fetchall () print ( res ) [(None,)] Exception Handling By default, when an exception is thrown from the Python function, we'll forward (re-throw) the exception. If you want to disable this behavior, and instead retur...n NULL , you'll need to set this parameter to "return_null" . import duckdb from duckdb.typing import * def will_throw (): raise ValueError ( "ERROR" ) duckdb . create_function ( "throws" , will_throw , [], BIGINT ) try : res = duckdb . sql... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Casting – DuckDB 12225
- 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
...Casting Rules Not all casts are possible. For example, it is not possible to convert an INTEGER to a DATE . Casts may also throw errors when the cast could not be successfully performed. For example, trying to cast the string 'hello' to an INTEGER wil...l result in an error being thrown. SELECT CAST ( 'hello' AS INTEGER ); Conversion Error: Could not convert string 'hello' to INT32 The exact behavior of th...er type, the string will be attempted to be converted. TRY_CAST TRY_CAST can be used when the preferred behavior is not to throw an error, but instead to return a NULL value. TRY_CAST will never throw an error, and will instead return NULL if a cast i... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- C++ API – DuckDB 8708
- 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
...ig , you can set various database parameters, for example the read/write mode or memory limits. The DuckDB constructor may throw exceptions, for example if the database file is not usable. With the DuckDB instance, you can create one or many Connectio...aterializedQueryResult instance contains firstly two fields that indicate whether the query was successful. Query will not throw exceptions under normal circumstances. Instead, invalid queries or other issues will lead to the success Boolean field in... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- Reading Faulty CSV Files – DuckDB 8486
- 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
...erforming a CSV read, if any structural errors are encountered, the scanner will immediately stop the scanning process and throw the error to the user. These errors are designed to provide as much information as possible to allow users to evaluate the...loading the file would fail, as the string three cannot be converted to an INTEGER . For example, the following query will throw a casting error. FROM read_csv ( 'faulty.csv' , columns = { 'name' : 'VARCHAR' , 'age' : 'INTEGER' }); However, with ignor...at the CSV Parser is affected by the projection pushdown optimization. Hence, if we were to select only the name column, both rows would be considered valid, as the casting error on the age would never occur. For example: SELECT name FROM read_csv ( '... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Using fsspec Filesystems – DuckDB 8264
- 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, you can register whichever filesystem you'd like to query: import duckdb from fsspec import filesystem # this line will throw an exception if the appropriate filesystem interface is not installed duckdb . register_filesystem ( filesystem ( 'gcs' ))... - https://man.mtool.work/duckdb/1.3/guides/python/filesystems.html
- TRY expression – DuckDB 8264
- 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 caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired by the TRY_CAST expression . Examples The following calls return errors when inv... - https://man.mtool.work/duckdb/1.3/sql/expressions/try.html
- Building Extensions – DuckDB 8042
- 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
...ueries through our test suite. Debug Flags CRASH_ON_ASSERT D_ASSERT(condition) is used all throughout the code, these will throw an InternalException in debug builds. With this flag enabled, when the assertion triggers it will instead directly cause a... - https://man.mtool.work/duckdb/1.3/dev/building/building_extensions.html
- Extension Distribution – DuckDB 8042
- 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
...a loadable extension. When trying to load an extension that was compiled for a different version or platform, DuckDB will throw an error and refuse to load the extension. Creating a Custom Repository You can create custom DuckDB extension repository.... - https://man.mtool.work/duckdb/1.3/extensions/extension_distribution.html
- Overview of DuckDB Internals – DuckDB 8042
- 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
...ueryNode TableRef ParsedExpression The parser is not aware of the catalog or any other aspect of the database. It will not throw errors if tables do not exist, and will not resolve any types of columns yet. It only transforms a query string into a set... - https://man.mtool.work/duckdb/1.3/internals/overview.html
- CREATE INDEX Statement – DuckDB 8042
- 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
...database system. Examples Remove the index title_idx : DROP INDEX title_idx ; Parameters Name Description IF EXISTS Do not throw an error if the index does not exist. name The name of an index to remove. Syntax Limitations The CREATE INDEX clause does... - https://man.mtool.work/duckdb/1.3/sql/statements/create_index.html
DuckDB 1.3 Documentation / man.mtool.work