Results of 1 - 10 of about 17 for allowing (0.001 sec.)
- Spark API 11759
- The DuckDB Spark API implements the PySpark API , allowing you to use the familiar Spark API to interact with DuckDB. All statements are translated to DuckDB's internal plans using our relational API and executed using DuckDB's query engine
... - https://man.mtool.work/duckdb/2.0/clients/python/spark_api.html
- CHECKPOINT Statement 11759
- The CHECKPOINT statement synchronizes data in the write-ahead log (WAL) to the database data file. Examples Synchronize data in the default database: CHECKPOINT; Synchronize data in the specified database: CHECKPOINT file_db; Synchronize da
...l ATTACH ':memory:' AS memory_compressed (COMPRESS); USE memory_compressed; Checkpointing triggers vacuuming deleted rows, allowing space to be reclaimed after deletes/truncation. Syntax Checkpoint operations happen automatically based on the WAL size (s... - https://man.mtool.work/duckdb/2.0/sql/statements/checkpoint.html
- GROUP BY Clause 11121
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...to GROUP BY all columns in the SELECT statement that are not wrapped in aggregate functions. This simplifies the syntax by allowing the columns list to be maintained in a single location, and prevents bugs by keeping the SELECT granularity aligned to the... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- Hugging Face Support 9828
- The httpfs extension introduces support for the hf:// protocol to access datasets hosted in Hugging Face repositories. See the announcement blog post for details. Usage Hugging Face repositories can be queried using the following URL patter
...repositories, dataset versions or revisions are different dataset updates. Each version is a snapshot at a specific time, allowing you to track changes and improvements. In git terms, it can be understood as a branch or specific commit. You can query di... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/hugging_face.html
- Secrets Manager 9173
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Partitioned Writes 9173
- Examples Write a table to a Hive partitioned dataset of Parquet files: COPY orders TO 'orders' (FORMAT parquet, PARTITION_BY (year, month)); Write a table to a Hive partitioned dataset of CSV files, allowing overwrites: COPY orders TO 'orde
... - https://man.mtool.work/duckdb/2.0/data/partitioning/partitioned_writes.html
- Indexing 9173
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...e an index scan for equality and IN(...) conditions. It also pushes dynamic filters, e.g., from hash joins, into the scan, allowing dynamic index scans on these filters. Indexes are only eligible for index scans if they index a single column without expr... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Union Type 9173
- 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
...avoid casts that could lead to loss of information. This prevents UNION s from being completely “transparent”, while still allowing UNION types to have a “supertype” relationship with their members. Thus UNION types can't be implicitly cast to any of the... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Deploy 8535
- 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
...db.org . If you are deploying duckdb-wasm you can consider mirroring relevant extensions at a different endpoint, possibly allowing for air-tight deployments on internal networks. SET custom_extension_repository = '⟨https://some.endpoint.org/path/to/repo... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Securing DuckDB 7897
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...ted data values (e.g., user-provided search terms or IDs). If users can supply the SQL query itself, this is equivalent to allowing them to run arbitrary code – see "Untrusted SQL Input" . Therefore, avoid concatenating strings for queries: import duckdb... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
DuckDB 2.0 Documentation / man.mtool.work