Results of 1 - 10 of about 79 for input (0.004 sec.)
- Values 12911
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...ar * text , idx_t length ); duckdb_value duckdb_create_bool ( bool input ); duckdb_value duckdb_create_int8 ( int8_t input ); duckdb_value duckdb_create_uint8 ( uint8_t input ); duckdb_value duck...db_create_int16 ( int16_t input ); duckdb_value duckdb_create_uint16 ( uint16_t input ); duckdb_value duckdb_create_int32 ( int32_t input ); duckdb_value...duckdb_create_uint32 ( uint32_t input ); duckdb_value duckdb_create_uint64 ( uint64_t input ); duckdb_value duckdb_create_int64 ( int64_t val ); duckdb_value du... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Spatial Functions 12183
- 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
...rom north) of two points in radian. ST_Boundary Returns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the target distance ST_BuildArea Creates a polygonal geometry by attempting to "fill in" the input geometry. S...xtracts geometries from a GeometryCollection into a typed multi geometry. ST_ConcaveHull Returns the 'concave' hull of the input geometry, containing all of the source input's points, and which can be used to create polygons from points. The ratio par...gon geometry ST_Equals Returns true if the geometries are "equal" ST_Extent Returns the minimal bounding box enclosing the input geometry ST_Extent_Approx Returns the approximate bounding box of a geometry, if available. ST_ExteriorRing Returns the ex... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Full-Text Search Extension 10837
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...ionally, a scalar macro stem is added, which is used internally by the extension. PRAGMA create_fts_index create_fts_index(input_table, input_id, *input_values, stemmer = 'porter', stopwords = 'english', ignore = '(\\.|[^a-z])+', strip_accents = 1, lo...wer = 1, overwrite = 0, incremental = 0) PRAGMA that creates a FTS index for the specified table. Name Type Description input_table VARCHAR Qualified name of specified table, e.g., 'table_name' or 'main.table_name' input_id VARCHAR Column name of d...ocument identifier, e.g., 'document_identifier' input_values... VARCHAR Column names of the text fields to be indexed (vararg), e.g., 'text_field_1' , 'text_field_2' , ..., 'te... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Complete API 10604
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...); duckdb_value duckdb_create_varchar_length ( const char * text , idx_t length ); duckdb_value duckdb_create_bool ( bool input ); duckdb_value duckdb_create_int8 ( int8_t input ); duckdb_value duckdb_create_uint8 ( uint8_t input ); duckdb_value duck...db_create_int16 ( int16_t input ); duckdb_value duckdb_create_uint16 ( uint16_t input ); duckdb_value duckdb_create_int32 ( int32_t input ); duckdb_value...duckdb_create_uint32 ( uint32_t input ); duckdb_value duckdb_create_uint64 ( uint64_t input ); duckdb_value duckdb_create_int64 ( int64_t val ); duckdb_value du... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- CSV Import 9615
- To read data from a CSV file, use the read_csv function in the FROM clause of a query: SELECT * FROM read_csv('input.csv'); Alternatively, you can omit the read_csv function and let DuckDB infer it from the extension: SELECT * FROM 'input.c
...using the result from a query, use CREATE TABLE ... AS SELECT statement : CREATE TABLE new_tbl AS SELECT * FROM read_csv('input.csv'); We can use DuckDB's optional FROM -first syntax to omit SELECT * : CREATE TABLE new_tbl AS FROM read_csv('input.csv...data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT * FROM read_csv('input.csv'); Alternatively, the COPY statement can also be used to load data from a CSV file into an existing table: COPY tbl FR...OM 'input.csv'; For additional options, see the CSV import reference and the COPY statement documentation .... - https://man.mtool.work/duckdb/2.0/guides/file_formats/csv_import.html
- Securing DuckDB 9162
- 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
...nt, and threat model. If you plan to embed DuckDB in your application, also consult the "Embedding DuckDB" page. Untrusted Input Untrusted SQL Input Warning Treat SQL in DuckDB like code in Bash or Python. Do not execute SQL from untrusted sources wit...ng should not just be considered for security purposes, but also for preventing denial of service (DoS) attacks: malicious inputs can easily cause DuckDB to consume excessive resources such as memory, disk, CPU, or network. Untrusted Non-SQL Input War...ning Even non-SQL input into DuckDB can easily have unintended consequences. When building security-sensitive applications with DuckDB, always mak... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- CLI Charting with YouPlot 8969
- 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
...can read data from any format DuckDB supports and pipe it to YouPlot. Follow these three steps: First, read all data from input.json : batch duckdb -s "SELECT * FROM read_json('input.json')" To prepare the data for YouPlot, write a simple aggregate:...batch duckdb -s "SELECT date, sum(purchases) AS total_purchases FROM read_json('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10" Finally, wrap the SELECT in the COPY ... TO function with an output location o...e query in CSV format with a header: batch duckdb -s "COPY (SELECT date, sum(purchases) AS total_purchases FROM read_json('input.json') GROUP BY 1 ORDER BY 2 DESC LIMIT 10) TO '/dev/stdout' WITH (FORMAT csv, HEADER)" Connecting DuckDB to YouPlot Final... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/youplot.html
- Enum Functions 8612
- 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
...m_value) Returns the (0-based) numeric value backing the given enum value. enum_first(enum) Returns the first value of the input enum type. enum_last(enum) Returns the last value of the input enum type. enum_range(enum) Returns all values of the input...e. | | Example | enum_code('happy'::mood) | | Result | 2 | enum_first(enum) | Description | Returns the first value of the input enum type. | | Example | enum_first(NULL::mood) | | Result | sad | enum_last(enum) | Description | Returns the last value...of the input enum type. | | Example | enum_last(NULL::mood) | | Result | anxious | enum_range(enum) | Description | Returns all values... - https://man.mtool.work/duckdb/2.0/sql/functions/enum.html
- JSON Import 8571
- To read data from a JSON file, use the read_json function in the FROM clause of a query: SELECT * FROM read_json('input.json'); To create a new table using the result from a query, use CREATE TABLE AS from a SELECT statement: CREATE TABLE n
...ew_tbl AS SELECT * FROM read_json('input.json'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELECT...* FROM read_json('input.json'); Alternatively, the COPY statement can also be used to load data from a JSON file into an existing table: COPY tbl...FROM 'input.json'; For additional options, see the JSON Loading reference and the COPY statement documentation .... - https://man.mtool.work/duckdb/2.0/guides/file_formats/json_import.html
- Parquet Import 8434
- To read data from a Parquet file, use the read_parquet function in the FROM clause of a query: SELECT * FROM read_parquet('input.parquet'); Alternatively, you can omit the read_parquet function and let DuckDB infer it from the extension: SE
...LECT * FROM 'input.parquet'; To create a new table using the result from a query, use the CREATE TABLE ... AS SELECT statement : CREATE TABLE...new_tbl AS SELECT * FROM read_parquet('input.parquet'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement: INSERT INTO tbl SELE...CT * FROM read_parquet('input.parquet'); Alternatively, use the COPY statement to load data from a Parquet file into an existing table: COPY tbl FROM 'i... - https://man.mtool.work/duckdb/2.0/guides/file_formats/parquet_import.html
DuckDB 2.0 Documentation / man.mtool.work