Results of 1 - 9 of about 9 for label (0.001 sec.)
- Graph Queries 11935
- 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
...s Alice Charlie 2 Graph Algorithms DuckPGQ includes built-in graph algorithms: Function Description pagerank(graph, vertex_label, edge_label) Computes PageRank centrality scores local_clustering_coefficient(graph, vertex_label, edge_label) Measures ho...w connected a node's neighbors are weakly_connected_component(graph, vertex_label, edge_label) Identifies connected components Example: FROM pagerank('social_network', 'Person', 'Knows'); Use Case: Financ... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Integration with PyTorch 11611
- PyTorch tensors can be built from DuckDB query results by exporting each result batch as Apache Arrow . This pattern is useful when training or serving models on Parquet data because DuckDB can filter and project the input before the batche
...queries a Parquet-backed Arrow dataset, streams the result as RecordBatch objects and converts each batch into feature and label tensors. import pathlib import tempfile import duckdb import numpy as np import pyarrow as pa import pyarrow.dataset as ds...rquet_dir = base_path / "train" table = pa.table( { "feature_0": [0.1, 0.3, 0.5, 0.7], "feature_1": [1.0, 0.0, 1.0, 0.0], "label": [0, 1, 1, 0], } ) pq.write_to_dataset(table, str(parquet_dir)) con = duckdb.connect() train_dataset = ds.dataset(str(par...quet_dir)) reader = con.sql(""" SELECT feature_0, feature_1, label FROM train_dataset WHERE label = 1 """).to_arrow_reader(batch_size=2) for batch in reader: features = torch.tensor( np.col... - https://man.mtool.work/duckdb/2.0/guides/python/pytorch.html
- Profile and Monitor 10191
- 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
...et 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 as its component field, so that operators can attribute memory to logical components. An a...the same as absent. non-empty string Events emitted, tagged with the given value. The JDBC property is only an enable and label switch. It does not control whether JFR is recording or the sampling period; those are governed by the JFR recording setti...e JDBC connection. There is one sample stream per distinct instance, so shared memory is not double-counted. The component label is captured from the first opted-in connection to an instance, and later opted-in connections to the same instance do not... - https://man.mtool.work/duckdb/2.0/clients/java/profiling.html
- Result Verification 9221
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...at indicates that the result should be sorted in a specific manner. This field goes in the same location as the connection label. Because of that, connection labels and result sorting cannot be mixed. The possible values of this field are nosort , row...answers. However, existing sqllogictests use this field extensively, hence it is important to know of its existence. Query Labels Another feature that can be used for result verification are query labels . These can be used to verify that different qu...ide the same result. This is useful for comparing queries that are logically equivalent, but formulated differently. Query labels are provided after the connection label or sorting specifier. Queries that have a query label do not need to have a resul... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Multiple Connections 8681
- 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
...hat the table is not accessible yet until committed. We can use multiple connections in the sqllogictests using connection labels . The connection label can be optionally appended to any statement or query . All queries with the same connection label... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- Connect 7585
- 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
...b: A connection-private in-memory database. jdbc:duckdb:memory: The same as above, written explicitly. jdbc:duckdb:memory:⟨label⟩ A named in-memory database that other connections can share. jdbc:duckdb:⟨path⟩ A database file on disk, for example jdbc...Each connection gets its own separate instance, and its data is not shared with any other connection. jdbc:duckdb:memory:⟨label⟩ A named in-memory database. Connections using the same label share one cached instance, keyed by :memory:⟨label⟩ . jdbc:d... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Write User Defined Functions 7585
- Overview The JDBC driver can register user-defined functions (UDFs) written in Java, including scalar functions and table functions. This page covers building and registering both, from the simple functional-interface overloads to the vecto
...icalType dblType = DuckDBLogicalType.of(DuckDBColumnType.DOUBLE)) { DuckDBFunctions.scalarFunction() .withName("java_event_label") .withParameters(tsType, strType, dblType) .withReturnType(strType) .withVectorizedFunction((input, output) -> { input.st...+ " | " + input.vector(2).getDouble(row, 0.0d); output.setString(row, value); }); }) .register(conn); } SELECT java_event_label(TIMESTAMP '2026-04-04 12:00:00', 'launch', 4.5); The DuckDBDataChunkReader , its DuckDBReadableVector columns, and the Duc...blic Long bind(DuckDBTableFunctionBindInfo info) throws Exception { info.addResultColumn("n", Long.TYPE) .addResultColumn("label", String.class); return info.getParameter(0).getLong(); } @Override public Series init(DuckDBTableFunctionInitInfo info) t... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- marimo Notebooks 7046
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...ng so, dependent cells are only marked as stale, letting the user choose when they should be re-run. digits = mo.ui.slider(label="Digits", start=100, stop=10000, step=200) digits CREATE TABLE random_data AS SELECT i AS id, random() AS random_value, FR... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Lance Extension 6938
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...ain.my_dataset; Vector Search -- Search a vector column, returning distances in `_distance` (smaller is closer) SELECT id, label, _distance FROM lance_vector_search( '⟨path/to/dataset.lance⟩', 'vec', [0.1, 0.2, 0.3, 0.4]::FLOAT[4], k = 5, prefilter =... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work