Results of 1 - 7 of about 7 for caused (0.001 sec.)
- Crashes 13159
- DuckDB is thoroughly tested via an extensive test suite. However, bugs can still occur and these can sometimes lead to crashes. This page contains practical information on how to troubleshoot DuckDB crashes. Types of Crashes There are a few
...B has a large community and there may be some suggestions for a workaround. Disabling the Query Optimizer Some crashes are caused by DuckDB's query optimizer component. To identify whether the optimizer is causing the crash, try to turn it off and re-r...un the query: PRAGMA disable_optimizer; If the query finishes successfully, then the crash was caused by one or more optimizer rules. To pinpoint the specific rules that caused the crash, you can try to selectively disable o...es . This way, your query can still benefit from the rest of the optimizer rules. Try to Isolate the Issue Some issues are caused by the interplay of different components and extensions, or are specific to certain platforms or client languages. You can... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- Troubleshoot 9833
- Overview This page collects common issues encountered when using the DuckDB JDBC driver, together with their workarounds. If you run into a problem that is not covered here, search the driver's issue tracker on GitHub. Driver Class Not Foun
...ecutable, opening the first connection may fail with: Exception in thread "main" java.lang.ExceptionInInitializerError ... Caused by: java.lang.NoSuchMethodError: ⟨class and method⟩ at com.oracle.svm.core.jni.functions.JNIFunctions$Support.getMethodID(...st connection may fail with: java.lang.UnsatisfiedLinkError: Can't load library: duckdb_java | java.library.path = [.] ... Caused by: java.io.FileNotFoundException: DuckDB JNI library not found, path: '⟨path⟩/libduckdb_java.⟨suffix⟩' The shared library... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- TRY Expression 9106
- The TRY expression ensures that errors 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 . Exa
... - https://man.mtool.work/duckdb/2.0/sql/expressions/try.html
- Troubleshooting 7924
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...first): File "<stdin>", line 1 in <module> Process finished with exit code -1073741819 (0xC0000005) The problem is likely caused by using an outdated Microsoft Visual C++ (MSVC) Redistributable package. The solution is to install the latest MSVC Redis... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Environment 7924
- The environment where DuckDB is run has an obvious impact on performance. This page focuses on the effects of the hardware configuration and the operating system used. Hardware Configuration CPU DuckDB's officially supported architectures a
...d-write workloads on network-attached storage can result in slow and unpredictable performance, as well as spurious errors caused by the underlying file system. Instead of using DuckDB's native database format in this setting, consider using the DuckLa... - https://man.mtool.work/duckdb/2.0/guides/performance/environment.html
- Schema 7924
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...value yields smaller storage sizes and faster processing. Microbenchmark: Joining on Strings We illustrate the difference caused by joining on different types by computing a self-join on the LDBC Comment table at scale factor 100 . The table has 64-bi... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- AsOf Join 7688
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...NG (ticker, "when"); This ensures that you get the complete information from both tables, avoiding any potential confusion caused by the default behavior of the USING keyword. See Also For implementation details, see the blog post “DuckDB's AsOf joins:... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work