Results of 1 - 10 of about 26 for accept (0.002 sec.)
- Securing DuckDB 13952
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...h the database. For example, there is a relational API in Python that allows building queries programmatically. These APIs accept user input such as file paths, table names, column names, and filter expressions. While they don't execute raw SQL strings...es. Example considerations for non-SQL APIs: File paths: Functions like duckdb.read_csv(path) or duckdb.read_parquet(path) accept file paths. An attacker-controlled path could read sensitive files (e.g., /etc/passwd ) or access remote URLs. Table and c...cutable code, unsanitized input could lead to unexpected behavior or information disclosure. Filter expressions: Some APIs accept filter expressions that are compiled into DuckDB expressions, which often support subqueries containing arbitrary SQL. Tre... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Reading Multiple Files 11092
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...using a list parameter, glob pattern matching syntax, or a combination of both. Directory Paths The read_parquet function accepts a local directory path and recursively reads files with the .parquet extension, including files in subdirectories: SELECT...fferent columns, use union_by_name = true as described in combining schemas . List Parameter The read_parquet function can accept a list of filenames as the input parameter. Read three Parquet files and treat them as a single table: SELECT * FROM read_...Error: No files found that match the pattern "test/*.parquet" Starting with DuckDB 2.0, the CSV, JSON and Parquet readers accept the allow_empty option, which returns an empty result (with a single empty column of type BOOLEAN ) instead of raising an... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Write User Defined Functions 10265
- 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
...rom SQL by the name passed to RegisterScalarUDF() : 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, err := duckdb.NewTypeInfo(duckdb.TYPE_ANY) check(err) config := duckdb.ScalarFuncConfig{ V... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
- query and query_table Functions 9455
- The query_table and query functions enable powerful and more dynamic SQL. The query_table function returns the table whose name is specified by its string argument; the query function returns the table obtained by executing the query specif
...ied by its string argument. Both functions only accept constant strings. For example, they allow passing in a table name as a prepared statement parameter: CREATE TABLE my_table... - https://man.mtool.work/duckdb/2.0/guides/sql_features/query_and_query_table_func...
- Lambda Functions 9455
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...cc, x : acc + x Lambda functions enable the use of more complex and flexible expressions in queries. Scalar Functions That Accept Lambda Functions Function Description apply(list, lambda(x)) Alias for list_transform . array_apply(list, lambda(x)) Alias...2], lambda x: list_apply([4], lambda x: x + tbl.x)[1] + x ) FROM tbl; [15, 16] Indexes as Parameters All lambda functions accept an optional extra parameter that represents the index of the current element. This is always the last parameter of the lam... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Window Functions 9455
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...using ORDER BY with general-purpose window functions, but we have extended all of these functions (except dense_rank ) to accept this syntax and use framing to restrict the range that the secondary ordering applies to. -- Compare each athlete's time i...that there is no comma separating the arguments from the ORDER BY clause. Nulls All general-purpose window functions that accept IGNORE NULLS respect nulls by default. This default behavior can optionally be made explicit via RESPECT NULLS . In contra...values unless a FILTER condition excludes those rows, e.g., list(x) FILTER (WHERE x IS NOT NULL) ) ignore nulls and do not accept RESPECT NULLS . For example, sum(column) OVER (ORDER BY time) AS cumulativeColumn computes a cumulative sum where rows wit... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- CLI Charting with YouPlot 8629
- DuckDB can be used with CLI graphing tools to quickly pipe input to stdout to graph your data in one line. YouPlot is a Ruby-based CLI tool for drawing visually pleasing plots on the terminal. It can accept input from other programs by pipi
... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Directly Reading Files 8629
- DuckDB allows directly reading files via the read_text and read_blob functions. These functions accept a filename, a list of filenames, or a glob pattern. They output the content of each file as a VARCHAR or BLOB , respectively, along with
... - https://man.mtool.work/duckdb/2.0/guides/file_formats/read_file.html
- Export to Apache Arrow 8629
- All results of a query can be exported to an Apache Arrow Table using the to_arrow_table function. Alternatively, results can be returned as a RecordBatchReader using the to_arrow_reader function and results can be read one batch at a time.
...he Arrow PyCapsule Interface A relation implements __arrow_c_stream__ of the Arrow PyCapsule interface , so libraries that accept an Arrow stream read it directly: pyarrow.table(rel) , pyarrow.RecordBatchReader.from_stream(rel) and polars.DataFrame(rel... - https://man.mtool.work/duckdb/2.0/guides/python/export_arrow.html
- Command Line Arguments 8232
- 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
...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 example, a... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
DuckDB 2.0 Documentation / man.mtool.work