Results of 1 - 10 of about 45 for returned (0.006 sec.)
- Spatial Functions – DuckDB 13995
- 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
...eometry is assumed to be in the EPSG:4326 coordinate system (WGS84), with [latitude, longitude] axis order and the area is returned in square meters. This function uses the GeographicLib library, calculating the area using an ellipsoidal model of the ear..., relative BOOLEAN , precision INTEGER ) Description Convert the geometry into a SVG fragment or path The SVG fragment is returned as a string. The fragment is a path element that can be used in an SVG document. The second boolean argument specifies whe...[]) Description Collects a list of geometries into a collection geometry. If all geometries are POINT 's, a MULTIPOINT is returned. If all geometries are LINESTRING 's, a MULTILINESTRING is returned. If all geometries are POLYGON 's, a MULTIPOLYGON is r... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Querying Parquet Metadata – DuckDB 11193
- 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
...of what the different columns contain: SELECT * FROM parquet_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_metadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_rows BIGINT row_group_num_columns BIG...ch the internal schema of a Parquet file: SELECT * FROM parquet_schema ( 'test.parquet' ); Below is a table of the columns returned by parquet_schema . Field Type file_name VARCHAR name VARCHAR type VARCHAR type_length VARCHAR repetition_type VARCHAR num...and the encryption algorithm used: SELECT * FROM parquet_file_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_file_metadata . Field Type file_name VARCHAR created_by VARCHAR num_rows BIGINT num_row_groups BIGINT format_ve... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Set Operations – DuckDB 11024
- 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
...rows from multiple queries. The queries are required to return the same number of columns. Implicit casting to one of the returned types is performed to combine columns of different types where necessary. If this is not possible, the UNION clause throws...both queries. Vanilla INTERSECT (Set Semantics) Vanilla INTERSECT performs duplicate elimination, so only unique rows are returned. SELECT * FROM range ( 2 ) t1 ( x ) INTERSECT SELECT * FROM range ( 6 ) t2 ( x ); x 0 1 INTERSECT ALL (Bag Semantics) INTE...RSECT ALL follows bag semantics, so duplicates are returned. SELECT unnest ([ 5 , 5 , 6 , 6 , 6 , 6 , 7 , 8 ]) AS x INTERSECT ALL SELECT unnest ([ 5 , 6 , 6 , 7 , 7 , 9 ]); x 5 6 6 7... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/setops.html
- DuckDB_% Metadata Functions – DuckDB 10672
- 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
...the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be used just like an ordinary table or view. For example, you can use a duckdb_ function c...all in the FROM clause of a SELECT statement, and you may refer to the columns of its returned resultset elsewhere in the statement, for example in the WHERE clause. Table functions are still functions, and you should...write parenthesis after the function name to call it to obtain its returned resultset: SELECT * FROM duckdb_settings (); Alternatively, you may execute table functions also using the CALL -syntax: C... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Profiling – DuckDB 9799
- 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
...absolute The cardinality of each operator, i.e., the number of rows it returns to its parent. Operator equivalent of ROWS_RETURNED OPERATOR_ROWS_SCANNED uint64 absolute The total rows scanned by each operator OPERATOR_TIMING double seconds The time take...ring The name of each operator QUERY_NAME string The query string RESULT_SET_SIZE uint64 bytes The size of the result ROWS_RETURNED uint64 absolute The number of rows returned by the query SYSTEM_PEAK_BUFFER_MEMORY uint64 bytes Peak memory usage of all a...in the QUERY_ROOT node. These include OPTIMIZER , PLANNER , and PHYSICAL_PLANNER metrics. They are measured in seconds and returned as a double . It is possible to toggle each of these additional metrics individually. Optimizer Metrics At the QUERY_ROOT... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- INSERT Statement – DuckDB 9631
- 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
...ated primary key. This is also useful in the case of generated columns. Some or all columns can be explicitly chosen to be returned and they may optionally be renamed using aliases. Arbitrary non-aggregating expressions may also be returned instead of si...mply returning a column. All columns can be returned using the * expression, and columns or expressions can be returned in addition to all columns returned by the * . For exam... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- DuckLake – DuckDB 8758
- 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
...rt_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no end_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no The schema of the table returned by the function is equivalent to that of the table table_name . ducklake_table_deletions The ducklake_table_deletions func...rt_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no end_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no The schema of the table returned by the function is equivalent to that of the table table_name . ducklake_table_changes The ducklake_table_changes function...rt_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no end_snapshot BIGINT / TIMESTAMP WITH TIME ZONE no The schema of the table returned by the function contains the following three columns plus the schema of the table table_name . Column name Column type Des... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
- Conversion between DuckDB and Python – DuckDB 8406
- 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
...map(integer, varchar) │ ├─────────────────────────┤ │ {1=one, 2=two, 3=three} │ └─────────────────────────┘ If the dict is returned by a function , the function will return a MAP , therefore the function return_type has to be specified. Providing a retur...'three': [1, 2, 3], 'False': true} │ └────────────────────────────────────────────────────────────────────┘ If the dict is returned by a function , the function will return a MAP , due to automatic conversion . To return a STRUCT , the return_type has to...is an alias of df() fetch_df_chunk(vector_multiple) fetches a portion of the results into a DataFrame. The number of rows returned in each chunk is the vector size (2048 by default) * vector_multiple (1 by default). Apache Arrow arrow() fetches the data... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- CLI Client – DuckDB 8237
- 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
...open --readonly preexisting.duckdb Output Formats The .mode dot command may be used to change the appearance of the tables returned in the terminal output. These include the default duckbox mode, csv and json mode for ingestion by other tools, markdown a...generate_series ( 5 ); To execute it from the CLI, the .read command is used. .read select_example.sql The output below is returned to the terminal by default. The formatting of the table can be adjusted using the .output or .once commands. | generate_se...execute it from the CLI, the .read command is used as before. .read write_markdown_to_file.sql In this case, no output is returned to the terminal. Instead, the file series.md is created (or replaced if it already existed) with the markdown-formatted re... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- FROM and JOIN Clauses – DuckDB 8054
- 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
...icate, but there are other implied rules that may be specified. Outer Joins Rows that do not have any matches can still be returned if an OUTER join is specified. Outer joins can be one of: LEFT (All rows from the left relation appear at least once) RIGH...FULL (All rows from both relations appear at least once) A join that is not OUTER is INNER (only rows that get paired are returned). When an unpaired row is returned, the attributes from the other table are set to NULL . Cross Product Joins (Cartesian P... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
DuckDB 1.3 Documentation / man.mtool.work