Results of 1 - 10 of about 76 for specific (0.003 sec.)
- Versioning of Extensions – DuckDB 12855
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...n 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 the APIs Allow efficien...-release extensions are the next step up from Unstable extensions. They are tagged with version in the SemVer format, more specifically, those in the v0.y.z format. In semantic versioning, versions starting with v0 have a special meaning: they indicate t...s compiled from the source code corresponding to the tag. Semantic Versioning semantics apply. See the Semantic Versioning specification for details. The extension follows a release cycle where new features are tested in nightly builds before being group... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- ODBC Configuration – DuckDB 9946
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ced in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific details, see the pages for Linux , macOS , and Windows . odbc.ini and .odbc.ini The odbc.ini file contains the DSNs for th...e drivers, which can have specific knobs. An example of odbc.ini with DuckDB: [DuckDB] Driver = DuckDB Driver Database = :memory: access_mode = read_only The...e ODBC installed drivers in the system. A driver section starts with the driver name between brackets, and then it follows specific configuration knobs belonging to that driver. Example of odbcinst.ini with the DuckDB: [ODBC] Trace = yes TraceFile = /tmp... - https://man.mtool.work/duckdb/1.3/clients/odbc/configuration.html
- Profiling – DuckDB 9766
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Documentation / Development Copy Markdown Profiling Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers....e Toggle additional optimizer and planner metrics standard standard , detailed custom_profiling_settings Enable or disable specific metrics All metrics except those activated by detailed profiling A JSON object that matches the following: {"METRIC_NAME":...sum of the corresponding metrics across all operators in the query. The OPERATOR nodes represent the sum of the operator's specific metric and those of all its children recursively. These cumulative metrics can be enabled independently, even if the under... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- R-Tree Indexes – DuckDB 9586
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...orking with geospatial datasets, it is very common that you want to filter rows based on their spatial relationship with a specific region of interest. Unfortunately, even though DuckDB's vectorized execution engine is pretty fast, this sort of operation...s possible to very quickly search a R-tree-indexed table for only those rows where the indexed geometry column intersect a specific region of interest, as you can skip searching entire sub-trees if the bounding rectangles of their parent nodes don't inte...rsect the query region at all. Once the leaf nodes are reached, only the specific rows whose geometries intersect the query region have to be fetched from disk, and the often much more expensive exact spa... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
- Iceberg REST Catalogs – DuckDB 9406
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ll other Iceberg REST Catalogs, you can follow the instructions below. Please see the Examples section for questions about specific catalogs. Most Iceberg REST Catalogs authenticate via OAuth2. You can use the existing DuckDB secret workflow to store log...the following ATTACH statement. ATTACH ' warehouse ' AS iceberg_catalog ( TYPE iceberg , SECRET iceberg_secret , -- pass a specific secret name to prevent ambiguity ENDPOINT https://rest_endpoint.com ); To see the available tables run SHOW ALL TABLES ; A...LL Grant Type when requesting an OAuth Token OAUTH2_SCOPE VARCHAR NULL Requested scope for the returned OAuth Access Token Specific Catalog Examples R2 Catalog To attach to an R2 cloudflare managed catalog follow the attach steps below. CREATE SECRET r2_... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
- Debugging – DuckDB 9406
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...r can be attached to the program and the test can be debugged. In the sqllogictests it is normally difficult to break on a specific query, however, we have expanded the test suite so that a function called query_break is called with the line number line...as parameter for every query that is run. This allows you to put a conditional breakpoint on a specific query. For example, if we want to break on line number 43 of the test file we can create the following break point: gdb: b...not be executed. Triggering Which Tests to Run When running the unittest program, by default all the fast tests are run. A specific test can be run by adding the name of the test as an argument. For the sqllogictests, this is the relative path to the tes... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/debugging.html
- Swift Client – DuckDB 9226
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...announcement post , which uses raw data from NASA's Exoplanet Archive loaded directly into DuckDB. Creating an Application-Specific Type We first create an application-specific type that we'll use to house our database and connection and through which we...'ll eventually define our app-specific queries. import DuckDB final class ExoplanetStore { let database : Database let connection : Connection init ( database :...B Home Code of Conduct Trademark Use Blog In this article Instantiating DuckDB Application Example Creating an Application-Specific Type Loading a CSV File Querying the Database Complete Project... - https://man.mtool.work/duckdb/1.3/clients/swift.html
- Hugging Face Support – DuckDB 9226
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...1/data.csv' ; Then, simply query the data table as follows: SELECT * FROM data ; Multiple Files To query all files under a specific directory, you can use a glob pattern . For example: SELECT count ( * ) AS count FROM 'hf://datasets/cais/mmlu/astronomy/*...In Hugging Face 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. Y...uet dataset using following examples formats count token DuckDB example command files access repositories path read format specific astronomy branch 関連するページ SQL on Apache Arrow Parquet Import HTTP Parquet Import Dutch Railway Datasets File Access... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/hugging_face.html
- Friendly SQL – DuckDB 8866
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nd to order on all columns (e.g., to ensure deterministic results). SELECT * EXCLUDE : the EXCLUDE option allows excluding specific columns from the * expression. SELECT * REPLACE : the REPLACE option allows replacing specific columns with different expr...in(arg, val, n) , max_by(arg, val, n) and min_by(arg, val, n) to efficiently return the "top" n rows in a group based on a specific column in either ascending or descending order. For example, let's use the following table: SELECT * FROM t1 ; ┌─────────┬...s query aliases schema using rows clauses group expression expressions files features queries more instead conflict syntax specific 関連するページ INSERT Statement SELECT Clause SELECT Statement Star Expression CREATE TABLE Statement ALTER TABLE Statemen... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Collations – DuckDB 8866
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...other_name hännes HÄNNES ICU Collations The collations we have seen so far are not region-dependent, and do not follow any specific regional rules. If you wish to follow the rules of a specific region or language, you will need to use one of the ICU coll...ations. For that, you need to load the ICU extension . Loading this extension will add a number of language and region specific collations to your database. These can be queried using PRAGMA collations command, or by querying the pragma_collations fu...ed rules default strings characters also collator specified column These comparison their however hElLÖ hännes need region specific 関連するページ CSV Import SET and RESET Statements Casting INSERT Statement Expression API Friendly SQL See this page as M... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
DuckDB 1.3 Documentation / man.mtool.work