Results of 1 - 10 of about 14 for Construct (0.003 sec.)
- Interval Functions 14984
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...izes an interval so that units that overflow their range are carried over into the next larger unit. to_centuries(integer) Construct a century interval. to_days(integer) Construct a day interval. to_decades(integer) Construct a decade interval. to_hours(i...nteger) Construct an hour interval. to_microseconds(integer) Construct a microsecond interval. to_millennia(integer) Construct a millennium...interval. to_milliseconds(integer) Construct a millisecond interval. to_minutes(integer) Construct a minute interval. to_months(integer) Construct a month interval. to... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Combining Schemas 9085
- Examples Read a set of CSV files combining columns by position: SELECT * FROM read_csv('flights*.csv'); Read a set of CSV files combining columns by name: SELECT * FROM read_csv('flights*.csv', union_by_name = true); Combining Schemas When
...ave the same schema. If the schema of the files differs, you might want to use the union_by_name option to allow DuckDB to construct the schema by reading all of the names instead. Below is an example of how both methods work. Union by Position By default...es, CA 1988-01-02 AA New York, NY Los Angeles, CA 1988-01-03 AA New York, NY Los Angeles, CA This is equivalent to the SQL construct UNION ALL . Union by Name If you are processing multiple files that have different schemas, perhaps because columns have b...NULL 1988-01-02 New York, NY Los Angeles, CA NULL 1988-01-03 New York, NY Los Angeles, CA AA This is equivalent to the SQL construct UNION ALL BY NAME . Using the union_by_name option increases memory consumption.... - https://man.mtool.work/duckdb/2.0/data/multiple_files/combining_schemas.html
- Timestamp with Time Zone Functions 8524
- This section describes functions and operators for examining and manipulating TIMESTAMP WITH TIME ZONE (or TIMESTAMPTZ ) values . See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In th
...ym for the current_localtimestamp() function call. timezone(text, timestamp) Use the date parts of the timestamp in GMT to construct a timestamp in the given time zone. Effectively, the argument is a “local” time. timezone(text, timestamptz) Use the date...parts of the timestamp in the given time zone to construct a timestamp. Effectively, the result is a “local” time. current_localtime() | Description | Returns a TIME whose GMT bin v...Result | 2022-12-17 08:47:56.497 | timezone(text, timestamp) | Description | Use the date parts of the timestamp in GMT to construct a timestamp in the given time zone. Effectively, the argument is a “local” time. | | Example | timezone('America/Denver',... - https://man.mtool.work/duckdb/2.0/sql/functions/timestamptz.html
- Appender 8489
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...d INTEGER, name VARCHAR)"); Appender appender(con, "people"); appender.AppendRow(1, "Mark"); Rows can also be individually constructed using the BeginRow , EndRow , and Append methods. This is done internally by AppendRow , and hence has the same performa...ow is a short example: con.Query("CREATE TABLE dates (d DATE, t TIME, ts TIMESTAMP)"); Appender appender(con, "dates"); // construct the values using the Date/Time/Timestamp types // (this is the most efficient approach) appender.AppendRow( Date::FromDate..., 1, 1), Time::FromTime(1, 1, 1, 0), Timestamp::FromDatetime(Date::FromDate(1992, 1, 1), Time::FromTime(1, 1, 1, 0)) ); // construct duckdb::Value objects appender.AppendRow( Value::DATE(1992, 1, 1), Value::TIME(1, 1, 1, 0), Value::TIMESTAMP(1992, 1, 1, 1... - https://man.mtool.work/duckdb/2.0/data/appender.html
- Multiple Connections 8332
- 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
...thread. If we want to run code from multiple connections concurrently over multiple threads, we can use the concurrentloop construct. The queries in concurrentloop will be run concurrently on separate threads at the same time. concurrentloop i 0 10 statem... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- EXPORT and IMPORT DATABASE Statements 8279
- The EXPORT DATABASE command allows you to export the contents of the database to a specific directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory target_direc
...database. It contains any CREATE SCHEMA , CREATE TABLE , CREATE VIEW and CREATE SEQUENCE commands that are necessary to re-construct the database. Warning In DuckDB 2.0.0, triggers are not included in the export, and COPY FROM DATABASE does not copy them... - https://man.mtool.work/duckdb/2.0/sql/statements/export.html
- Conversion between DuckDB and Python 8174
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...urned as datetime.date.max and -infinity as datetime.date.min . bytes bytes converts to BLOB by default. When it's used to construct a Value object of type BIT , it maps to BIT instead, and its bytes are read as the characters 0 and 1 , as in duckdb.Value...e could not convert the object ... to the desired target type . tuple tuple converts to LIST by default, when it's used to construct a Value object of type STRUCT it will convert to STRUCT instead. NumPy Objects numpy.ndarray and numpy.datetime64 are conv... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Array Type 8174
- An ARRAY column stores fixed-sized arrays. All fields in the column must have the same length and the same underlying type. Arrays are typically used to store arrays of numbers, but can contain any uniform data type, including ARRAY , LIST
...ds. DuckDB's ARRAY type is fixed-length. Creating Arrays Arrays can be created using the array_value(expr, ...) function . Construct with the array_value function: SELECT array_value(1, 2, 3); You can always implicitly cast an array to a list (and use lis... - https://man.mtool.work/duckdb/2.0/sql/data_types/array.html
- Map Type 8174
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...keys, but each value may have a different type. See the data types overview for a comparison between nested data types. To construct a MAP , use the bracket syntax preceded by the MAP keyword. Creating Maps A map with VARCHAR keys and INTEGER values. This... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- Spatial Functions 8069
- 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
...eturns the geometry as a GeoJSON fragment This does not return a complete GeoJSON document, only the geometry fragment. To construct a complete GeoJSON document or feature, look into using the DuckDB JSON extension in conjunction with this function. This...lot faster than using the ST_Read() OSM driver, however it only outputs the raw OSM data (Nodes, Ways, Relations), without constructing any geometries. For simple node entities (like PoI's) you can trivially construct POINT geometries, but it is also poss...ible to construct LINESTRING and POLYGON geometries by manually joining refs and nodes together in SQL, although with available memory usual... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work