Results of 1 - 10 of about 18 for partial (0.003 sec.)
- Python Function API 11993
- 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
...[0] finally: cur.close() con.create_function("lookup", lookup) print(con.sql("SELECT lookup(1)").fetchall()) [(42,)] Using Partial Functions DuckDB UDFs can also be created with Python partial functions . The arguments the partial function fixes are not...parameters of the UDF: from functools import partial import duckdb def add(x: int, y: int) -> int: return x + y with duckdb.connect() as con: con.create_function("add_ten", pa... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- HTTP(S) Support 11993
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...sion'; Partial Reading For CSV files, files will be downloaded entirely in most cases, due to the row-based nature of the format. For Par...quet files, DuckDB supports partial reading , i.e., it can use a combination of the Parquet metadata and HTTP range requests to only download the parts of the...equire reading the metadata: SELECT count(*) FROM 'https://domain.tld/file.parquet'; DuckDB's own database format supports partial reading just as well as Parquet. Because the format is block-based and stores per-column and per-row-group statistics, Duc... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- PostgreSQL Compatibility 11547
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...f Regular Expression Match Operators PostgreSQL supports the POSIX regular expression matching operators ~ (case-sensitive partial regex matching) and ~* (case-insensitive partial regex matching) as well as their negated variants, !~ and !~* , respectiv...ely. By default, DuckDB follows the same semantics: ~ maps to regexp_matches (case-sensitive partial matching), ~* performs case-insensitive partial matching, and !~ and !~* are their negated variants. The results therefore... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Pattern Matching 10432
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...greSQL, the ~ and !~ operators perform POSIX regular expression matching, not SIMILAR TO matching. DuckDB follows the same partial-matching semantics by default, see the PostgreSQL compatibility page . Globbing DuckDB supports file name expansion, also...sitive matching !~* NOT regexp_matches with case-insensitive matching New As of DuckDB 2.0, the ~ and !~ operators perform partial matching by default, and the ~* and !~* operators are supported. In earlier versions, ~ and !~ performed full matching. By...default, these operators perform partial matching, following PostgreSQL's semantics. This is controlled by the deprecated regex_match_operator_semantics setting. S... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Building DuckDB from Source 9763
- 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
...th x86_64 (amd64) and AArch64 (ARM64) builds are available for these platforms (except for macOS on x86_64, which only has partial support, see below), and almost all extensions are distributed for these platforms. Platform name Description Comment linu....g., to test an unmerged pull request . For build instructions on these platforms, see: Linux macOS Windows Platforms with Partial Support There are several partially supported platforms. For some platforms, DuckDB binaries and extensions (or a subset o... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- S3 API Support 8441
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...⟩.parquet'); Reading Reading files from S3 is now as simple as: SELECT * FROM 's3://⟨your-bucket⟩/⟨filename⟩.⟨extension⟩'; Partial Reading The httpfs extension supports partial reading from S3 buckets. Pinning Object Versions By default, a long-running... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Requirements 8441
- DuckDB is designed to be portable and has very few runtime dependencies. Still, there are a few requirements to be aware of before installing or running DuckDB. Supported Platforms DuckDB officially supports Linux, macOS and Windows on both
..., etc. Full linux_arm64 Linux AArch64 (ARM64) AWS Graviton, Snapdragon, etc. Full osx_amd64 macOS 12+ x86_64 (AMD64) Intel Partial osx_arm64 macOS 12+ AArch64 (ARM64) Apple Silicon M1, M2, etc. Full windows_amd64 Windows 10+ x86_64 (AMD64) Intel, AMD, e...ows_arm64 Windows 10+ AArch64 (ARM64) Copilot+ PC with Qualcomm CPU Full Warning macOS on Intel CPUs ( osx_amd64 ) is only partially supported. DuckDB binaries and core extensions are still distributed for this platform but, starting with DuckDB 2.0.0,... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/requiremen...
- Configuration 8218
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...eir names are explicitly allowed. BOOLEAN true regex_match_operator_semantics Configures whether regex match operators use partial or full string matching. VARCHAR partial s3_allow_recursive_globbing Whether globs on S3-like storage are optimized with r...This will become the default behavior. When disabled, an arbitrary row is returned instead. BOOLEAN true scheduler_process_partial Partially process tasks before rescheduling. Enabling this allows for more scheduler fairness between separate queries. BO... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- PEG Parser 7995
- 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 (
...and preserves several DuckDB 1.5 quirks: ~ and !~ perform full regular expression matches, whereas DuckDB 2.0 defaults to partial matches. The ! operator binds less tightly: 2 * 3! returns 720 ( (2 * 3)! ), whereas DuckDB 2.0 returns 12 . Rendered SQL... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- DuckDB Wasm Client 7772
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...ipped. This makes it practical to query large Parquet files hosted on a remote server directly from the browser. Note This partial-read behavior depends on which httpfs path serves the request. The JavaScript httpfs implementation fetches only the requi... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
DuckDB 2.0 Documentation / man.mtool.work