Results of 1 - 2 of about 2 for dsdgen (0.001 sec.)
- TPC-DS Extension 11228
- 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
...ld 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 -10354620.18 ation -105...nerating the Schema It's possible to generate the schema of TPC-DS without any data by setting the scale factor to 0: CALL dsdgen(sf = 0); Data Generator Parameters The data generator function dsdgen has the following parameters: Name Type Description... - https://man.mtool.work/duckdb/2.0/core_extensions/tpcds.html
- Loops 7485
- 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..
...nction. 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
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work