Results of 1 - 10 of about 14 for Listing (0.001 sec.)
- TPC-DS Extension 13233
- New In DuckDB 2.0, the dsdgen data generator was updated to match the TPC-DS version 4 tools. As a result, the generated data differs slightly from the data generated by DuckDB v1.x. See the related PR for more details. The tpcds extension
...s_store_name sum(ss_net_profit) able -10354620.18 ation -10576395.52 bar -10625236.01 ese -10076698.16 ought -10994052.78 Listing Queries To list all 99 queries, run: FROM tpcds_queries(); This function returns a table with columns query_nr and query ....Listing Expected Answers To produce the expected results for all queries on scale factors 1 and 10, run the following (note that i... - https://man.mtool.work/duckdb/2.0/core_extensions/tpcds.html
- TPC-H Extension 12516
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...: PRAGMA tpch(4); o_orderpriority order_count 1-URGENT 10594 2-HIGH 10476 3-MEDIUM 10410 4-NOT SPECIFIED 10556 5-LOW 10487 Listing Queries To list all 22 queries, run: FROM tpch_queries(); This function returns a table with columns query_nr and query .... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Secrets Manager 8612
- 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
...used, which takes a path and a secret type as parameters: FROM which_secret('s3://⟨my-other-bucket⟩/file.parquet', 's3'); Listing Secrets Secrets can be listed using the built-in table-producing function, e.g., by using the duckdb_secrets() table funct... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- DuckLake 8612
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...d_files function cleans up old files in the DuckLake denoted by catalog . It returns a table with a single column ( path ) listing the files that were deleted (or, with dry_run , would be deleted). Parameter name Parameter type Named parameter Descripti... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Benchmark Suite 8612
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...n the following command in the DuckDB repository : BUILD_BENCHMARK=1 BUILD_EXTENSIONS='tpch' make Listing Benchmarks To list all available benchmarks, run: build/release/benchmark/benchmark_runner --list Running Benchmarks Runni... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Building Configuration 8612
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...by the core extension repository. Additional extensions can be built as part of DuckDB via the BUILD_EXTENSIONS flag, then listing the names of the extensions that are to be built. BUILD_EXTENSIONS='tpch;httpfs;fts;json;parquet' make More on this topic... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Extensions 8262
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
...uilt for osx_amd64 but community extensions are no longer built for it, and DuckDB 2.1 will drop support for the platform. Listing Extensions To get a list of extensions, use the duckdb_extensions function: SELECT extension_name, installed, description... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- Friendly SQL 8262
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...NEAREST joins for top-k similarity search, e.g., over embeddings Trailing Commas DuckDB allows trailing commas , both when listing entities (e.g., column and table names) and when constructing LIST items . For example, the following query works: SELECT... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Unity Catalog Extension 7912
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...other clients, e.g., Spark or the Unity Catalog CLI, are read and written the same way. Features This extension supports: Listing available tables: SHOW ALL TABLES; Interacting with tables using standard SQL: SELECT * FROM ⟨catalog⟩.⟨schema⟩.⟨table⟩; T... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- GROUPING SETS 7912
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...ROUPING() with no arguments defaults to using all columns in the GROUP BY clause, in GROUP BY order. This is equivalent to listing every grouping column explicitly. Syntax... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
DuckDB 2.0 Documentation / man.mtool.work