Results of 1 - 10 of about 20 for exception (0.004 sec.)
- Python Function API – DuckDB 15719
- 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
...handled as NULL -in NULL -out. Users can specify a desired behavior 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. Use..., null_handling = "special" ) res = duckdb . sql ( "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...hrows" , will_throw , [], BIGINT ) try : res = duckdb . sql ( "SELECT throws()" ). fetchall () except duckdb . InvalidInputException as e : print ( e ) duckdb . create_function ( "doesnt_throw" , will_throw , [], BIGINT , exception_handling = "return_null... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Tuning Workloads – DuckDB 9023
- 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
...imitations at the moment: If multiple blocking operators appear in the same query, DuckDB may still throw an out-of-memory exception due to the complex interplay of these operators. Some aggregate functions , such as list() and string_agg() , do not suppo...s DuckDB cannot yet offload some complex intermediate aggregate states to disk, these functions can cause an out-of-memory exception when run on large data sets. The PIVOT operation internally uses the list() function , therefore it is subject to the same... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- Java JDBC Client – DuckDB 8581
- 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
...ocumentations. import java.sql.Connection ; import java.sql.DriverManager ; import java.sql.ResultSet ; import java.sql.SQLException ; import java.sql.Statement ; Connection conn = DriverManager . getConnection ( "jdbc:duckdb:" ); // create a table Statem...bleshooting Driver Class Not Found If the Java application is unable to find the DuckDB, it may throw the following error: Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:duckdb: at java.sql/java.sql.DriverManager.getCo...Manager.getConnection(DriverManager.java:252) ... And when trying to load the class manually, it may result in this error: Exception in thread "main" java.lang.ClassNotFoundException: org.duckdb.DuckDBDriver at java.base/jdk.internal.loader.BuiltinClassLo... - https://man.mtool.work/duckdb/1.3/clients/java.html
- Python Client API – DuckDB 8581
- 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
...PIs / Python Copy Markdown Python Client API class duckdb. BinaryValue ( object : Any ) ¶ Bases: Value class duckdb. BinderException ¶ Bases: ProgrammingError class duckdb. BitValue ( object : Any ) ¶ Bases: Value class duckdb. BlobValue ( object : Any )...ondition : duckdb.duckdb.Expression , value : duckdb.duckdb.Expression ) → duckdb.duckdb.Expression ¶ class duckdb. CatalogException ¶ Bases: ProgrammingError duckdb. CoalesceOperator ( * args ) → duckdb.duckdb.Expression ¶ duckdb. ColumnExpression ( * ar...gs ) → duckdb.duckdb.Expression ¶ Create a column reference from the provided column name class duckdb. ConnectionException ¶ Bases: OperationalError duckdb. ConstantExpression ( value : object ) → duckdb.duckdb.Expression ¶ Create a constant exp... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Pragmas – DuckDB 8360
- 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
...as_json = true ; Then, running a query that results in an error produces a JSON output: SELECT * FROM nonexistent_tbl ; { "exception_type" : "Catalog" , "exception_message" : "Table with name nonexistent_tbl does not exist! \n Did you mean \" temp.informa... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- JSON Type – DuckDB 8360
- 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
...types as shown in the example, but also for non-nested types: SELECT '2023-05-12' :: DATE :: JSON ; "2023-05-12" The only exception to this behavior is the cast from VARCHAR to JSON , which does not alter the data, but instead parses and validates the co... - https://man.mtool.work/duckdb/1.3/data/json/json_type.html
- Using fsspec Filesystems – DuckDB 8360
- 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 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' )) duckdb . sql... - https://man.mtool.work/duckdb/1.3/guides/python/filesystems.html
- Known Python Issues – DuckDB 8122
- 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
...sql ( "..." ) ImportError: DLL load failed while importing duckdb: The specified module could not be found. Windows fatal exception: access violation Current thread 0x0000311c (most recent call first): File "<stdin>", line 1 in <module> Process finished... - https://man.mtool.work/duckdb/1.3/clients/python/known_issues.html
- Deploying DuckDB-Wasm – DuckDB 8122
- 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
...re 3 variants for 3 different platforms : MVP targets WebAssembly 1.0 spec EH targets WebAssembly 1.0 spec WITH Wasm-level exceptions handling added, that improves performances THREADS targets WebAssembly spec WITH exception and threading constructs You c... - https://man.mtool.work/duckdb/1.3/clients/wasm/deploying_duckdb_wasm.html
- S3 Express One – DuckDB 8122
- 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
...sion . Credentials and Configuration The configuration of S3 Express One buckets is similar to regular S3 buckets with one exception: we have to specify the endpoint according to the following pattern: s3express - availability_zone . region .amazonaws.com... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_express_one.ht...
DuckDB 1.3 Documentation / man.mtool.work