Results of 1 - 9 of about 9 for factor (0.002 sec.)
- TPC-DS Extension 12888
- New In DuckDB 2.0, the dsdgen data generator was updated to match the TPC-DS version 4 tools. As a result, the generated data differs slightly from the data generated by DuckDB v1.x. See the related PR for more details. The tpcds extension
...pository. If you would like to install and load it manually, run: INSTALL AND LOAD tpcds; Usage To generate data for scale factor 1, use: CALL dsdgen(sf = 1); To run a query, e.g., query 8, use: PRAGMA tpcds(8); s_store_name sum(ss_net_profit) able -10...table with columns query_nr and query . Listing Expected Answers To produce the expected results for all queries on scale factors 1 and 10, run the following (note that in DuckDB 2.0.0 this fails with a Not implemented Error for scale factor 10): FROM...tpcds_answers(); This function returns a table with columns query_nr , scale_factor and answer . Generating the Schema It's possible to generate the schema of TPC-DS without any data by setting the scale fa... - https://man.mtool.work/duckdb/2.0/core_extensions/tpcds.html
- TPC-H Extension 11324
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...oad with DuckDB, use the standalone DuckDB TPC-H implementation project . Usage Generating Data To generate data for scale factor 1, use: CALL dbgen(sf = 1); Calling dbgen does not clean up existing TPC-H tables. To clean up existing tables, use DROP T...table with columns query_nr and query . Listing Expected Answers To produce the expected results for all queries on scale factors 0.01, 0.1 and 1, run: FROM tpch_answers(); This function returns a table with columns query_nr , scale_factor and answer.... Generating the Schema It's possible to generate the schema of TPC-H without any data by setting the scale factor to 0: CALL dbgen(sf = 0); Data Generator Parameters The data generator function dbgen has the following parameters: Name T... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Schema 9544
- 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
...estamps We illustrate the difference in aggregation speed using the creationDate column of the LDBC Comment table on scale factor 300 . This table has approx. 554 million unordered timestamp values. We run a simple aggregation query that returns the av...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-bit integer identifiers used as the id attribute of each row. We perform the following join operati...obenchmark: The Effect of Primary Keys We illustrate the effect of using primary keys with the LDBC Comment table at scale factor 300 . This table has approx. 554 million entries. In the first experiment, we create the schema with a primary key, then l... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Importing Duckbox Tables 8088
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...nly works if the table does not have long pipe │ characters. It also trims spaces from the table cell values. Make sure to factor in these assumptions when running the script. The script is compatible with both BSD sed (which is the default on macOS) a... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Lance Extension 7980
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...ataset.lance⟩', 'vec', [0.1, 0.2, 0.3, 0.4]::FLOAT[4], 'text', 'puppy', k = 10, prefilter = false, alpha = 0.5, oversample_factor = 4) ORDER BY _hybrid_score DESC; Limitations The lance extension is currently available for the following platforms : lin... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
- Benchmark Suite 7980
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...LL benchmark, there are three arguments: argument sf 10 argument errors 0.1 argument keys 4 For FILL these are * The scale factor (millions of rows per partition) * The error rate (fraction of the values that are missing) * The number of partitions. Be... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Create Synthetic Data 7855
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...-DS extensions. Each provides a data generator function that creates and populates the benchmark's tables at a given scale factor: INSTALL tpch; LOAD tpch; CALL dbgen(sf = 0.1); SELECT count(*) AS lineitem_rows FROM lineitem; Community Extensions The f... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Spatial Functions 7639
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...SELECT ST_Affine(ST_Point(1, 1), 1, 0, -- a, b 0, 1, -- d, e 2, 3); -- xoff, yoff ---- POINT (3 4) -- Scale a geometry by factor 2 in X and Y SELECT ST_Affine(ST_Point(1, 1), 2, 0, 0, -- a, b, c 0, 2, 0, -- d, e, f 0, 0, 1, -- g, h, i 0, 0, 0); -- xof...GON geometries by manually joining refs and nodes together in SQL, although with available memory usually being a limiting factor. The ST_ReadOSM() function also provides a "replacement scan" to enable reading from a file directly as if it were a table... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Configuration 7531
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...o the HTTP_PROXY environment variable. VARCHAR http_retries HTTP retries on I/O error UBIGINT 3 http_retry_backoff Backoff factor for exponentially increasing retry wait time FLOAT 4.0 http_retry_wait_ms Time between retries UBIGINT 100 http_timeout HT... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work