Results of 1 - 10 of about 92 for provided (0.002 sec.)
- Iceberg Options 12629
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...n Iceberg Catalog (not just a single table) known to the system, you'll need to use the ATTACH statement. The options provided to the ATTACH are divided into categories: Parameter Type Default Description URI VARCHAR NULL URL of the REST Catalog end...using the S3_TABLES ENDPOINT_TYPE are: Parameter Value AUTHORIZATION_TYPE SIGV4 SIGV4_REGION The REGION section of the ARN provided as the ATTACH path. URI s3tables.⟨region⟩.amazonaws.com/iceberg REMOVE_FILES_ON_DELETE false (unless explicitly set) STAGE...ZATION_TYPE parameter. These are the supported options: OAUTH2 Authorization Options The additional parameters that can be provided when the AUTHORIZATION_TYPE is set to OAUTH2 are the following. Parameter Type Default Description SECRET VARCHAR NULL The... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Map Functions 12205
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
...y provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map...) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Retur...ns the value for a given key or NULL if the key is not contained in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_from_entries(STRUCT(k, v)[])... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Window Functions 11196
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...t row) / total partition rows. If an ORDER BY clause is specified, the distribution is computed within the frame using the provided ordering instead of the frame ordering. | | Return type | DOUBLE | | Example | cume_dist() | dense_rank() | Description |...set) of the window frame. If an ORDER BY clause is specified, the first row number is computed within the frame using the provided ordering instead of the frame ordering. | | Return type | Same type as expr | | Example | first_value(column) | lag(expr[,...o 1 and default to NULL . If an ORDER BY clause is specified, the lagged row number is computed within the frame using the provided ordering instead of the frame ordering. | | Return type | Same type as expr | | Example | lag(column, 3, 0) | last_value(e... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- Timestamp with Time Zone Functions 9339
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...mp with Time Zone Operators The table below shows the available mathematical operators for TIMESTAMP WITH TIME ZONE values provided by the ICU extension. Operator Description Example Result + addition of an INTERVAL TIMESTAMPTZ '1992-03-22 01:02:03' + IN..., but does not match some more recent calendar RFCs . ICU Timestamp with Time Zone Functions The table below shows the ICU provided scalar functions for TIMESTAMP WITH TIME ZONE values. Name Description age(timestamptz, timestamptz) Subtract arguments, r...a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 in the provided timezone when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 in the provided timezone . The... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Result Verification 9047
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...he test passes if the error message contains the text under statement error – the entire error message does not need to be provided. It is recommended that you only use a subset of the error message, so that the test does not break unnecessarily if the f...rom files using the <FILE> command. The expected result is read from the given file. As convention the file path should be provided as relative to the root of the GitHub repository. query I PRAGMA tpch(1) ---- <FILE>:extension/tpch/dbgen/answers/sf1/q01....e result. This is useful for comparing queries that are logically equivalent, but formulated differently. Query labels are provided after the connection label or sorting specifier. Queries that have a query label do not need to have a result provided. In... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- MySQL Import 8769
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...by ATTACH is a PostgreSQL-style connection string ( not a MySQL connection string!). It is a list of connection arguments provided in {key}={value} format. Below is a list of valid arguments. Any options not provided are replaced by their default values... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- Tableau – A Data Visualization Tool 8331
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...Dialect If you just want to do something simple, you can try connecting directly to the JDBC driver and using the Tableau-provided PostgreSQL dialect. Create a DuckDB file containing your views and/or data. Launch Tableau. Under Connect > To a Server >...DuckDB taco connector as described below. Installing the Tableau DuckDB Connector While it is possible to use the Tableau-provided PostgreSQL dialect to communicate with the DuckDB JDBC driver, we strongly recommend using the DuckDB Taco connector . Thi...s connector has been fully tested against the Tableau dialect generator and is more compatible than the provided PostgreSQL dialect. The documentation on how to install and use the connector is in its repository, but essentially you wi... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Excel Import 8331
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...'A5:Z'); To skip the first 5 columns: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'E:Z'); If no range parameter is provided, DuckDB automatically infers the range as the rectangular region of cells between the first row of consecutive non-empty c...ells and the first empty row spanning the same columns. By default, if no range is provided, DuckDB will stop reading the Excel file when encountering an empty row. But when a range is provided, the default is to r... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Aggregate Functions 8331
- 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
...SELECT , HAVING , and ORDER BY clauses of a SQL query. DISTINCT Clause in Aggregate Functions When the DISTINCT clause is provided, only distinct values are considered in the computation of the aggregate. This is typically used in combination with the c...and max ) and for them this clause is parsed and ignored. ORDER BY Clause in Aggregate Functions An ORDER BY clause can be provided after the last argument of the function call. Note the lack of the comma separator before the clause. SELECT ⟨aggregate_fu...-value pairs representing buckets and counts. histogram(arg, boundaries) Returns a MAP of key-value pairs representing the provided upper boundaries and counts of elements in the corresponding bins (left-open and right-closed partitions) of the datatype.... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- SET and RESET Statements 8331
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...'DESC'; Set the default threads globally: SET GLOBAL threads = 4; Syntax SET updates a DuckDB configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value. Scopes Configuration... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
DuckDB 2.0 Documentation / man.mtool.work