Results of 1 - 10 of about 10 for break (0.002 sec.)
- Debugging 14230
- The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when that happens the test needs to be debugged. First, it is always recommended to run in debug mod
...his can be done by compiling the system using the command make debug . Second, it is recommended to only run the test that breaks. This can be done by passing the filename of the breaking test to the test suite as a command line parameter (e.g., build..., a debugger can be attached to the program and the test can be debugged. In the sqllogictests it is normally difficult to break on a specific query, however, we have expanded the test suite so that a function called query_break is called with the lin...e number line as parameter for every query that is run. This allows you to put a conditional breakpoint on a specific query. For example, if we want to break on line number 43 of the test file we can create the following... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/debugging.html
- Result Verification 8813
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...does not need to be provided. It is recommended that you only use a subset of the error message, so that the test does not break unnecessarily if the formatting of error messages is changed. statement error SELECT * FROM non_existent_table; ---- Table...e many output rows. However, it should be used sparingly, as hash values make the tests more difficult to debug if they do break. After it is ensured that the system outputs the correct result, hashes of the queries in a test file can be computed by a... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Vectors 8742
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...sult is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhausted break; } // get the number of rows from the data chunk idx_t row_count = duckdb_data_chunk_get_size(result); // get the first co...sult is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhausted break; } // get the number of rows from the data chunk idx_t row_count = duckdb_data_chunk_get_size(result); // get the first co...sult is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhausted break; } // get the number of rows from the data chunk idx_t row_count = duckdb_data_chunk_get_size(result); // get the struct c... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Join Operations 8491
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...ith the following command: SET disabled_optimizers = ''; Create Temporary Tables To force a particular join order, you can break up the query into multiple queries, with each creating a temporary table: CREATE OR REPLACE TEMPORARY TABLE t1 AS ...; --... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- Write User Defined Functions 8348
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...ckDBWritableVector vector = output.vector(col); switch (vector.getType()) { case BIGINT: vector.setLong(row, cursor.next); break; case VARCHAR: vector.setString(row, "row-" + cursor.next); break; default: vector.setNull(row); } } } return row; // retu... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- C++ API 8259
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...errorObject = result->GetErrorObject(); errorObject.ConvertErrorToJSON(); std::cout << errorObject.Message() << std::endl; break; } // More handling } } else { // Normal code } If successful, other fields are set: the type of statement that was just e... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- Crashes 8259
- 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
.... Therefore, it's worth trying another computer to run the same workload. Decomposing the Query It's a good idea to try to break down the query into multiple smaller queries with each using a separate DuckDB extension and SQL feature. For example, if... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/crashes.html
- Import Data 8187
- Overview DuckDB-Wasm has multiple ways to import data, depending on the format of the data. Importing happens in two steps. The data file is registered in a virtual file system using one of the register functions ( registerFileBuffer , regi
...se.body.getReader(); const streamInserts = []; while (true) { const { value, done } = await streamReader.read(); if (done) break; streamInserts.push(conn.insertArrowFromIPCStream(value, { name: 'streamed' })); } // Write the EOS marker streamInserts.p... - https://man.mtool.work/duckdb/2.0/clients/wasm/data_ingestion.html
- Query 8027
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...sult is exhausted while (true) { duckdb_data_chunk result = duckdb_fetch_chunk(res); if (!result) { // result is exhausted break; } // get the number of rows from the data chunk idx_t row_count = duckdb_data_chunk_get_size(result); // get the first co... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Node.js Client (Neo) 7937
- Installation To use the DuckDB Node.js client, visit the Node.js installation page . The latest stable version of the DuckDB Node.js (Neo) client is 2.0.0. An API for using DuckDB in Node.js . The primary package, @duckdb/node-api , is a hi
...[]; while (true) { const chunk = await result.fetchChunk(); // Last chunk will have zero rows. if (chunk.rowCount === 0) { break; } chunks.push(chunk); } For materialized (non-streaming) results, chunks can be read by index: const rowCount = result.ro... - https://man.mtool.work/duckdb/2.0/clients/node_neo/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work