Results of 1 - 3 of about 3 for Reservoir (0.004 sec.)
- Samples 11924
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
...ows, but it is much less likely that you get no rows at all. To get exactly 10% of rows (up to rounding), you must use the reservoir sampling option. Select a sample of approximately 10% of the table using bernoulli sampling: SELECT * FROM tbl USING SAMPL...E 10 PERCENT (bernoulli); Select a sample of exactly 10% (up to rounding) of the table using reservoir sampling: SELECT * FROM tbl USING SAMPLE 10 PERCENT (reservoir); Select a sample of exactly 50 rows of the table using res...ervoir sampling with a fixed seed (100): SELECT * FROM tbl USING SAMPLE reservoir(50 ROWS) REPEATABLE (100); Select a sample of approximately 20% of the table using system sampling with a fixed seed (377)... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Aggregate Functions 8054
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
....5) approx_top_k(arg, k) Calculates a LIST of the k approximately most frequent values of arg using Filtered Space-Saving. reservoir_quantile(x, quantile, sample_size = 8192) Calculates the approximate quantile using reservoir sampling, the sample size is...optional and uses 8192 as a default size. reservoir_quantile(A, 0.5, 1024) Statistical Aggregates The table below shows the available statistical aggregate functions. They al... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Relational API 7906
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...draw. * seed : int, keyword-only, default: None The seed of the random draw. * method : str, keyword-only, default: None 'reservoir' , 'bernoulli' or 'system' ; 'reservoir' for n and 'bernoulli' for percent when omitted. Example import duckdb duckdb_conn... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work