Results of 1 - 10 of about 40 for accepts (0.001 sec.)
- Creating JSON 12669
- 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
...son_quote(any) Alias for to_json . array_to_json(list) Alias for to_json that only accepts LIST . row_to_json(list) Alias for to_json that only accepts STRUCT . json_array(any, ...) Create a JSON array from the va... - https://man.mtool.work/duckdb/2.0/data/json/creating_json.html
- Spark API 12388
- The DuckDB Spark API implements the PySpark API , allowing you to use the familiar Spark API to interact with DuckDB. All statements are translated to DuckDB's internal plans using our relational API and executed using DuckDB's query engine
...), Row(age=45, location='Seattle'), Row(age=23, location='Seattle'), Row(age=56, location='Seattle')] createDataFrame also accepts a pandas DataFrame, which needs pandas to be installed. Contribution Guidelines The experimental Spark API accepts bug fix... - https://man.mtool.work/duckdb/2.0/clients/python/spark_api.html
- Reading Multiple Files 11795
- 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...k, NY Los Angeles, CA NULL flights3.csv 1988-01-03 New York, NY Los Angeles, CA AA flights4.csv The filename argument also accepts a string (e.g., filename = 'input_file' ). When provided, the string is used as the name of the added column. This is usef...Find Filenames The glob pattern matching syntax can also be used to search for filenames using the glob table function. It accepts one parameter: the path to search (which may include glob patterns). Search the current directory for all files. SELECT *... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Reference 10032
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...g over SSL. Client Queries Function Description quack_query(uri, query, ...) Run query on remote uri , stream result back. Accepts the named parameters token , disable_ssl , ssl_fingerprint , client_id and heartbeat_timeout , which behave like the ATTAC...quack_query_by_name(catalog, query) Run query against an already-attached Quack catalog (used by ⟨catalog⟩.query() ). Also accepts the named parameters use_transaction and refresh_catalog (both BOOLEAN ). quack_connection_id(catalog) Return the server-i...ing Type Default Description quack_server_max_connections UBIGINT 1024 Maximum number of concurrent connections the server accepts. Beyond this, new connections are refused. quack_server_keep_alive_timeout UBIGINT 300 Seconds an idle keep-alive connecti... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Import from Numpy 9439
- It is possible to query Numpy arrays from DuckDB. There is no need to register the arrays manually – DuckDB can find them in the Python process by name thanks to replacement scans . For example: import duckdb import numpy as np columns = {
...duckdb.sql("SELECT * FROM columns").fetchall()) [(1, 9.0), (2, 8.0), (3, 7.0)] Each array supplies one column. DuckDB also accepts a two-dimensional array, treating each outer array as a column. Transpose an array whose outer dimension represents rows b... - https://man.mtool.work/duckdb/2.0/guides/python/import_numpy.html
- Pragmas 9142
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...lock_ids BIGINT[] Empty unless persistent New As of DuckDB 2.0, when pragma_storage_info is called as a table function, it accepts an include_segment_info boolean parameter. When set to true , the result contains an additional segment_info VARCHAR colum...ntage of the total system memory: SET memory_limit = '60%'; New As of DuckDB 2.0, max_memory (and its alias memory_limit ) accepts a percentage of the total system memory. The percentage must be between 0 and 100 and is computed relative to the total sy...ier versions. By default, profiling collects all metrics. To collect only a subset, use the tracked_metrics setting, which accepts a list of metric glob patterns. A metric is collected if its name matches any of the patterns. The default value, ['*'] ,... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Multiple Connections 8846
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...h (expected) transaction conflicts. statement maybe can be used to deal with these situations. statement maybe essentially accepts both a success, and a failure with a specific error message. concurrentloop i 1 10 statement maybe CREATE OR REPLACE TABLE... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- CONNECT and DISCONNECT Statements 8846
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISC
...s on the PostgreSQL server DISCONNECT; Syntax CONNECT { ⟨attached_database⟩ | '⟨connection_string⟩' }; DISCONNECT; CONNECT accepts either the alias of a database attached with ATTACH , or a connection string for a remote database. While a connection is... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- CSV Auto Detection 8565
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...with a single row. Besides the commonly used sample_size parameter, which configures the number of rows sampled, sniff_csv accepts the same named parameters as the read_csv function . Any parameter you pass is treated as fixed: the sniffer uses the valu...rameter must be true (its default) for sniff_csv ; passing auto_detect = false results in an error. In addition, sniff_csv accepts a force_match ( BOOLEAN ) parameter that is not available in read_csv . FROM sniff_csv('my_file.csv'); FROM sniff_csv('my_... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Handle Results 8269
- Overview DuckDB is columnar, and beyond reading a result set row by row through database/sql , the Go client can exchange whole results with Apache Arrow as a stream of record batches, and register an Arrow stream as a queryable view. Both
...at a time. log.Printf("%d rows", record.NumRows()) } if err := reader.Err(); err != nil { log.Fatal(err) } QueryContext() accepts bound parameters as trailing arguments, the same as database/sql queries . Registering an Arrow Stream as a View An Arrow... - https://man.mtool.work/duckdb/2.0/clients/go/result_handling.html
DuckDB 2.0 Documentation / man.mtool.work