Results of 1 - 10 of about 19 for property (0.002 sec.)
- Graph Queries 13916
- DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for
...arser , and you have to opt in to an extension's grammar explicitly. To enable the SQL/PGQ syntax of DuckPGQ (e.g., CREATE PROPERTY GRAPH and GRAPH_TABLE ), run: SET active_grammar_extensions = ['duckpgq']; Creating a Property Graph A property graph cons...LUES (1, 'Alice'), (2, 'Bob'), (3, 'Charlie'); INSERT INTO Knows VALUES (1, 2, '2020-01-01'), (2, 3, '2021-06-15'); CREATE PROPERTY GRAPH social_network VERTEX TABLES ( Person ) EDGE TABLES ( Knows SOURCE KEY (person1_id) REFERENCES Person (id) DESTINATI...ith DuckDB and Graph Queries" blog post for a detailed example of detecting money laundering patterns. Cleanup To remove a property graph: DROP PROPERTY GRAPH social_network; Further Reading DuckPGQ Documentation DuckPGQ Community Extension "Uncovering F... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Profile and Monitor 11713
- 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
...tly opt-in and is a silent no-op on JVMs without JFR support: nothing is emitted unless the application both sets the JDBC property on a connection and has an active JFR recording that enables the event. Enabling Emission Monitoring is opt-in per connect...ion: set the jdbc_jfr_memory_monitor property to an identifier for the connection's database instance. The value is an arbitrary label that is attached to every event a...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 = DriverManager.getConnection("jdbc:duckdb:/tmp/my_databa... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Iceberg Functions 9647
- 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
...iceberg_table_properties(table, properties) Sets properties on the specified table. remove_iceberg_table_properties(table, property_names) Removes properties from the specified table. iceberg_schema_properties(schema) Returns all properties of the specif...rg_schema_properties(schema, properties) Sets properties on the specified schema. remove_iceberg_schema_properties(schema, property_list) Removes properties from the specified schema. iceberg_rollback_to_snapshot(table, snapshot_id) Rolls back an Iceberg...iceberg_table_properties(table, properties) Sets properties on the specified table. remove_iceberg_table_properties(table, property_names) Removes properties from the specified table. You can also use ALTER TABLE ... SET and ALTER TABLE ... RESET to modi... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Iceberg Options 9237
- 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
...WITH ('location' = …) clause derives the table location as ⟨namespace location⟩/⟨table name⟩ from the namespace's location property. An explicit WITH ('location' = …) clause still takes precedence, and if the namespace has no location property the behavi...ation per table, or set DEFAULT_TABLE_LOCATION_FROM_NAMESPACE to true to derive the location from the namespace's location property. Authorization To configure the Authorization layer for connecting to an Iceberg REST Catalog, you'll need to pass the AUT...ault_format_version UBIGINT 2 The Iceberg format version used when creating a new table without an explicit format-version property. Valid values are 2 and 3 . iceberg_unsafe_skip_puffin_verification BOOLEAN false When reading V3 Deletion Vectors, skip t... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Struct Data Type 9237
- Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refers to those entry names as keys. Each row in the STRUCT column must have the same keys.
...; part1 is a column One Dot SELECT part1.part2 FROM tbl; part1 is a table, part2 is a column part1 is a column, part2 is a property of that column Two (or More) Dots SELECT part1.part2.part3 FROM tbl; part1 is a schema, part2 is a table, part3 is a colum...n part1 is a table, part2 is a column, part3 is a property of that column part1 is a column, part2 is a property of that column, part3 is a property of that column Any extra parts (... - https://man.mtool.work/duckdb/2.0/sql/data_types/struct.html
- Python DB API 8810
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...1), ('hammer', Decimal('42.20'), 2)] ('jeans', Decimal('20.00'), 1) [('hammer', Decimal('42.20'), 2)] None The description property of the connection object contains the column names as per the standard. The rowcount property holds the number of rows tha...ion raises an error, including reading a relation, register() and create_function() . Building a relation, the description property and cursor() still work, so a cursor can run other queries in the meantime. con.execute("SELECT * FROM items") con.sql("SE... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Constraints 8674
- In SQL, constraints can be specified for tables. Constraints enforce certain properties over data that is inserted into a table. Constraints can be specified along with the schema of the table as part of the CREATE TABLE statement . In cert
...(1, 'Student 1'); Constraint Error: Duplicate key "id: 1, name: Student 1" violates primary key constraint To enforce this property efficiently, an ART index is automatically created for every primary key or unique constraint that is defined in the table...nstraint Error: Violates foreign key constraint because key "id: 2" does not exist in the referenced table To enforce this property efficiently, an ART index is automatically created for every foreign key constraint that is defined in the table. Warning... - https://man.mtool.work/duckdb/2.0/sql/constraints.html
- Connect 8401
- 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
...t to read the same database file at 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 = DriverManager.getConnection("jdbc:duckdb:/tmp/my_database", readOnlyProperty); Read-only mode can also be set through DuckDB's standard access_mode property, for example access_mode=READ_ONLY . If bo...LOBAL ) statement , or the equivalent PRAGMA . Properties connectionProperties = new Properties(); connectionProperties.setProperty("temp_directory", "/path/to/temp/dir/"); connectionProperties.setProperty("memory_limit", "4GB"); Connection conn = Driver... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- AsOf Join 8401
- What is an AsOf Join? Time series data is not always perfectly aligned. Clocks may be slightly off, or there may be a delay between cause and effect. This can make connecting two sets of ordered data challenging. AsOf joins are a tool for s
...g this and other similar problems. One of the problems that AsOf joins are used to solve is finding the value of a varying property at a specific point in time. This use case is so common that it is where the name came from: Give me the value of the prop... - https://man.mtool.work/duckdb/2.0/guides/sql_features/asof_join.html
- Multiple Connections 8127
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...y . All queries with the same connection label will be executed in the same connection. A test that would verify the above property would look as follows: statement ok con1 BEGIN TRANSACTION statement ok con1 CREATE TABLE integers (i INTEGER); statement... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
DuckDB 2.0 Documentation / man.mtool.work