Results of 1 - 10 of about 75 for argument (0.002 sec.)
- Benchmark Suite 11628
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...r escaping). build/release/benchmark/benchmark_runner "benchmark/micro/nulls/.*" Running All Benchmarks Not specifying any argument will run all benchmarks. build/release/benchmark/benchmark_runner Other Options The --info flag gives you some other infor...cro subgroup window While some benchmarks run a single query, it can often be useful to parameterize a benchmark using the argument keyword. This allows the benchmark to be run with different settings, such as data volume. For the FILL benchmark, there a...re three arguments: argument sf 10 argument errors 0.1 argument keys 4 For FILL these are * The scale factor (millions of rows per partition... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Dot Commands 11017
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...e separated, after the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must be entered on a...by SQL .columns Column-wise rendering of query results .connect_command ⟨COMMAND⟩ Set the command executed by the -connect argument .databases List names and files of attached databases .decimal_sep ⟨SEP⟩ Set the decimal separator used when rendering num...separator ⟨COL⟩ ⟨ROW⟩ Change the column and row separators .serve_command ⟨COMMAND⟩ Set the command executed by the -serve argument .shell ⟨CMD⟩ ⟨ARGS...⟩ Run CMD with ARGS... in a system shell .show Show the current values for various settings .singleli... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Arguments 10544
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...kDB in a secure manner -version Show DuckDB version Serving and Connecting to Remote Databases New The -serve and -connect arguments were introduced in DuckDB 2.0. The -serve argument starts a Quack server for the database opened by the CLI. Without a da...duckdb -serve To serve a persistent database, provide its path before -serve : duckdb analytics.duckdb -serve The -connect argument connects the CLI to a remote database. Without arguments, it connects to the Quack server on localhost:9494 using the defa...secret, so running duckdb -serve and duckdb -connect on the same machine works without further setup: duckdb -connect Both arguments accept a connection type and an optional named secret in the form TYPE:SECRET . Only the quack type can be served. For ex... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Directly Read DuckDB Databases 9919
- DuckDB allows directly reading DuckDB files through the read_duckdb function: read_duckdb(⟨'path_to_database'⟩, table_name = ⟨'table_to_read'⟩); Using this function is equivalent to performing the following steps: Attaching to the database
...using a read-only connection. Querying the table specified through the table_name argument. Closing the connection to the database. Examples Reading a Specific Table To read the region table from the TPC-H dataset...│ int32 │ ├───────┤ │ 42 │ │ 43 │ └───────┘ Reading from Databases with a Single Table If all databases in read_duckdb 's argument have a single table, the table_name argument is optional: FROM read_duckdb('my-2.duckdb'); ┌───────┐ │ x │ │ int32 │ ├────... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_duckdb.html
- NULL Values 9613
- NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as “the value of this field is unknown”. A NULL value can be inserted to any fie
...NULL SELECT NULL IS NOT DISTINCT FROM NULL; true SELECT NULL IS NULL; true NULL and Functions A function that has an input argument as NULL usually returns NULL . SELECT cos(NULL); NULL The coalesce function is an exception to this: it takes any number o...f arguments, and returns for each row the first argument that is not NULL . If all arguments are NULL , coalesce also returns NULL ....LECT coalesce(NULL, NULL, 1); 1 SELECT coalesce(10, 20); 10 SELECT coalesce(NULL, NULL); NULL The ifnull function is a two-argument version of coalesce . SELECT ifnull(NULL, 'default_string'); default_string SELECT ifnull(1, 'default_string'); 1 NULL and... - https://man.mtool.work/duckdb/2.0/sql/data_types/nulls.html
- Enum Functions 9613
- This section describes functions and operators for examining and manipulating ENUM values . The examples assume an enum type created as: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy', 'anxious'); These functions can take NULL or a specific
...value of the type as argument(s). Most enum functions return a value that depends only on the type of the argument, and not on its value. The functions...enum_code() and enum_range_boundary() are exceptions; they return a value that depends on the argument value, as well as its type. Name Description enum_code(enum_value) Returns the (0-based) numeric value backing the given e... - https://man.mtool.work/duckdb/2.0/sql/functions/enum.html
- Spatial Functions 9141
- 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
...G fragment is returned as a string. The fragment is a path element that can be used in an SVG document. The second boolean argument specifies whether the path should be relative or absolute. The third argument specifies the maximum number of digits to us...tion Computes the closest point on a LINESTRING to a given POINT and returns the interpolated M value of that point. First argument must be a linestring and must have a M dimension. The second argument must be a point. Neither argument can be empty. ST_I...eometry \"properly\" is contained by the second geometry This function functions the same as ST_ContainsProperly , but the arguments are swapped. ST_X Signatures DOUBLE ST_X (geom GEOMETRY) DOUBLE ST_X (point POINT_2D) Description Returns the X coordinat... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Union Functions 8683
- Name Description union.tag Dot notation serves as an alias for union_extract . union_extract(union, 'tag') Extract the value with the named tags from the union. NULL if the tag is not currently selected. union_value(tag := any) Create a sin
...gle member UNION containing the argument value. The tag of the value will be the bound variable name. union_tag(union) Retrieve the currently selected tag of the u...n_extract(s, 'k') | | Result | hello | union_value(tag := any) | Description | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. | | Example | union_value(k := 'hello') | | Result | hello (o... - https://man.mtool.work/duckdb/2.0/sql/functions/union.html
- Creating JSON 8516
- JSON Creation Functions The following functions are used to create JSON. Function Description to_json(any) Create JSON from a value of any type. Our LIST is converted to a JSON array, and our STRUCT and MAP are converted to a JSON object. j
...to_json(list) Alias for to_json that only accepts STRUCT . json_array(any, ...) Create a JSON array from the values in the argument lists. json_object(key, value, ...) Create a JSON object from key , value pairs in the argument list. Requires an even num...ber of arguments. json_merge_patch(json, json) Merge two JSON documents together. Examples: SELECT to_json('duck'); "duck" SELECT to_json(... - https://man.mtool.work/duckdb/2.0/data/json/creating_json.html
- Struct Functions 8516
- 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
...elds, descending into nested types, and filling missing fields from defaults . row(any, ...) Create a TUPLE containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_contains(struct, entry) Check i...truct) Return the names of the entries of a STRUCT as a list. struct_pack(name := any, ...) Create a STRUCT containing the argument values. The entry name will be the bound variable name. struct_position(struct, entry) Return the index of the entry withi...'list' , and a MAP 's children by the keys 'key' and 'value' . row(any, ...) | Description | Create a TUPLE containing the argument values. | | Example | row(i, i % 4, i / 4) | | Result | (10, 2, 2.5) | struct_concat(structs...) | Description | Merge the... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
DuckDB 2.0 Documentation / man.mtool.work