Results of 1 - 10 of about 29 for expected (0.005 sec.)
- Result Verification – DuckDB 14994
- 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
...f 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 values separated by tabs. For exa...ring (empty) , e.g.: query II SELECT NULL , '' ---- NULL ( empty ) Error Verification In order to signify that an error is expected, the statement error indicator can be used. The statement error also takes an optional expected result – which is interpre...ted as the expected error message . Similar to query , the expected error should be placed after the four dashes ( ---- ) following the query.... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- sqllogictest Introduction – DuckDB 10898
- 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
...st file paths are relative to that root directory. The test describes a series of SQL statements, together with either the expected result, a statement ok indicator, or a statement error indicator. An example of a test file is shown below: # name : test...42 , 84 ); query II SELECT * FROM a ; ---- 42 84 In this example, three statements are executed. The first statements are expected to succeed (prefixed by statement ok ). The third statement is expected to return a single row with two columns (indicated...by query II ). The values of the row are expected to be 42 and 84 (separated by a tab character). For more information on query result verification, see the result verifica... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Reading Faulty CSV Files – DuckDB 10752
- 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
...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 just one value, e.g., Pedro , would cause this error. TOO MA...NY 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 error, e.g., Pedro,01-01-1992,pdet . UNQUOTED VALUE... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Non-Deterministic Behavior – DuckDB 9642
- 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
...and hardware architectures, can also cause changes in ordering. This page documents the cases where non-determinism is an expected behavior . If you would like to make your queries determinisic, see the “Working Around Non-Determinism” section . Set Sem...( i ); SELECT s , stddev ( x ) AS standard_deviation , corr ( x , y ) AS correlation FROM tbl GROUP BY s ORDER BY s ; The expected standard deviations and correlations from this query are 0 for all values of s . However, when executed on multiple thread...stic cases determinism distinct multi also threads sort Operations DuckDB behavior semantics order threaded using ordering expected Working Around Determinism following Different 関連するページ Result Verification Executing SQL in Python Overview Export... - https://man.mtool.work/duckdb/1.3/operations_manual/non-deterministic_behavior.h...
- TPC-H Extension – DuckDB 9332
- 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
...To list all 22 queries, run: FROM tpch_queries (); This function returns a table with columns query_nr and query . Listing Expected Answers To produced the expected results for all queries on scale factors 0.01, 0.1, and 1, run: FROM tpch_answers (); Thi...ct Trademark Use Blog In this article Installing and Loading Usage Generating Data Running a Query Listing Queries Listing Expected Answers Generating the Schema Data Generator Parameters Pre-Generated Data Sets Resource Usage of the Data Generator Limit... - https://man.mtool.work/duckdb/1.3/core_extensions/tpch.html
- Versioning of Extensions – DuckDB 8859
- 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
...er. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of the APIs Allow efficient processing of bug reports (e.g., bug #1337 was introdu...4.5 ) Allow determining chronological order of releases (e.g., version v1.2.3 is older than v1.2.4 ) Give an indication of expected stability (e.g., v0.0.1 is likely not very stable, whereas v13.11.0 probably is stable) Just like DuckDB itself , DuckDB e...d. Let's look at an example: First, we install a nightly DuckDB build . Then, we can install and load the aws extension as expected: INSTALL aws ; LOAD aws ; Updating Extensions DuckDB has a dedicated statement that will automatically update all extensio... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- Samples – DuckDB 8223
- 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
...age. As a result, bernoulli sampling can return a different number of tuples even if the same percentage is specified. The expected number of rows is equal to the specified percentage of the table, but there will be some variance . Because bernoulli samp...sampling. System sampling is more efficient than bernoulli sampling, as no per-tuple selections have to be performed. The expected number of rows is still equal to the specified percentage of the table, but the variance is vectorSize times higher. As su... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Python Function API – DuckDB 7913
- 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
...r, and instead return NULL , by setting this parameter to 'return_null' side_effects (optional): By default, functions are expected to produce the same result for the same input. If the result of a function is impacted by any type of randomness, side_eff...] Python Function Types Currently, two function types are supported, native (default) and arrow . Arrow If the function is expected to receive arrow arrays, set the type parameter to 'arrow' . This will let the system know to provide arrow arrays of up t... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Types API – DuckDB 7603
- 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
...licit conversions from existing type objects to a DuckDBPyType instance. This means that wherever a DuckDBPyType object is expected, it is also possible to provide any of the options listed below. Python Built-Ins The table below shows the mapping of Pyt... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- Spatial Functions – DuckDB 7603
- 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
...reat circle) distance between two geometries. Only supports POINT geometries. Returns the distance in meters. The input is expected to be in WGS84 (EPSG:4326) coordinates, using a [latitude, longitude] axis order. ST_Distance_Spheroid Signature DOUBLE ST...assumed to be in the EPSG:4326 coordinate system (WGS84), with [latitude, longitude] axis order and the distance limit is expected to be in meters. This function uses the GeographicLib library to solve the inverse geodesic problem , calculating the dist...that far from all of these drivers have been tested properly. Some may require additional options to be passed to work as expected. If you run into any issues please first consult the consult the GDAL docs . Example SELECT * FROM ST_Drivers (); ST_Gener... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
DuckDB 1.3 Documentation / man.mtool.work