Results of 1 - 9 of about 9 for regions (0.002 sec.)
- FROM and JOIN Clauses 13121
- 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
...plicitly specified using an ON clause with the join (clearer) or implied by the WHERE clause (old-fashioned). We use the l_regions and the l_nations tables from the TPC-H schema: CREATE TABLE l_regions ( r_regionkey INTEGER NOT NULL PRIMARY KEY, r_name...EY, n_name CHAR(25) NOT NULL, n_regionkey INTEGER NOT NULL, n_comment VARCHAR(152), FOREIGN KEY (n_regionkey) REFERENCES l_regions(r_regionkey) ); Return the regions for the nations: SELECT n.*, r.* FROM l_nations n JOIN l_regions r ON (n_regionkey = r_...; If the column names are the same and are required to be equal, then the simpler USING syntax can be used: CREATE TABLE l_regions (regionkey INTEGER NOT NULL PRIMARY KEY, name CHAR(25) NOT NULL, comment VARCHAR(152)); CREATE TABLE l_nations (nationkey... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- Catalogs 11198
- 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
.... This is incorrect for any region whose endpoint does not use the plain amazonaws.com suffix — most notably the AWS China regions ( cn-north-1 , cn-northwest-1 ), which use amazonaws.com.cn . For such regions, attach the catalog by passing an explicit...es , ENDPOINT_TYPE glue always builds an endpoint of the form glue.⟨region⟩.amazonaws.com/iceberg , which is incorrect for regions that do not use the plain amazonaws.com suffix (most notably the AWS China regions cn-north-1 and cn-northwest-1 , which u...se amazonaws.com.cn ). For such regions, attach with an explicit URI (with the correct host) together with AUTHORIZATION_TYPE 'sigv4' instead of using ENDPOINT_TY... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Tigris Import 8735
- Prerequisites For Tigris , the S3-compatible API allows you to use DuckDB's S3 support to read and write from Tigris buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to be r
...xxxxxxxxxxx⟩', REGION 'auto', ENDPOINT 'fly.storage.tigris.dev' ); A single endpoint ( fly.storage.tigris.dev ) serves all regions; requests are routed to the Tigris region nearest the caller. REGION is required for request signing but is not used for r... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/tigris_import.htm...
- Troubleshooting of Extensions 8214
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...451) The default extension repository is distributed through a content delivery network that restricts access from certain regions for legal reasons, so the same INSTALL command can succeed from one network and fail from another. To work around this, yo... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- Deploying Quack 8214
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...w). The stack defaults to a t3.micro instance; other sizes are selectable on the Parameters page when launching. Supported regions: us-east-1 , us-east-2 , us-west-1 , us-west-2 , eu-west-1 , eu-central-1 , ap-northeast-1 , ap-southeast-1 . Connecting f... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Quack on WebAssembly 8214
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...able at https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml , and is backed by images for (at the moment) eight regions: us-east-1 us-east-2 us-west-1 us-west-2 eu-central-1 eu-west-1 ap-northeast-1 ap-southeast-1 Only inputs are the type of... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Legacy Authentication Scheme for S3 API 8034
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...enticate of S3 endpoints is to use secrets . Legacy Authentication Scheme To be able to read or write from S3, the correct region should be set: SET s3_region = 'us-east-1'; Optionally, the endpoint can be configured in case a non-AWS object storage ser...ve, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of credentials, regions, etc. These are used by including them on the S3 URI as query parameters. All the individual configuration values listed a...t via environment variables: DuckDB setting Environment variable Note s3_region AWS_REGION Takes priority over AWS_DEFAULT_REGION s3_region AWS_DEFAULT_REGION s3_access_key_id AWS_ACCESS_KEY_ID s3_secret_access_key AWS_SECRET_ACCESS_KEY s3_session_token... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- R-Tree Indexes 7513
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...query execution, but it will also require more memory to store the tree itself and be more punishing when querying larger regions as more internal nodes will have to be traversed. Options The following options can be passed to the WITH clause when crea... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Aggregate Functions 7513
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...urn only the regions that have a sum of amount higher than 100: SELECT region FROM sales GROUP BY region HAVING sum(amount) > 100; Return the n...rth using the FILTER clause : SELECT sum(amount), sum(amount) FILTER (region != 'north') FROM sales; Returns a list of all regions in order of the amount column: SELECT list(region ORDER BY amount DESC) FROM sales; Returns the amount of the first sale u... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work