Search Result: regions - DuckDB 1.3 全文検索

Search Shortcut cmd + k | ctrl + k

Documentation DuckDB 1.3 ドキュメント全文検索

DuckDB 1.3 ドキュメント全文検索

Results of 1 - 4 of about 4 for regions (0.002 sec.)

FROM and JOIN Clauses – DuckDB 12445: 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 ... 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 ... 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_regio ... ; 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 ( ...; https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html

Legacy Authentication Scheme for S3 API – DuckDB 8284: 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 ... tication 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 se ... 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/1.3/core_extensions/httpfs/s3api_legacy_authentica...

Aggregate Functions – DuckDB 8173: 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 ... , containing the sum of amount for each group: SELECT region , sum ( amount ) FROM sales GROUP BY region ; Return only the regions that have a sum of amount higher than 100: SELECT region FROM sales GROUP BY region HAVING sum ( amount ) > 100 ; Return t ... 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 sa ...; https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html

R-Tree Indexes – DuckDB 8044: 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 ... 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/1.3/core_extensions/spatial/r-tree_indexes.html

PREV 1 NEXT

DuckDB 1.3 Documentation / man.mtool.work