Results of 1 - 10 of about 20 for Properties (0.003 sec.)
- Iceberg Functions 15566
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...ned for an Iceberg table. iceberg_view_metadata(view) Returns the raw LoadView response of the REST Catalog. iceberg_table_properties(table) Returns all properties of the specified table. set_iceberg_table_properties(table, properties) Sets properties on t...he specified table. remove_iceberg_table_properties(table, property_names) Removes properties from the specified table. iceberg_schema_properties(schema) Returns all properti...es of the specified schema. set_iceberg_schema_properties(schema, properties) Sets properties on the specified schema. remove_iceberg_schema_properties(schema, property_list) Remov... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Connect 9499
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...the same time. To open an existing database file in read-only mode, set the connection property duckdb.read_only like so: Properties readOnlyProperty = new Properties(); readOnlyProperty.setProperty("duckdb.read_only", "true"); Connection conn = DriverMan...hat many of these settings can also be changed later on with a SET (or SET GLOBAL ) statement , or the equivalent PRAGMA . Properties connectionProperties = new Properties(); connectionProperties.setProperty("temp_directory", "/path/to/temp/dir/"); connect...ionProperties.setProperty("memory_limit", "4GB"); Connection conn = DriverManager.getConnection("jdbc:duckdb:/tmp/my_database", connecti... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Writing to Iceberg 9176
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...iceberg_catalog.sales; USE iceberg_catalog.sales; Tables are created with the standard CREATE TABLE syntax. Iceberg table properties can be supplied with the WITH clause: CREATE TABLE test_create_table (a INTEGER) WITH ( 'format-version' = '2', -- format...ted from the result of a query: CREATE TABLE iceberg_catalog.sales.events_copy AS FROM iceberg_catalog.sales.events; Table properties can also be inspected and modified after creation, see Table Properties Functions . UPDATE and DELETE The UPDATE and DELET...berg_bucket and iceberg_truncate functions . The write.target-file-size-bytes and write.parquet.row-group-size-bytes table properties are honored for both partitioned and unpartitioned tables. Files are rotated at row-group boundaries, so if the row-group... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Handle Results 8649
- Overview Beyond the standard JDBC ResultSet , the DuckDB driver can hand results to Apache Arrow , stream large results instead of materializing them, and expose raw columnar data chunks. This page covers each of these result-handling optio
...by setting the jdbc_stream_results config to true before running a query. The easiest way to do that is to pass it in the Properties object. Properties props = new Properties(); props.setProperty(DuckDBDriver.JDBC_STREAM_RESULTS, String.valueOf(true)); Co... - https://man.mtool.work/duckdb/2.0/clients/java/result_handling.html
- Lakehouse Formats 8649
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...❌ ✅ Add/drop columns ✅ ✅ ❌ ✅ Alter column type ✅ ✅ ❌ ✅ Compaction and maintenance ✅ ✅ ❌ ✅ Encryption ✅ ❌ ❌ ❌ Manage table properties ✅ ✅ ✅ ** ❌ Time travel ✅ ✅ ✅ ❌ Query table changes ✅ ❌ ❌ ❌ * Through the unity_catalog extension. ** Table properties can... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- Delta Extension 8394
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...k that the path holds a Delta table. A mistyped path attaches as an empty database and only fails on the first read. Table Properties Options in a WITH clause are stored as Delta table properties, except location , which must match the attached path: ATTAC...TE TABLE audit.audit (id BIGINT, name VARCHAR) WITH ('delta.enableDeletionVectors' = 'true', 'delta.appendOnly' = 'true'); Properties that enable a Delta feature, such as deletion vectors, also upgrade the table's protocol as needed. Values can be any cons...tant expression except NULL . Some properties cannot be set at creation, such as 'delta.enableVariantShredding' . To create a table with column mapping , set 'delta.col... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Profile and Monitor 8122
- Overview The JDBC driver exposes several ways to observe a running or completed query: cancelling and timing out queries, polling query progress, retrieving profiling output, and emitting memory-usage events through Java Flight Recorder . T
...field, so that operators can attribute memory to logical components. An absent or empty value leaves monitoring disabled. Properties props = new Properties(); props.setProperty("jdbc_jfr_memory_monitor", "analytics-db"); try (Connection conn = DriverManag... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Spatial Functions 8021
- 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
...rdinate of a geometry Aggregate Functions Function Summary ST_AsMVT Make a Mapbox Vector Tile from a set of geometries and properties ST_CoverageInvalidEdges_Agg Returns the invalid edges of a coverage geometry ST_CoverageSimplify_Agg Simplifies a set of g...N feature (requires the JSON extension to be loaded) SELECT CAST({ type: 'Feature', geometry: ST_AsGeoJSON(ST_Point(1,2)), properties: { name: 'my_point' } } AS JSON); ---- {"type":"Feature","geometry":{"type":"Point","coordinates":[1.0,2.0]},"properties":...col1 VARCHAR, col2 INTEGER, col3 VARCHAR, col4 VARCHAR) Description Make a Mapbox Vector Tile from a set of geometries and properties The function takes as input a row type (STRUCT) containing a geometry column and any number of property columns. It return... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- CSV Auto Detection 8021
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...possible to run the CSV sniffer as a separate step using the sniff_csv(filename) function, which returns the detected CSV properties as a table with a single row. Besides the commonly used sample_size parameter, which configures the number of rows sampled...ead_csv function . Any parameter you pass is treated as fixed: the sniffer uses the value you provide and only detects the properties you did not specify. For example, passing ignore_errors = true lets the sniffer skip malformed lines while it detects the... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Directly Reading Files 7919
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
...set to NULL instead. Support for Projection Pushdown These table functions also use projection pushdown to avoid computing properties unnecessarily. For example, you can glob a directory of large files to get file sizes in the size column. As long as you o... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
DuckDB 2.0 Documentation / man.mtool.work