Results of 1 - 10 of about 50 for above (0.005 sec.)
- UNPIVOT Statement – DuckDB 15024
- 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
...cases, the number of columns to unpivot is not easy to predetermine ahead of time. In the case of this dataset, the query above would have to change each time a new month is added. The COLUMNS expression can be used to select all columns that are not...ic unpivoting that will work regardless of how many months are added. The query below returns identical results to the one above. UNPIVOT monthly_sales ON COLUMNS ( * EXCLUDE ( empid , dept )) INTO NAME month VALUE sales ; empid dept month sales 1 ele...ow for each quarter. Since there are fewer quarters than months, this does make the dataset longer, but not as long as the above. To accomplish this, multiple sets of columns are included in the ON clause. The q1 and q2 aliases are optional. The numbe... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- SQLite Extension – DuckDB 10422
- 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
...anslated into DATE . If the declared type contains the string TIME , then it is translated into TIMESTAMP . If none of the above apply, then it is translated into VARCHAR . As DuckDB enforces the corresponding columns to contain only correctly typed v...t load the string “hello” into a column of type BIGINT . As such, an error is thrown when reading from the “numbers” table above: Mismatch Type Error: Invalid type in column "i": column was declared as integer, found "hello" of type "text" instead. Th...varchar option: SET GLOBAL sqlite_all_varchar = true ; When set, this option overrides the type conversion rules described above, and instead always converts the SQLite columns into a VARCHAR column. Note that this setting must be set before sqlite_at... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html
- SQL Introduction – DuckDB 10422
- 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
...aces, tabs, and newlines) can be used freely in SQL commands. That means you can type the command aligned differently than above, or even all on one line. Two dash characters ( -- ) introduce comments. Whatever follows them is ignored up to the end of...ider explicitly listing the columns better style than relying on the order implicitly. Please enter all the commands shown above so you have some data to work with in the following sections. Alternatively, you can use the COPY statement. This is faste...isn't fully specified, and so you might get the San Francisco rows in either order. But you'd always get the results shown above if you do: SELECT * FROM weather ORDER BY city , temp_lo ; You can request that duplicate rows be removed from the result... - https://man.mtool.work/duckdb/1.3/sql/introduction.html
- S3 API Support – DuckDB 9700
- 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
...for HTTP HEAD ), configure the endpoint explicitly via ENDPOINT 's3. your_region .amazonaws.com' . Now, to query using the above secret, simply query any s3:// prefixed file: SELECT * FROM 's3:// your-bucket / your_file .parquet' ; credential_chain Pr...efault provider: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain ); Again, to query a file using the above secret, simply query any s3:// prefixed file. DuckDB also allows specifying a specific chain using the CHAIN keyword. This...access tokens. You can create HMAC keys by following the Google Cloud documentation for managing HMAC keys . Note that the above secret will automatically have the correct Google Cloud Storage endpoint configured. Also note that GCS Secrets can also u... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- Query – DuckDB 9354
- 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
...ng, bounds-checking and casting which makes them slower. duckdb_fetch_chunk Below is an end-to-end example that prints the above result to CSV format using the duckdb_fetch_chunk function. Note that the function is NOT generic: we do need to know exac...ckdb_value functions are deprecated and are scheduled for removal in a future release. Below is an example that prints the above result to CSV format using the duckdb_value_varchar function. Note that the function is generic: we do not need to know ab...out the types of the individual result columns. // print the above result to CSV format using `duckdb_value_varchar` idx_t row_count = duckdb_row_count ( & result ); idx_t column_count = du... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Legacy Authentication Scheme for S3 API – DuckDB 9354
- 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
...s extension allows for loading AWS credentials. Per-Request Configuration Aside from the global S3 configuration described above, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of credentials, re...s, etc. These are used by including them on the S3 URI as query parameters. All the individual configuration values listed above can be set as query parameters. For instance: SELECT * FROM 's3://bucket/file.parquet?s3_access_key_id=accessKey&s3_secret... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api_legacy_authentica...
- Swift Client – DuckDB 8993
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...w ExoplanetStore static func create () async throws -> ExoplanetStore { // Create our database and connection as described above let database = try Database ( store : . inMemory ) let connection = try database . connect () // Download the CSV from the...f exoplanets discovered by year func groupedByDiscoveryYear () async throws -> DataFrame { // Issue the query we described above let result = try connection . query ( """ SELECT disc_year, count(disc_year) AS Count FROM exoplanets GROUP BY disc_year O... - https://man.mtool.work/duckdb/1.3/clients/swift.html
- AWS Extension – DuckDB 8993
- 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
...for HTTP HEAD ), configure the endpoint explicitly via ENDPOINT 's3. your_region .amazonaws.com' . Now, to query using the above secret, simply query any s3:// prefixed file: SELECT * FROM 's3:// your-bucket / your_file .parquet' ; credential_chain Pr...efault provider: CREATE OR REPLACE SECRET secret ( TYPE s3 , PROVIDER credential_chain ); Again, to query a file using the above secret, simply query any s3:// prefixed file. DuckDB also allows specifying a specific chain using the CHAIN keyword. This... - https://man.mtool.work/duckdb/1.3/core_extensions/aws.html
- Node.js Client (Neo) – DuckDB 8286
- 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
...' ; Create with an in-memory database: const instance = await DuckDBInstance . create ( ' :memory: ' ); Equivalent to the above: const instance = await DuckDBInstance . create (); Read from and write to a database file, which is created if needed: co...different form, such as JS built-ins or values that can be losslessly serialized to JSON, use the JS or Json forms of the above result data methods. Custom converters can be supplied as well. See the implementations of JSDuckDBValueConverter and Json...mallard'], // [17, 'goose'], // ]); appender . appendDataChunk ( chunk ); appender . flushSync (); See "Specifying Values" above for how to supply values to the appender. Extract Statements const extractedStatements = await connection . extractStateme... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
- GROUPING SETS – DuckDB 8286
- 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
...CS Bachelor 2 Math Masters 1 CS NULL 2 Math NULL 2 CS NULL 5 NULL NULL 3 NULL Masters 1 NULL Bachelor 2 NULL PhD 1 In the above query, we group across four different sets: course, type , course , type and () (the empty group). The result contains NUL...L for a group which is not in the grouping set for the result, i.e., the above query is equivalent to the following statement of UNION ALL clauses: -- Group by course, type: SELECT course , type , coun... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/grouping_sets.html
DuckDB 1.3 Documentation / man.mtool.work