Results of 1 - 8 of about 8 for express (0.001 sec.)
- S3 Express One 13772
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...s is similar to regular S3 buckets with one exception: you must specify the endpoint according to the following pattern: s3express-⟨availability_zone⟩.⟨region⟩.amazonaws.com where the ⟨availability_zone⟩ (e.g., use-az5 ) can be obtained from the S3 Expr...cket's configuration page and the ⟨region⟩ is the AWS region (e.g., us-east-1 ). For example, to allow DuckDB to use an S3 Express One bucket, configure the Secrets manager as follows: CREATE SECRET ( TYPE s3, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨w...JalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', REGION '⟨us-east-1⟩', ENDPOINT 's3express-⟨use1-az5⟩.⟨us-east-1⟩.amazonaws.com' ); Instance Location For best performance, ensure the EC2 instance is in the same av... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Subqueries 8675
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...Scalar subqueries are subqueries that return a single value. They can be used anywhere where an expression can be used. If a scalar subquery returns more than a single value, an error is raised (unless scalar_subquery_error_on...S all_grades; all_grades [7, 9, 8] Subquery Comparisons: ALL , ANY and SOME In the section on scalar subqueries , a scalar expression was compared directly to a subquery using the equality comparison operator ( = ). Such direct comparisons only make sen...se with scalar subqueries. Scalar expressions can still be compared to single-column subqueries returning multiple rows by specifying a quantifier. Available quanti... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- Writing to Iceberg 8603
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...positional deletes, see Limitations for UPDATE and DELETE . MERGE INTO The MERGE INTO statement is the recommended way to express upserts against Iceberg tables, which do not have a primary key. You can apply a change set in a single statement, decidin...pserts.id = target.id) WHEN MATCHED THEN UPDATE WHEN NOT MATCHED THEN INSERT; You can also use WHEN MATCHED THEN DELETE to express a delete set in the same statement. As with UPDATE and DELETE , MERGE INTO uses merge-on-read semantics and writes positio... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Avro Extension 8314
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
...to issues with the Avro library dependency (sigh again). We plan to fix this eventually. As mentioned above, DuckDB cannot express recursive type definitions that Avro has, this is unlikely to ever change. There is no support to allow users to provide a... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- Guides 8314
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...HTTP(S) How to load a Parquet file directly from S3 How to export a Parquet file to S3 How to load a Parquet file from S3 Express One How to load a Parquet file directly from GCS How to load a Parquet file directly from Cloudflare R2 How to load a Parq... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- FROM and JOIN Clauses 8314
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...(regionkey)); Return the regions for the nations: SELECT n.*, r.* FROM l_nations n JOIN l_regions r USING (regionkey); The expressions do not have to be equalities – any predicate can be used: Return the pairs of jobs where one ran longer but cost less:...port Note that only rows where the same iata attribute was present in both tables were included in the result. We can also express this query using the vanilla JOIN clause with the USING keyword: SELECT * FROM city_airport JOIN airport_names USING (iata...ame size, the rows may have a natural correspondence based on their physical order. In scripting languages, this is easily expressed using a loop: for (i = 0; i < n; i++) { f(t1.a[i], t2.b[i]); } It is difficult to express this in standard SQL because r... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- UPDATE Statement 8314
- The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1,
...e_original.key = new.key ); Update Using Joins To select the rows to update, UPDATE statements can use the FROM clause and express joins via the WHERE clause. For example: CREATE TABLE city (name VARCHAR, revenue BIGINT, country_code VARCHAR); CREATE TA... - https://man.mtool.work/duckdb/2.0/sql/statements/update.html
- WITH Clause 7934
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
..._hierarchy WHERE source = 'Oasis'; path [Oasis, Rock, Music, Art] Graph Traversal The WITH RECURSIVE clause can be used to express graph traversal on arbitrary graphs. However, if the graph has cycles, the query must perform cycle detection to prevent i... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work