Results of 1 - 10 of about 13 for ⟩; (0.001 sec.)
- Profiling Queries 13073
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
...statements, and cannot be combined with ANALYZE or FORMAT . EXPLAIN ANALYZE To profile a query, run: EXPLAIN ANALYZE ⟨query⟩; The EXPLAIN ANALYZE statement runs the query, and shows the actual cardinalities for each operator, as well as the cumulat... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- Out-of-Memory Issues 12316
- Configuration Options If you are experiencing out-of-memory issues with DuckDB, try tweaking the following configuration options: Reduce the number of threads using the SET threads = ... command. Setting the memory limit lower than the defa
...ET preserve_insertion_order = false . In short, try the settings: SET threads = ⟨lower_than_the_number_of_available_threads⟩; SET memory_limit = ⟨lower_than_80%_of_system_memory⟩; SET preserve_insertion_order = false; Schema and Indexes If you run... - https://man.mtool.work/duckdb/2.0/guides/performance/oom.html
- Amazon RDS with IAM Authentication 9272
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
...it as a regular database: ATTACH '' AS rds_db (TYPE postgres, SECRET pg_rds_secret); SELECT * FROM rds_db.public.⟨tbl_name⟩; See Also Postgres extension secrets — AWS RDS IAM Authentication — the full reference, including verifying the setup with... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- Catalogs 9026
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...: SHOW ALL TABLES; You can query a table as follows: SELECT count(*) FROM my_s3_tables_catalog.⟨namespace_name⟩.⟨table_name⟩; AWS Glue (Amazon SageMaker Lakehouse) The iceberg extension supports reading Iceberg tables through the Amazon SageMaker L...l tables: SHOW ALL TABLES; You can query a table as follows: SELECT count(*) FROM glue_catalog.⟨namespace_name⟩.⟨table_name⟩; If you have an S3 Tables federated catalog, you can create a table using the standard CREATE TABLE syntax; CREATE TABLE gl... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- SQL Introduction 8516
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...a table any longer or want to recreate it differently you can remove it using the following command: DROP TABLE ⟨tablename⟩; Populating a Table with Rows The insert statement is used to populate a table with rows: INSERT INTO weather VALUES ('San...rancisco 41 55 0.0 1994-11-29 One should be cautious when issuing statements of the following form: DELETE FROM ⟨table_name⟩; Warning Without a qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not r... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- SELECT Statement 8269
- The SELECT statement retrieves rows from the database. Examples Select all columns from the table tbl : SELECT * FROM tbl; Select the rows from tbl : SELECT j FROM tbl WHERE i = 3; Perform an aggregate grouped by the column i : SELECT i, su
...BY ⟨groups⟩ HAVING ⟨group_filter⟩ WINDOW ⟨window_expression⟩ QUALIFY ⟨qualify_filter⟩ ORDER BY ⟨order_expression⟩ LIMIT ⟨n⟩; Optionally, the SELECT statement can be prefixed with a WITH clause . As the SELECT statement is so complex, we have split... - https://man.mtool.work/duckdb/2.0/sql/statements/select.html
- Enum Data Type 8005
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...ach table that uses them. It is possible to drop an enum from the catalog using the following command: DROP TYPE ⟨enum_name⟩; Currently, it is possible to drop enums that are used in tables without affecting the tables. Warning This behavior of the... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- Unity Catalog Extension 7759
- 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
...n scans on the server (Databricks only); see Server-Side Scan Planning . Reading Tables are named ⟨catalog⟩.⟨schema⟩.⟨table⟩ ; names without a schema resolve to DEFAULT_SCHEMA : SHOW ALL TABLES; SELECT * FROM my_catalog.my_schema.my_table LIMIT 10;...ting available tables: SHOW ALL TABLES; Interacting with tables using standard SQL: SELECT * FROM ⟨catalog⟩.⟨schema⟩.⟨table⟩; Time travel : SELECT * FROM ... AT (VERSION => ...); and SELECT * FROM ... AT (TIMESTAMP => ...); Inserts: INSERT INTO ...... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- PIVOT Statement 7759
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...PIVOT ⟨dataset⟩ ON ⟨columns⟩ USING ⟨values⟩ GROUP BY ⟨rows⟩ ORDER BY ⟨columns_with_order_directions⟩ LIMIT ⟨number_of_rows⟩; The ON , USING , and GROUP BY clauses are each optional, but they may not all be omitted. Example Data All examples use th... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- UNPIVOT Statement 7759
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...NTO NAME ⟨name_column_name⟩ VALUE ⟨value_column_name(s)⟩ ORDER BY ⟨column(s)_with_order_direction(s)⟩ LIMIT ⟨number_of_rows⟩; Example Data All examples use the dataset produced by the queries below: CREATE OR REPLACE TABLE monthly_sales (empid INTE... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
DuckDB 2.0 Documentation / man.mtool.work