Results of 1 - 10 of about 55 for Arguments (0.005 sec.)
- Python Client API 15522
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...er expression API. One argument is one member, so a list given as one argument is compared whole; its elements are several arguments, and asking whether a list-typed column holds a value is fn(“list_contains”, …) . isnotin ( * values : object ) → Expressi...on The negation of isin , taking the same arguments. isnotnull ( ) → Expression is_not_null , under the name of the earlier expression API. isnull ( ) → Expression is_null ,...* args : object , ** named : object ) → Expression Any SQL function by name, a tuple for a schema-qualified one, with the arguments treated as anywhere else. A keyword argument passes by name: fn(“round”, col(“x”), precision=1) is round(“x”, “precision”... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Array Functions 11782
- All LIST functions work with the ARRAY data type . Additionally, several ARRAY -native functions are also supported. Array-Native Functions Function Description array_cosine_distance(array1, array2) Computes the cosine distance between two
...f the same size. The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cosine_similarity(array1, array2) Computes the cosine similarity between two arrays of the same size. The array ele...ments cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_cross_product(array, array) Computes the cross product of two arrays of size 3. The array elements cannot be NULL ....f the same size. The array elements cannot be NULL . The arrays can have any size as long as the size is the same for both arguments. array_dot_product(array1, array2) Alias for array_inner_product . array_inner_product(array1, array2) Computes the inner... - https://man.mtool.work/duckdb/2.0/sql/functions/array.html
- PREPARE, EXECUTE, and DEALLOCATE Statements 9638
- The PREPARE statement creates a prepared statement for later execution. The EXECUTE statement runs it with optional arguments. The DEALLOCATE statement removes it. For details about auto-incremented, positional, and named parameters, see Pr
...erson WHERE starts_with(name, $name_start) AND age >= $minimum_age; Syntax EXECUTE Execute a prepared statement with named arguments: EXECUTE query_person(name_start := 'B', minimum_age := 40); Execute a prepared statement with positional arguments: EXECU... - https://man.mtool.work/duckdb/2.0/sql/statements/prepare.html
- Write User Defined Functions 9565
- 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
...s called. The simplest functions map directly to a Java functional interface. Pick the overload that matches the number of arguments and, for primitives, their type: withFunction(Supplier) , withFunction(Function) , and withFunction(BiFunction) take zero,...one, or two boxed ( Object ) arguments. withIntFunction() , withLongFunction() , and withDoubleFunction() take a unary or binary operator over INTEGER , BIGINT ,...turnType(int.class) .withIntFunction(x -> x + 1) .register(conn); } SELECT java_add_one(41); The binary overloads take two arguments of the same type, declared with withParameters() : DuckDBFunctions.scalarFunction() .withName("java_weighted_sum") .withPa... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Command Line Arguments 9032
- 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 dat...s 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 default quack secret. If this secret does not exist yet, -ser...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 exa... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Write User Defined Functions 8648
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...rScalarUDF() : SELECT my_length('hello world'); Set VariadicTypeInfo in the config to accept a variable number of trailing arguments. The field takes a duckdb.TypeInfo , so use duckdb.NewTypeInfo(duckdb.TYPE_ANY) to accept arguments of any type: anyType,...in the FROM clause. It is described by a duckdb.RowTableFunction , whose Config declares the argument types and whose BindArguments callback is invoked once per call to bind the arguments and return a table source . The table source drives execution thro...rr := duckdb.NewTypeInfo(duckdb.TYPE_BIGINT) check(err) udf := duckdb.RowTableFunction{ Config: duckdb.TableFunctionConfig{Arguments: []duckdb.TypeInfo{t}}, BindArguments: bindTableUDF, } check(duckdb.RegisterTableUDF(conn, "increment", udf)) rows, err :=... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- ADBC Client 8485
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...Substrait plans are not supported. In this section, we will describe the main functions that exist in ADBC, along with the arguments they take and provide examples for each function. Database Set of functions that operate on a database. Function name Desc...ription Arguments Example DatabaseNew Allocate a new (but uninitialized) database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseNe...Connection A set of functions that create and destroy a connection to interact with a database. Function name Description Arguments Example ConnectionNew Allocate a new (but uninitialized) connection. (AdbcConnection*, AdbcError*) AdbcConnectionNew(&adbc... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
- MySQL Import 8190
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...tring used by ATTACH is a PostgreSQL-style connection string ( not a MySQL connection string!). It is a list of connection arguments provided in {key}={value} format. Below is a list of valid arguments. Any options not provided are replaced by their defau... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- PostgreSQL Import 8101
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...as if it was a regular database. The first parameter of ATTACH is the PostgreSQL connection string , a list of connection arguments provided in {key}={value} format. Below is a list of valid arguments. Name Description Default host Name of host to connec... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- SQL to/from JSON 8027
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...gth":0,"function_name":"+","order_bys":{"type":"ORDER_MODIFIER"},"distinct":false,"is_operator":true,"export_state":false,"arguments":[{"expression":{"class":"CONSTANT","type":"VALUE_CONSTANT","query_location":7,"query_location_length":1,"literal":{"kind"...gth":0,"function_name":"+","order_bys":{"type":"ORDER_MODIFIER"},"distinct":false,"is_operator":true,"export_state":false,"arguments":[{"expression":{"class":"COLUMN_REF","type":"COLUMN_REF","query_location":21,"query_location_length":1,"column_names":["a...NCTION","type":"FUNCTION","query_location":9,"function_name":"+","order_bys":{"type":"ORDER_MODIFIER"},"is_operator":true,"arguments":[{"expression":{"class":"CONSTANT","type":"VALUE_CONSTANT","query_location":7,"query_location_length":1,"literal":{"kind"... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
DuckDB 2.0 Documentation / man.mtool.work