Results of 1 - 10 of about 22 for subset (0.001 sec.)
- Debugging 12306
- The purpose of the tests is to figure out when things break. Inevitably changes made to the system will cause one of the tests to fail, and when that happens the test needs to be debugged. First, it is always recommended to run in debug mod
...arameter (e.g., build/debug/test/unittest test/sql/projection/test_simple_projection.test ). For more options on running a subset of the tests see the Triggering which tests to run section. After that, a debugger can be attached to the program and the...running the tests with an asterisk. To run all tests, including the slow tests: build/debug/test/unittest "*" We can run a subset of the tests using the --start-offset and --end-offset parameters. To run the tests 200...250: build/debug/test/unittest -... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/debugging.html
- WHERE Clause 11178
- The WHERE clause specifies any filters to apply to the data. This allows you to select only a subset of the data in which you are interested. Logically the WHERE clause is applied immediately after the FROM clause. Examples Select all rows
... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/where.html
- Import Data 10790
- Overview The Go client offers two ways to load data into DuckDB in bulk: the high-performance Appender for inserting rows generated in Go, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. For in
..., &age); err != nil { log.Fatal(err) } log.Printf("User: name=%s, age=%d", name, age) } Targeting Other Schemas and Column Subsets The package provides more constructors for targeting other catalogs and schemas, selecting a subset of columns, or transf...types, and column names. duckdb.NewAppenderWithColumns(driverConn, catalog, schema, table, columnNames) can also append a subset of columns, leaving other columns at their default values or NULL . It is retained mostly for backward compatibility. Pref... - https://man.mtool.work/duckdb/2.0/clients/go/data_import.html
- Union Type 10790
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...t to a UNION containing the type. Any UNION can also be implicitly cast to another UNION if the source UNION members are a subset of the target's (if the cast is unambiguous). UNION uses the member types' VARCHAR cast functions when casting to VARCHAR...UNION(a INTEGER, b INTEGER)) . Casting between Unions UNION types can be cast between each other if the source type is a “subset” of the target type. In other words, all the tags in the source UNION must be present in the target UNION , and all the ty... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Load Extensions 10403
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...for DuckDB to add extension functionality on-the-fly, is enabled by default in DuckDB-Wasm. Available Extensions A growing subset of extensions is supported for DuckDB-Wasm, spanning core extensions , community extensions , and external extensions. Mos... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Samples 10033
- 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
...: SELECT * FROM tbl, tbl2 WHERE tbl.i = tbl2.i USING SAMPLE reservoir(20%); Syntax Samples allow you to randomly extract a subset of a dataset. Samples are useful for exploring a dataset faster, as often you might not be interested in the exact answers... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Building DuckDB from Source 8518
- When Should You Build DuckDB? DuckDB binaries are available for stable and preview builds on the installation page . In most cases, it's recommended to use these binaries. When you are running on an experimental platform (e.g., Raspberry Pi
...Partial Support There are several partially supported platforms. For some platforms, DuckDB binaries and extensions (or a subset of extensions ) are distributed. For others, building from source is possible. Platform name Description osx_amd64 macOS 1... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- Import Data 8131
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...ema: appender_to_db() takes a schema name, and appender_to_catalog_and_db() takes a catalog and a schema. To append only a subset of columns, use appender_with_columns() (and its schema and catalog variants). Warning DuckDB buffers appended rows and ch... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- Result Verification 8131
- 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
...text under statement error – the entire error message does not need to be provided. It is recommended that you only use a subset of the error message, so that the test does not break unnecessarily if the formatting of error messages is changed. statem... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Extension Distribution 8131
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...ial extensions are distributed for the following platforms. Some extensions are only available on a subset of these platforms; see the individual extension pages for details. Platform name Operating system Architecture CPU types... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
DuckDB 2.0 Documentation / man.mtool.work