Results of 1 - 10 of about 14 for collection (0.003 sec.)
- Spatial Functions 14371
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...ill in" the input geometry. ST_Centroid Returns the centroid of a geometry ST_Collect Collects a list of geometries into a collection geometry. ST_CollectionExtract Extracts geometries from a GeometryCollection into a typed multi geometry. ST_ConcaveHull R...pe. Possible enum return types are: POINT , LINESTRING , POLYGON , MULTIPOINT , MULTILINESTRING , MULTIPOLYGON and GEOMETRYCOLLECTION . ST_HasM Check if the input geometry has M values. ST_HasZ Check if the input geometry has Z values. ST_Hilbert Encodes t...ulti-point, containing the point(s) at the geometry with the given measure ST_LocateBetween Returns a geometry or geometry collection created by filtering and interpolating vertices within a range of "M" values ST_M Returns the M coordinate of a point geom... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Import Data 9907
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...lling flush() . Within a row, appendNull() writes a NULL and appendDefault() writes the column's DEFAULT value. Nested and collection types are appended within a row as well. For a STRUCT column, call beginStruct() , append each field value in declaration...oid allocating a Java object per row. Boxing values or constructing a new object for every row adds allocation and garbage-collection pressure. Prefer the primitive append() overloads and reuse buffers where you can. Keep strings short where possible. Duck...ward compatibility. Warning New code should use the DuckDBAppender described above, which is faster and appends nested and collection types. DuckDBSingleValueAppender is kept only for existing applications. Batch Writer The DuckDB JDBC driver offers batch... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Geometry Data Type 9907
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...or a building footprint. The first ring is the "shell", and "interior" rings represent holes in the polygon. MultiPoint A collection of points. MultiLineString A collection of LineStrings. MultiPolygon A collection of Polygons. GeometryCollection A collec...ent geometry types, allowing for complex geometries that combine points, lines, and polygons or even other nested geometry collections. The textual representation of geometries uses "Well-Known Text" (WKT) format. Geometries can be cast to and from WKT str...0, 30 30, 40 20))'), (6, 'MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)), ((15 5, 40 10, 10 20, 5 10,15 5)))'), (7, 'GEOMETRYCOLLECTION (POINT(40 10), LINESTRING(10 10,20 20,10 40), POLYGON((40 40,20 45,45 30,40 40)))'); SELECT * FROM geometries; ---- ┌─────... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- C++ API 9085
- Installation To use the DuckDB C++ API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C++ API is 2.0.0. Warning DuckDB's C++ API is internal. It is not guaranteed to be stable and can change witho
...e full result, the result set can be traversed directly by index. Use ColumnCount() and RowCount() for the dimensions, and Collection().GetValue(column, row) to retrieve an individual value as a duckdb::Value : auto result = con.Query("SELECT * FROM intege...Count(); col_idx++) { // GetValue returns a duckdb::Value; ToString renders it (NULL values become "NULL") cout << result->Collection().GetValue(col_idx, row_idx).ToString(); cout << (col_idx + 1 < result->ColumnCount() ? "\t" : "\n"); } } } DuckDB also su... - https://man.mtool.work/duckdb/2.0/clients/cpp.html
- CSV Import Tips 8419
- Below is a collection of tips to help when attempting to import complex CSV files. In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the hea
... - https://man.mtool.work/duckdb/2.0/data/csv/tips.html
- IN Operator 8419
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Parquet Tips 8087
- Below is a collection of tips to help when dealing with Parquet files. Tips for Reading Parquet Files Use union_by_name When Loading Files with Different Schemas The union_by_name option can be used to unify the schema of files that have di
... - https://man.mtool.work/duckdb/2.0/data/parquet/tips.html
- SQL Introduction 8087
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...em for managing data stored in relations. A relation is essentially a mathematical term for a table. Each table is a named collection of rows. Each row of a given table has the same set of named columns, and each column is of a specific data type. Tables t...hemselves are stored inside schemas, and a collection of schemas constitutes the entire database that you can access. Creating a New Table You can create a new table by specify... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- Appender 7929
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...been written to the database. Note In Python, call flush() or use a with block, which flushes on successful exit. Garbage collection discards any remaining buffered rows. See the Python Appender . Constraints such as NOT NULL , PRIMARY KEY , and UNIQUE ar... - https://man.mtool.work/duckdb/2.0/data/appender.html
- Integration with Ibis 7929
- Ibis is a Python dataframe library that supports 20+ backends, with DuckDB as the default. Ibis with DuckDB provides a Pythonic interface for SQL with great performance. Warning Ibis 12.0.0 and earlier do not support DuckDB 2.0. The example
...────────┴────────────────┴───────────────┴───────────────────┴─────────────┴────────┴───────┘ Common Operations Ibis has a collection of useful table methods to manipulate and query the data in a table. filter filter allows you to select rows based on a co...│ └───────────┴──────────────────┘ What about the largest male penguin (by body mass) on each island for each year of data collection? penguins.filter(penguins.sex == "male").group_by(["island", "year"]).aggregate( penguins.body_mass_g.max().name("max_body... - https://man.mtool.work/duckdb/2.0/guides/python/ibis.html
DuckDB 2.0 Documentation / man.mtool.work