Results of 1 - 10 of about 16 for declared (0.003 sec.)
- SQLite Extension 13516
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...ckDB must deduce a specific column type mapping. DuckDB follows SQLite's type affinity rules with a few extensions. If the declared type contains the string INT then it is translated into the type BIGINT If the declared type of the column contains any of...the strings CHAR , CLOB , or TEXT then it is translated into VARCHAR . If the declared type for a column contains the string BLOB or if no type is specified then it is translated into BLOB . If the declared ty...pe for a column contains any of the strings REAL , FLOA , DOUB , DEC or NUM then it is translated into DOUBLE . If the declared type is DATE , then it is translated into DATE . If the declared type contains the string TIME , then it is translated int... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Information Schema 11592
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...the column. VARCHAR 'DECIMAL(18, 2)' character_maximum_length If data_type identifies a character or bit string type, the declared maximum length; NULL for all other data types or if no maximum length was declared. INTEGER 255 character_octet_length If...ximum possible length in octets (bytes) of a datum; NULL for all other data types. The maximum octet length depends on the declared character maximum length (see above) and the character encoding. INTEGER 1073741824 numeric_precision If data_type identif...ies a numeric type, this column contains the (declared or implicit) precision of the type for this column. The precision indicates the number of significant digits. For all othe... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Write User Defined Functions 10795
- 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
...Function(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") .withParameters(double.class, doub...than in a local variable. The apply below streams a bounded integer series in chunks. It also dispatches on each column's declared type with DuckDBWritableVector.getType() , which is convenient when the same routine populates columns of different types:...n string or the connection properties. Projection Pushdown By default a table function is asked to produce every column it declared in bind , even when the query selects only a few of them. Call withProjectionPushdown() on the builder to let DuckDB tell... - https://man.mtool.work/duckdb/2.0/clients/java/functions.html
- Overview 8698
- Installation To use the DuckDB C API, download the libduckdb archive for your platform. The latest stable version of the DuckDB C API is 2.0.0. DuckDB implements a custom C API modeled somewhat following the SQLite C API. The API is contain
...s predecessor. Among others, it exposes components such as file systems and table functions to extensions. The C API v2 is declared in the duckdb_v2.h header. Extensions that target it include duckdb_extension_v2.h instead of duckdb_extension.h ; an exte... - https://man.mtool.work/duckdb/2.0/clients/c/overview.html
- Import Data 8543
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...g is the name of the target UNION member — append that member's value, then endUnion() . The following row targets a table declared as CREATE TABLE nested_tbl (point STRUCT(x INTEGER, y INTEGER), value UNION(num INTEGER, str VARCHAR)) : try (var appender...lue; each entry is written as a key/value pair, and a null map is appended as SQL NULL . The following row targets a table declared as CREATE TABLE map_tbl (m MAP(VARCHAR, INTEGER)) : try (var appender = conn.createAppender("map_tbl")) { appender.beginRo... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Appender 8543
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...lves the table once, when the appender is created, the way SQL resolves a table name. It appends to the table's columns in declared order and skips generated columns. append_row takes one value per column, and append_rows takes any iterable of rows. Valu..., DELETE or MERGE INTO . A type is anything the Types API accepts, such as "INTEGER" , duckdb.sqltypes.INTEGER or int . A declared column that the statement does not read is allowed. DataFrames and other Python objects named in source or in the statemen... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- Text Types 8387
- In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string
...alues or simply strings. At runtime, string values are constructed in one of the following ways: referencing columns whose declared or implied type is the text data type string literals casting expressions to a text type applying a string operator , or i... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- INSERT Statement 8231
- The INSERT statement inserts new data into a table. Examples Insert the values 1, 2, 3 into tbl : INSERT INTO tbl VALUES (1), (2), (3); Insert the result of a query into a table: INSERT INTO tbl SELECT * FROM other_tbl; Insert values into t
...BY NAME . Each column not present in the explicit or implicit column list will be filled with a default value, either its declared default value or NULL if there is none. If the expression for any column is not of the correct data type, automatic type c...OSITION] The order that values are inserted into the columns of the table is determined by the order that the columns were declared in. That is, the values supplied by the VALUES clause or query are associated with the column list left-to-right. This is... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
- CREATE MACRO Statement 8057
- 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
...e may be present, but not both. The macro name is followed by parentheses. If the macro has parameters , then they must be declared within the parentheses. The AS keyword appears after the right parenthesis but before the expression The TABLE keyword may...named parameters must appear "at the back". By definition, positional parameters are passed in the same order as they were declared. But named parameters can appear in any order (provided they appear after any of the positional parameters). Examples Scal... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Full-Text Search Extension 7589
- 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
...in the FTS index with triggers after inserts and deletes on the input table. Requires the document identifier column to be declared NOT NULL or PRIMARY KEY . Defaults to 0 This PRAGMA builds the index under a newly created schema. The schema will be name... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
DuckDB 2.0 Documentation / man.mtool.work