Results of 1 - 10 of about 18 for occurs (0.001 sec.)
- HAVING Clause 14876
- The HAVING clause can be used after the GROUP BY clause to provide filter criteria after the grouping has been completed. In terms of syntax the HAVING clause is identical to the WHERE clause, but while the WHERE clause occurs before the gr
...ouping, the HAVING clause occurs after the grouping. Examples Count the number of entries in the addresses table that belong to each different city , filte... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/having.html
- Known Issues 10363
- Incorrect Memory Values on Old Linux Distributions and WSL 2 On Windows Subsystem for Linux 2 (WSL2), when querying the max_memory or memory_limit from the duckdb_settings , the values may be inaccurate on certain Ubuntu versions (e.g., 20.
...04 and 24.04). The issue also occurs on older distributions such as Red Hat Enterprise Linux 8 (RHEL 8): Example: FROM duckdb_settings() WHERE name LIKE '%mem%... - https://man.mtool.work/duckdb/2.0/clients/cli/known_issues.html
- Reading Faulty CSV Files 9248
- 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
...he 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 ju...st 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
- Order Preservation 8956
- For many operations, DuckDB preserves the order of rows, similarly to data frame libraries such as Pandas. Example Take the following table for example: CREATE TABLE tbl AS SELECT * FROM (VALUES (1, 'a'), (2, 'b'), (3, 'c')) t(x, y); SELECT
...y that returns the rows where x is an odd number: SELECT * FROM tbl WHERE x % 2 == 1; x y 1 a 3 c Because the row (1, 'a') occurs before (3, 'c') in the original table, it is guaranteed to come before that row in this table too. Clauses The following c... - https://man.mtool.work/duckdb/2.0/sql/dialect/order_preservation.html
- Building Extensions 8682
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...situations where this memory is still being used, despite not being pinned. DEBUG_STACKTRACE When a crash or assertion hit occurs in a test, print a stack trace. This is useful when debugging a crash that is hard to pinpoint with a debugger attached. U... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- Pivot Internals 8682
- PIVOT Pivoting is implemented as a combination of SQL query re-writing and a dedicated PhysicalPivot operator for higher performance. Each PIVOT is implemented as set of aggregations into lists and then the dedicated PhysicalPivot operator
...s. Additional pre-processing steps are required if the columns to be created when pivoting are detected dynamically (which occurs when the IN clause is not in use). DuckDB, like most SQL engines, requires that all column names and types be known at the... - https://man.mtool.work/duckdb/2.0/internals/pivot.html
- Troubleshoot 8390
- 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
...d This error occurs when the DuckDB JDBC driver is not on the application's classpath, typically because the build tool has not resolved the d... - https://man.mtool.work/duckdb/2.0/clients/java/troubleshoot.html
- Indexes 8390
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...make use of DuckDB's Appender (if available in the client). Over-Eager Constraint Checking in Foreign Keys This limitation occurs if you meet the following conditions: A table has a FOREIGN KEY constraint. There is an UPDATE on a composite payload colu... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- PostgreSQL Extension and the Secret Manager 8115
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...et_one); Warning Avoid including credentials, such as a password, directly in the connection string. If a connection error occurs, the full connection string, including your credentials, may appear in the resulting error message. For better security, s... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- FILTER Clause 8115
- The FILTER clause may optionally follow an aggregate function in a SELECT statement. This will filter the rows of data that are fed into the aggregate function in the same way that a WHERE clause filters rows, but localized to the specific
...er out NULL values, so using a FILTER clause will return valid results when at times the CASE WHEN approach will not. This occurs with the functions first and last , which are desirable in a non-aggregating pivot operation where the goal is to simply r... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/filter.html
DuckDB 2.0 Documentation / man.mtool.work