Results of 1 - 10 of about 19 for Cross (0.003 sec.)
- Deploy 12823
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...ebAssembly with exception handling and threading, which enables parallel query execution; it requires the deployment to be cross-origin isolated (see Cross-Origin Isolation ) You can serve all three and let the library feature-detect the best one with...at LOAD time, not at INSTALL time. Please review the Extension Distribution page for general information about extensions. Cross-Origin Isolation The coi bundle runs multiple threads, which relies on SharedArrayBuffer . Browsers only expose SharedArra...yBuffer to pages that are cross-origin isolated . To serve the threaded bundle, the top-level document must be delivered with the following HTTP headers:... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Instantiate 10672
- Overview DuckDB-Wasm can be instantiated in several ways, depending on how your application bundles and serves its assets. Each approach resolves the mainModule (the WebAssembly file) and the mainWorker (the worker script) for the browser's
...ing avoids emulating them through JavaScript coi — adds threading for parallel query execution; it requires the page to be cross-origin isolated and must be opted into explicitly (see Threading ) The examples below all call selectBundle so the browser...Load Extensions ). maximumThreads : the number of threads to use. This takes effect only with the threaded coi bundle on a cross-origin-isolated page (see Threading ). query : controls how query results are converted from Arrow into JavaScript values....queries poll for results. Threading By default DuckDB-Wasm runs on a single thread. The threaded coi bundle runs queries across multiple threads, but it has two requirements: the page must be cross-origin isolated , and you must add the coi bundle to... - https://man.mtool.work/duckdb/2.0/clients/wasm/instantiation.html
- Troubleshoot 10672
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
...but is still experimental. The threaded bundle relies on SharedArrayBuffer , which browsers only expose to pages that are cross-origin isolated . If the top-level document is not served with the Cross-Origin-Embedder-Policy and Cross-Origin-Opener-Po...licy headers, DuckDB-Wasm falls back to the single-threaded mvp or eh bundle. See Cross-Origin Isolation for the required headers, and Threading for how to select and configure the coi bundle. Further Reading D...xtensions are fetched, signed, and served, including the httpfs CORS behavior. Deploy — serving components and configuring cross-origin isolation for threading.... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Array Functions 10142
- All LIST functions work with the ARRAY data type . Additionally, several ARRAY -native functions are also supported. Array-Native Functions Function Description array_cosine_distance(array1, array2) Computes the cosine distance between two
...The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cross_product(array, array) Computes the cross product of two arrays of size 3. The array elements cannot be NULL . array_distan...value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) | | Result | 0.9925834 | array_cross_product(array, array) | Description | Computes the cross product of two arrays of size 3. The array elements cannot be NUL...L . | | Example | array_cross_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) | | Result | [-1... - https://man.mtool.work/duckdb/2.0/sql/functions/array.html
- Troubleshoot 9818
- Overview This page collects common issues encountered when using the DuckDB Rust client, together with their workarounds. If you run into a problem that is not covered here, search the client's issue tracker on GitHub. Linking against a Sys
...e it only when building an extension. See Write User Defined Functions for how loadable extensions are built and packaged. Cross-Compiling with bundled Cross-compiling with the bundled feature compiles DuckDB's C++ source for the target, so it require...s a working C++ cross-compiler for that target and is supported only on a best-effort basis. When cross-compilation is difficult to set up, link... - https://man.mtool.work/duckdb/2.0/clients/rust/troubleshoot.html
- Create Synthetic Data 9715
- 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
...Rows range functions hash functions, e.g., hash , md5 , sha256 the Faker Python package via the Python function API using cross products (Cartesian products) range and generate_series The range functions turn a start, stop, and step into a table of r...│ int32 │ ├─────────────┼─────────┤ │ placeholder │ 0 │ │ placeholder │ 0 │ │ placeholder │ 0 │ └─────────────┴─────────┘ Cross Products A cross product (Cartesian product) multiplies rows from two sources, so combining two range calls is a compact w...ay to produce a large number of rows: SELECT i, j FROM range(1, 3) s(i) CROSS JOIN range(1, 3) t(j); Generating Values Random Numbers random() returns a random DOUBLE in the range [0, 1) , which you c... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Troubleshoot 9391
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...er and toolchain. On Debian or Ubuntu, install them with: bash sudo apt-get update && sudo apt-get install build-essential Cross-compiling disables cgo. The Go compiler turns cgo off automatically when cross-compiling. Re-enable it and point at the ri...ght cross-compiler: bash CC=⟨c_cross_compiler⟩ CGO_ENABLED=1 go build Windows Setup On Windows you need a compatible version of gcc... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Unofficial and Unsupported Platforms 9066
- Warning The platforms listed on this page are not officially supported. The build instructions are provided on a best-effort basis. Community contributions are very welcome. DuckDB is built and distributed for several platforms with differe
...ncei_zihintpause_zvl256b' \ CXX='g++-14 -march=rv64gcv_zicsr_zifencei_zihintpause_zvl256b' \ BUILD_EXTENSIONS='fts' \ make Cross-Compilation For those who do not have RISC-V hardware, you can cross-compile DuckDB using the riscv-gnu-toolchain : GEN=ni...64-linux-gnu-g++ -march=rv64gcv_zicsr_zifencei_zihintpause_zvl256b' \ make For more reference information on DuckDB RISC-V cross-compiling, see the mocusez/duckdb-riscv-ci and DuckDB Pull Request #16549 . Known Issues Platform Reported Incorrectly As... - https://man.mtool.work/duckdb/2.0/dev/building/unofficial_and_unsupported_platfo...
- Relational API 8213
- 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
...n the relation. apply Compute the function of a single column or a list of columns by the optional groups on the relation. cross Create cross/cartesian product of two relational objects. distinct Retrieve distinct rows from this relation object, or th...ry │ max(price) │ │ varchar │ int32 │ ├──────────┼────────────┤ │ clothing │ 65 │ │ tools │ 89 │ └──────────┴────────────┘ cross cross(self, other_rel: DuckDBPyRelation) -> DuckDBPyRelation Create cross/cartesian product of two relational objects. Par...ameters other_rel : DuckDBPyRelation Another relation to perform a cross product with. Example import duckdb duckdb_conn = duckdb.connect() rel = duckdb_conn.sql(""" SELECT * FROM (VALUES (1, 'je... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Array Type 8093
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...e(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT)); INSERT INTO y VALUES (1, array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)); Compute cross product: SELECT array_cross_product(x.v, y.v) FROM x, y WHERE x.i = y.i; Compute cosine similarity: SELECT array_cosine_si... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
DuckDB 2.0 Documentation / man.mtool.work