Results of 1 - 10 of about 24 for occur (0.001 sec.)
- Crashes 14361
- 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
...of crashes: Termination signals: The process stops with a SIGSEGV (segmentation fault), SIGABRT , etc.: these should never occur. Please submit an issue . Internal errors: an operation may result in an Internal Error , e.g.: console INTERNAL Error: At...tforms or client languages. You can often isolate the issue to a smaller problem. Reproducing in Plain SQL Issues can also occur due to differences in client libraries. To understand whether this is the case, try reproducing the issue using plain SQL...client, it is likely related to the client library. Different Hardware Setup According to our experience, several crashes occur due to faulty hardware (overheating hard drives, overclocked CPUs, etc.). Therefore, it's worth trying another computer to... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- Troubleshooting 10525
- This page contains solutions to common problems reported by users. If you have platform-specific issues, make sure you also consult the troubleshooting guide for your platform such as the one for Linux builds . The Build Runs Out of Memory
...the build, which can cause out-of-memory issues on systems with limited resources. These issues have also been reported to occur on Alpine Linux, especially on machines with limited resources. Solution: Avoid using Ninja by setting the Makefile genera... - https://man.mtool.work/duckdb/2.0/dev/building/troubleshooting.html
- Set Operations 10525
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...tion), whereas UNION ALL BY NAME follows bag semantics. INTERSECT The INTERSECT clause can be used to select all rows that occur in the result of both queries. Vanilla INTERSECT (Set Semantics) Vanilla INTERSECT performs duplicate elimination, so only...TERSECT ALL SELECT unnest([5, 6, 6, 7, 7, 9]); x 5 6 6 7 EXCEPT The EXCEPT clause can be used to select all rows that only occur in the left query. Vanilla EXCEPT (Set Semantics) Vanilla EXCEPT follows set semantics, therefore, it performs duplicate e... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Internal Errors 9941
- Internal errors signal an assertion failure within DuckDB. They usually occur due to unexpected conditions or errors in the program's logic. For example, running issue 17002 on DuckDB 1.2.1 results in an internal error. INTERNAL Error: Atte
... - https://man.mtool.work/duckdb/2.0/dev/internal_errors.html
- Analyzing a Git Repository 9357
- You can use DuckDB to analyze Git logs using the output of the git log command . Exporting the Git Log We start by picking a character that doesn't occur in any part of the commit log (author names, messages, etc). Since version v1.2.0, Duc
...eing featured in the Emoji Movie (IMDb rating: 3.4), we can assume that the Fish Cake with Swirl emoji (?) is not a common occurrence in most Git logs. So, let's clone the duckdb/duckdb repository and export its log as follows: git log --date=iso-stri...stopwords WHERE word != ''; We use the NATURAL ANTI JOIN clause here, which allows us to elegantly filter out values that occur in the stopwords table. Finally, we select the top-20 most common words. SELECT word, count(*) AS count FROM words GROUP B... - https://man.mtool.work/duckdb/2.0/guides/snippets/analyze_git_repository.html
- Out of Memory Errors 9057
- DuckDB has a state of the art out-of-core query engine that can spill to disk for larger-than-memory processing. We continuously strive to improve DuckDB's scalability and prevent out of memory errors whenever possible. That said, you may s
...ave very little available memory compared to the dataset size. Types of “Out of Memory” Errors Out of memory errors mainly occur in two forms: OutOfMemoryException Most of the time DuckDB runs out of memory with an OutOfMemoryException followed by a m... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/oom_errors.html
- Reading Faulty CSV Files 8757
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...able: CREATE TABLE people (name VARCHAR, birth_date DATE); DuckDB detects the following error types: CAST : Casting errors occur when a column in the CSV file cannot be cast to the expected schema value. For example, the line Pedro,The 90s would cause...an error since the string The 90s cannot be cast to a date. MISSING COLUMNS : This error occurs if a line in the CSV file has fewer columns than expected. In our example, we expect two columns; therefore, a row with j...ust one value, e.g., Pedro , would cause this error. TOO MANY COLUMNS : This error occurs if a line in the CSV has more columns than expected. In our example, any line with more than two columns would cause this... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- Casting 8473
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- CREATE MACRO Statement 8473
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...in the database. The optional TEMPORARY keyword indicates that the macro is not to be persisted. An OR REPLACE clause may occur immediately after the CREATE keyword, which causes an existing macro with the same name (within the schema) to be overwrit...ten. Without OR REPLACE such an attempt will fail with a Macro Function already exists error. An IF NOT EXISTS clause may occur immediately before the identifier, and has the effect of only creating the macro if it does not already exist. Either the... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- ODBC API on Windows 8173
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...ll.exe . Windows administrator privileges are required. In case of a non-administrator, a User Account Control prompt will occur. odbc_install.exe adds a default DSN configuration into the ODBC registries with a default database :memory: . DSN Windows... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
DuckDB 2.0 Documentation / man.mtool.work