Results of 1 - 9 of about 9 for args (0.005 sec.)
- Python Client API 14038
- 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
...d from_arrow ( arrow_object : object ) → DuckDBPyRelation Create a relation object from an Arrow object. from_csv_auto ( * args : object , ** kwargs : object ) → DuckDBPyRelation Create a relation object from the CSV file in ‘name'. from_df ( df : ob...relation object from the DataFrame in df. from_parquet ( path_or_buffer : object , binary_as_string : bool = False , ** kwargs : Any ) → DuckDBPyRelation Create a relation object from the Parquet path(s) or file-like object(s) in ‘path_or_buffer'. f...and runs the DML over them at each flush query_progress ( self ) → float Query progress of pending operation read_csv ( * args : object , ** kwargs : object ) → DuckDBPyRelation Create a relation object from the CSV file in ‘name'. read_json ( path_... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- CREATE MACRO Statement 8628
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...c) with different function bodies. CREATE MACRO add_x (a, b) AS a + b, (a, b, c) AS a + b + c; SELECT add_x(21, 42) AS two_args, add_x(21, 42, 21) AS three_args; two_args three_args 63 84 CREATE OR REPLACE MACRO is_maximal (a TINYINT) AS a = 2^7 - 1,...t, stop) AS TABLE (SELECT * FROM range(start, stop)); SELECT count(*) AS one_arg FROM tbl_range(3); SELECT count(*) AS two_args FROM tbl_range(3, 8); The first call returns 3 , the second returns 5 . Syntax Macros allow you to create shortcuts for co... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Dot Commands 8430
- 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
...hange 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 .singleline Set single-line...all⟩ Controls the start-up text displayed when launching the CLI. Set this as the first line in ~/.duckdbrc .system ⟨CMD⟩ ⟨ARGS...⟩ Run CMD with ARGS... in a system shell .tables ⟨TABLE⟩ List tables matching LIKE pattern TABLE with column names, type... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Multiple Python Threads 8430
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
...n the same connection as an argument for i in range(write_thread_count): threads.append(Thread(target = write_from_thread, args = (duckdb_con,), name = 'write_thread_' + str(i))) for j in range(read_thread_count): threads.append(Thread(target = read_...from_thread, args = (duckdb_con,), name = 'read_thread_' + str(j))) # Shuffle the threads to simulate a mix of readers and writers random.se... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Expression API 8340
- The Expression class represents an instance of an expression . Why Would I Use the Expression API? Use expressions to build filters and computed columns in Python. They are useful when column names or conditions depend on your code. import
...pression(name) lit(value) ConstantExpression(value) when(condition).then(value) CaseExpression(condition, value) fn(name, *args) FunctionExpression(name, *args) star(exclude=...) StarExpression(exclude=...) sql_expr(text) SQLExpression(text) coalesce...n This expression contains a function call. It is built from the function name and any number of arguments, with fn(name, *args) . An argument that is a plain string is a value, so fn('upper', 's') passes the text s ; use col('s') for the column. imp... - https://man.mtool.work/duckdb/2.0/clients/python/expression.html
- Relational API 8340
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...│ varchar │ ├──────┼─────────┤ │ 1 │ a │ └──────┴─────────┘ from_csv_auto from_csv_auto(self: _duckdb.DuckDBPyConnection, *args: object, **kwargs: object) -> DuckDBPyRelation Alias of read_csv() . from_df from_df(self: _duckdb.DuckDBPyConnection, df:...─┘ from_parquet from_parquet(self: _duckdb.DuckDBPyConnection, path_or_buffer: object, binary_as_string: bool = False, **kwargs: Any) -> DuckDBPyRelation Alias of read_parquet() . from_query from_query(self: _duckdb.DuckDBPyConnection, query: object,...', params: object = None) -> DuckDBPyRelation | None Alias of sql() . read_csv read_csv(self: _duckdb.DuckDBPyConnection, *args: object, **kwargs: object) -> DuckDBPyRelation Create a relation object from the CSV file in 'name'. The options other tha... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Write User Defined Functions 8304
- 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
...the client's table_udf example : type incrementTableUDF struct { tableSize int64 currentRow int64 } func bindTableUDF(namedArgs map[string]any, args ...any) (duckdb.RowTableSource, error) { return &incrementTableUDF{ currentRow: 0, tableSize: args[0]... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- Write User Defined Functions 8178
- 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
...0) .register(conn); SELECT java_weighted_sum(2.5, 4.0); Variadic Arguments For a variable number of arguments, call withVarArgs() to declare the element type and withVarArgsFunction() to supply the implementation. The callback receives the variadic a...rguments as an Object[] . withVarArgs() has to be set before withVarArgsFunction() , and the object-argument withFunction() overloads cannot be combined with va...rargs. import java.sql.Connection; import java.sql.DriverManager; import org.duckdb.DuckDBColumnType; import org.duckdb.DuckDBFu... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Python API 8088
- Installation To use the DuckDB Python client, visit the Python installation page . The latest stable version of the DuckDB Python client is 2.0.0. Installation The DuckDB Python API can be installed using pip : pip install duckdb . Please s
...ql("SELECT count(*) FROM numbers WHERE n % 2 = 0").fetchall()) results = [] threads = [threading.Thread(target=count_even, args=(con.cursor(), results)) for _ in range(4)] for thread in threads: thread.start() for thread in threads: thread.join() pri... - https://man.mtool.work/duckdb/2.0/clients/python/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work