Results of 1 - 3 of about 3 for synthetic (0.001 sec.)
- Create Synthetic Data 11905
- 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
...rate_series The range functions turn a start, stop, and step into a table of rows, which is the usual starting point for a synthetic dataset: SELECT i FROM range(1, 4) t(i); ┌───────┐ │ i │ │ int64 │ ├───────┤ │ 1 │ │ 2 │ │ 3 │ └───────┘ range excludes th...::INTEGER AS score FROM range(3); UUIDs Several utility functions generate universally unique identifiers, which make good synthetic primary keys: uuid() and its alias uuidv4() generate random (version 4) UUIDs, uuidv7() generates time-ordered (version 7)... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Loops 8166
- 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..
...al using a COPY INTO statement or 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
- Guides 7794
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...rs How to visualize DuckDB databases with Tableau How to draw command-line plots with DuckDB and YouPlot Snippets Creating synthetic data Dutch railway datasets Sharing macros Analyzing a Git repository Importing duckbox tables Copying an in-memory databa... - https://man.mtool.work/duckdb/2.0/guides/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work