Results of 1 - 6 of about 6 for dbgen (0.001 sec.)
- TPC-H Extension 13197
- 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
...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 TABLE before running...dbgen : DROP TABLE IF EXISTS customer; DROP TABLE IF EXISTS lineitem; DROP TABLE IF EXISTS nation; DROP TABLE IF EXISTS orders;...enerating 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 Type Description c... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Loops 8536
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...r the read_csv_auto function. The TPC-H and TPC-DS extensions can also be used to generate synthetic data, using e.g. CALL dbgen(sf = 1) or CALL dsdgen(sf = 1) .... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- Summarize 8536
- The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query. The SUMMARIZE command launches a query that computes a number of aggregates over all columns ( min , max , approx_unique , avg , std , q25 ,
...of SUMMARIZE on the lineitem table of TPC-H SF1 table, generated using the tpch extension . INSTALL tpch; LOAD tpch; CALL dbgen(sf = 1); SUMMARIZE lineitem; column_name column_type min max approx_unique avg std q25 q50 q75 count null_percentage l_ord... - https://man.mtool.work/duckdb/2.0/guides/meta/summarize.html
- Result Verification 8298
- 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
...ath should be provided as relative to the root of the GitHub repository. query I PRAGMA tpch(1) ---- <FILE>:extension/tpch/dbgen/answers/sf1/q01.csv Row-Wise vs. Value-Wise Result Ordering The result values of a query can be either supplied in row-wis... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Create Synthetic Data 8170
- 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
...enerator 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 fakeit community extension provides ta... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Tuning Workloads 8042
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...er on on-disk tables compared to in-memory ones. Let's take Q1 of the TPC-H workload for example on the SF30 dataset: CALL dbgen(sf = 30); .timer on PRAGMA tpch(1); We run this script using three DuckDB prompts: Database setup DuckDB prompt Execution... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work