Results of 1 - 10 of about 17 for Expect (0.001 sec.)
- Quack Extension 11828
- The quack extension adds support for the Quack remote protocol. Usage New DuckDB 2.0.0 shipped a polished version of the Quack protocol that is faster and more stable. Expect further improvements in upcoming patch releases. Quack is transpa
... - https://man.mtool.work/duckdb/2.0/core_extensions/quack.html
- Versioning of Extensions 11828
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...4.5 ) Allow determining chronological order of releases (e.g., version v1.2.3 is older than v1.2.4 ) Give an indication of expected stability (e.g., v0.0.1 is likely not very stable, whereas v13.11.0 probably is stable) Just like DuckDB itself , DuckDB...with the short git hash of the extension. For example, an unstable extension may have a version such as 690bfc5 . What to expect from an extension that has a version number in the unstable format? The state of the source code of the extension can be f...le extension, but is not quite there yet. For example, a pre-release extension may have a version such as v0.1.0 . What to expect from an extension that has a version number in the pre-release format? The extension is compiled from the source code corr... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
- Python Function API 11449
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...and instead return NULL , by setting this parameter to 'return_null' . side_effects (optional): By default, functions are expected to produce the same result for the same input. If the result of a function is impacted by any type of randomness, side_e...,), (0,), (0,), (0,)] Which is obviously not the desired result, when we add side_effects=True , the result is as we would expect: con.remove_function("my_counter") count.counter = 0 con.create_function("my_counter", count, side_effects=True) res = con...] Python Function Types Currently, two function types are supported, native (default) and arrow . Arrow If the function is expected to receive arrow arrays, set the type parameter to 'arrow' . This will let the system know to provide each argument as a... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- MERGE INTO Statement 10707
- The MERGE INTO statement is an alternative to INSERT INTO ... ON CONFLICT that doesn't need a primary key since it allows for a custom match condition. This is a very useful alternative for upserting use cases ( INSERT + UPDATE ) when the d
...cases, you may want to perform a different action specifically if the source doesn't meet a condition. For example, if we expect that data that is not present on the source shouldn't be present in the target: CREATE TABLE target AS SELECT unnest([1,2]...E 1 DELETE 2 There is also the possibility of specifying WHEN NOT MATCHED BY TARGET . However, the behavior is, as you may expect, the same as WHEN NOT MATCHED since by default when specifying conditions, we look at the target. Multiple Matching Source... - https://man.mtool.work/duckdb/2.0/sql/statements/merge_into.html
- Profile and Monitor 9207
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...xecute("PRAGMA enable_profiling = 'no_output'", [])?; conn.execute("SELECT 42", [])?; let info = conn.get_profiling_info().expect("profiling should be enabled"); println!("profiled children: {}", info.children.len()); get_profiling_info() returns an Op... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Sharing Macros 9207
- DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we define a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (with
...; SELECT pretty_print_integer(25_500_000) AS x; ┌─────────┐ │ x │ │ varchar │ ├─────────┤ │ 25M │ └─────────┘ As one would expect, the macro gets persisted in the database. But this also means that we can host it on an HTTPS endpoint and share it with... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- PEG Parser 8466
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...e reusing the rest of the DuckDB grammar. This makes it possible to combine the syntax of multiple extensions, and you can expect extensions that expose entirely new SQL syntax. Performance The parser uses packrat parsing, which memoizes intermediate r... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Securing Quack with a Reverse Proxy 8086
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...ust went out as TLS to Caddy, got terminated, and was forwarded as plain HTTP to Quack on :9494 . Nginx + Let's Encrypt We expect this to be the most common choice. A minimal site for a Quack server listening on the loopback interface looks as follows:... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Create Synthetic Data 7707
- 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
...keep face age. │ Stay different gun according make large read… │ true │ │ 16510940941872865459 │ 2006-07-30 │ Ten quickly expect. │ Early race claim. Middle economy box nor. An… │ true │ │ 13285076694688170502 │ 2018-02-19 │ Spring writer onto. │ Lose... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- AsOf Join 7707
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...es AS value FROM holdings h ASOF LEFT JOIN prices p ON h.ticker = p.ticker AND h.when >= p.when ORDER BY ALL; As you might expect, this will produce NULL prices and values instead of dropping left side rows when there is no ticker or the time is before... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
DuckDB 2.0 Documentation / man.mtool.work