Results of 1 - 9 of about 9 for exactly (0.006 sec.)
- Samples – DuckDB 14038
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ntation / SQL Copy Markdown Samples 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 t...s less than the specified percentage of the number of rows, 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 tabl...e using bernoulli sampling: SELECT * FROM tbl USING SAMPLE 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 ); Selec... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Vectors – DuckDB 8646
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s must be checked using the validity mask again. Arrays Arrays are nested types that contain a single child type, repeated exactly array_size times per row. Think of them like a fixed-size array in C. Arrays work exactly the same as lists, except the le... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Prepared Statements – DuckDB 8430
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
..._prepare_error . It is not required that the duckdb_bind family of functions matches the prepared statement parameter type exactly. The values will be auto-cast to the required value as required. For example, calling duckdb_bind_int8 on a parameter type... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- sqllogictest Introduction – DuckDB 8430
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...except those involving larger data sets (more than ~10-100 rows). Editors & Syntax Highlighting The sqllogictests are not exactly an industry standard, but several other systems have adopted them as well. Parsing sqllogictests is intentionally simple.... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Pattern Matching – DuckDB 8430
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...a member of the regular set described by the regular expression. As with LIKE , pattern characters match string characters exactly unless they are special characters in the regular expression language — but regular expressions use different special char... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Query – DuckDB 8214
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...bove result to CSV format using the duckdb_fetch_chunk function. Note that the function is NOT generic: we do need to know exactly what the types of the result columns are. duckdb_database db ; duckdb_connection con ; duckdb_open ( nullptr , & db ); duc... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Reading Faulty CSV Files – DuckDB 8214
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ines Being able to read faulty CSV files is important, but for many data cleaning operations, it is also necessary to know exactly which lines are corrupted and what errors the parser discovered on them. For scenarios like these, it is possible to use D... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Loading JSON – DuckDB 8214
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ON file that contains an array , e.g.: [ { "duck" : 42 , "goose" : 4.2 }, { "duck" : 43 , "goose" : 4.3 } ] Can be queried exactly the same as a JSON file that contains unstructured JSON, e.g.: { "duck" : 42 , "goose" : 4.2 } { "duck" : 43 , "goose" : 4... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Numeric Types – DuckDB 8214
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s, conversion from literals or casts from other datatypes to floating-point types stores inputs that cannot be represented exactly as approximations. However, it can be harder to predict what inputs are affected by this. For example, it is not surprisin... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work