Results of 1 - 10 of about 14 for children (0.002 sec.)
- Profile and Monitor 13671
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
....execute("SELECT 42", [])?; let info = conn.get_profiling_info().expect("profiling should be enabled"); println!("profiled children: {}", info.children.len()); get_profiling_info() returns an Option<ProfilingInfo> , which is None when profiling is not en...abled. ProfilingInfo is a tree whose metrics are grouped and named in lowercase (see the metrics list ): the root's children are the root plan operator, with metrics such as type , timing and intermediate_rows , followed by one node per metric gro...up, such as query with total_time . Read a node's metrics through its metrics map and its children through children . Interrupting Queries A long-running query can be cancelled from another thread. Call interrupt_handle()... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- TPC-H Extension 10800
- The tpch extension implements the data generator and queries for the TPC-H benchmark . Installing and Loading The tpch extension is shipped by default in some DuckDB builds, otherwise it will be transparently autoloaded on first use. If you
...eters The data generator function dbgen has the following parameters: Name Type Description catalog VARCHAR Target catalog children UINTEGER Number of partitions overwrite BOOLEAN (Not used) sf DOUBLE Scale factor step UINTEGER Defines the partition to b...e generated, indexed from 0 to children - 1. Must be defined when the children arguments is defined suffix VARCHAR Append the suffix to table names Pre-Generated... - https://man.mtool.work/duckdb/2.0/core_extensions/tpch.html
- Profile and Monitor 10538
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...duckdb.ProfilingInfo , a tree that mirrors DuckDB's query plan. Each node has a Metrics map of metric name to value and a Children slice of child nodes. Metrics are grouped and named in lowercase: the root's children are the root plan operator, whose me...one node per metric group, e.g., the query group with total_time . Walk the tree to read them: for _, child := range info.Children { if opType, ok := child.Metrics["type"]; ok { log.Printf("operator: %s, timing: %s", opType, child.Metrics["timing"]) } }... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- Metrics 9365
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
..."extra_info": {}, "intermediate_rows": 0, "intermediate_size_bytes": 0, "timing": 5.458e-06, "type": "RESULT_COLLECTOR", "children": [ { "extra_info": { "Projections": "name", "Estimated Cardinality": "1" }, "intermediate_rows": 2, "intermediate_size_by...tes": 40, "timing": 8.3e-08, "type": "PROJECTION", "children": [ { "extra_info": { "Join Type": "INNER", "Conditions": "sid = sid", "Estimated Cardinality": "1" }, "intermediate_rows"...: 2, "intermediate_size_bytes": 48, "timing": 4.4209e-05, "type": "HASH_JOIN", "children": [ ... "query": { "total_time": 0.001491167 } } The second example collects all query and planner metrics, as well as the... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Types API 8962
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...r Type Names . Inspecting Types A DuckDBPyType has an id , such as 'struct' . A nested type, an ENUM or a DECIMAL also has children , a list of pairs of a name and a type or a value. The field of a STRUCT type is also available by attribute or by key: po...int = duckdb.struct_type({"x": INTEGER, "y": VARCHAR}) print(point.id) print(point.children) print(point.x, point["y"]) struct [('x', INTEGER), ('y', VARCHAR)] INTEGER VARCHAR... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Querying Parquet Metadata 8052
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...by parquet_schema . Field Type file_name VARCHAR name VARCHAR type VARCHAR type_length VARCHAR repetition_type VARCHAR num_children BIGINT converted_type VARCHAR scale BIGINT precision BIGINT field_id BIGINT logical_type VARCHAR Parquet File Metadata The... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Types 7929
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...of the map type. Must be destroyed with duckdb_destroy_logical_type . duckdb_struct_type_child_count Returns the number of children of a struct type. Syntax idx_t duckdb_struct_type_child_count ( duckdb_logical_type type ); Parameters type : The logical...type object Return Value The number of children of a struct type. duckdb_struct_type_child_name Retrieves the name of the struct child. The result must be freed with duck... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Struct Functions 7929
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...pping}) , and nest its defaults the same way. A LIST 's single child is addressed by the mapping key 'list' , and a MAP 's children by the keys 'key' and 'value' . row(any, ...) | Description | Create a TUPLE containing the argument values. | | Example |... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Typecasting 7789
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...ation. Lists / Arrays Lists can be explicitly cast to other lists using the same casting rules. The cast is applied to the children of the list. For example, if we convert an INTEGER[] list to a VARCHAR[] list, the child INTEGER elements are individually... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Conversion between DuckDB and Python 7667
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...1 , as in duckdb.Value(b"0101", duckdb.sqltypes.BIT) . list list becomes a LIST type of the “most permissive” type of its children. For example, [12345, "test"] becomes VARCHAR[] , because 12345 can convert to VARCHAR but test can not convert to INTEGER... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
DuckDB 2.0 Documentation / man.mtool.work