Results of 1 - 10 of about 34 for implements (0.001 sec.)
- Run Queries 11503
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...ject , which returns the following types: DuckDB type Java type returned by getObject LIST , ARRAY org.duckdb.DuckDBArray (implements java.sql.Array ) STRUCT org.duckdb.DuckDBStruct (implements java.sql.Struct ) MAP java.util.LinkedHashMap UNION the resolv...MicrosEpoch(); long timeMicros = new DuckDBTime(Time.valueOf("12:30:00")).getMicrosEpoch(); Inspecting Metadata The driver implements the standard JDBC metadata interfaces, so an application can introspect the database, a result set, or a prepared statemen... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- ICU Extension 11503
- The icu extension provides collation, time zone, and calendar support. New In DuckDB 2.0, the dependency on the external ICU library was removed. The icu extension now implements collations, time zones, and calendars natively, with time zon
... - https://man.mtool.work/duckdb/2.0/core_extensions/icu.html
- Overview 10497
- 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. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contain
... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
- Run Queries 10497
- Overview A Connection runs SQL through two families of methods: The execute_* methods ( execute() and execute_batch() ) send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. The query_* meth
...ND $name = 'Alice'", named_params! { "age": min_age, "name": name, }, |row| row.get(0), )?; Any value bound as a parameter implements the ToSql trait, and any value read out of a row implements FromSql . The crate provides both for the standard Rust numeri... - https://man.mtool.work/duckdb/2.0/clients/rust/querying.html
- Write User Defined Functions 9985
- Overview The Rust client can register user-defined functions written in Rust: scalar functions with the vscalar feature and table functions with the vtab feature. Both operate on DuckDB's columnar data chunks, so a single call processes a b
...ch, then point to a template for packaging them as a loadable extension. Scalar Functions A scalar function is a type that implements the VScalar trait, registered on a connection with register_scalar_function() . DuckDB calls the function's invoke() once...heck each value's validity. This feature requires features = ["vscalar"] . Table Functions A table function is a type that implements the VTab trait, registered with register_table_function() and queried like any other table. VTab splits the work across th... - https://man.mtool.work/duckdb/2.0/clients/rust/functions.html
- Spark API 9490
- The DuckDB Spark API implements the PySpark API , allowing you to use the familiar Spark API to interact with DuckDB. All statements are translated to DuckDB's internal plans using our relational API and executed using DuckDB's query engine
... - https://man.mtool.work/duckdb/2.0/clients/python/spark_api.html
- Logging 9490
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...above will be queryable using FROM duckdb_logs; and will produce identical results. Buffer Size The log storage in DuckDB implements a buffering mechanism to optimize logging performance. This implementation introduces a potential delay between message lo... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- TPC-DS Extension 8979
- New In DuckDB 2.0, the dsdgen data generator was updated to match the TPC-DS version 4 tools. As a result, the generated data differs slightly from the data generated by DuckDB v1.x. See the related PR for more details. The tpcds extension
... - https://man.mtool.work/duckdb/2.0/core_extensions/tpcds.html
- Integration with Polars 8979
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...plan: (run LazyFrame.explain(optimized=True) to see the optimized plan) PYTHON SCAN [] PROJECT */2 COLUMNS A relation also implements the Arrow PyCapsule interface , so pl.DataFrame(rel) reads it too, without pyarrow installed. pl.from_arrow(rel) returns a... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- Timestamp Types 8979
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...ort The TIMESTAMPTZ type can be binned into calendar and clock bins using a suitable extension. The built-in icu extension implements all the binning and arithmetic functions using time zone data built from the IANA Time Zone Database and its own calendar...he icu extension no longer depends on the International Components for Unicode (ICU) library: starting with DuckDB 2.0, it implements time zones, calendars and collations natively. To set the time zone to use, first load the icu extension. The icu extensio... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
DuckDB 2.0 Documentation / man.mtool.work