Results of 1 - 10 of about 25 for target (0.005 sec.)
- EXPORT and IMPORT DATABASE Statements – DuckDB 14878
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...fic directory. The IMPORT DATABASE command allows you to then read the contents again. Examples Export the database to the target directory 'target_directory' as CSV files: EXPORT DATABASE 'target_directory' ; Export to directory 'target_directory', us...ing the given options for the CSV serialization: EXPORT DATABASE 'target_directory' ( FORMAT csv , DELIMITER '|' ); Export to directory 'target_directory', tables serialized as Parquet: EXPORT DA...TABASE 'target_directory' ( FORMAT parquet ); Export to directory 'target_directory', tables serialized as Parquet, compressed with ZSTD,... - https://man.mtool.work/duckdb/1.3/sql/statements/export.html
- Union Type – DuckDB 10677
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ontaining the type. Any UNION can also be implicitly cast to another UNION if the source UNION members are a subset of the target's (if the cast is unambiguous). UNION uses the member types' VARCHAR cast functions when casting to VARCHAR : SELECT u FRO...'t be implicitly cast to any of their member types in general, since the information in the other members not matching the target type would be “lost”. If you want to coerce a UNION into one of its members, you should use the union_extract function exp...ne of the UNION member types. If there are multiple candidates, the built in implicit casting priority rules determine the target type. For example, a FLOAT → UNION(i INTEGER, v VARCHAR) cast will always cast the FLOAT to the INTEGER member before VARC... - https://man.mtool.work/duckdb/1.3/sql/data_types/union.html
- Spatial Functions – DuckDB 10328
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ts 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 attemtping to "fill in" the input geometry. ST_Centroid Returns the...he geom1 "covers" geom2 ST_Crosses Returns true if geom1 "crosses" geom2 ST_DWithin Returns if two geometries are within a target distance of each-other ST_DWithin_GEOS Returns if two geometries are within a target distance of each-other ST_DWithin_Sph...eroid Returns if two POINT_2D's are within a target distance in meters, using an ellipsoidal model of the earths surface ST_Difference Returns the "difference" between two ge... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- INSERT Statement – DuckDB 9896
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...vior: INSERT INTO tbl BY POSITION VALUES ( 5 , 42 ); To use a different order, column names can be provided as part of the target, for example: CREATE TABLE tbl ( a INTEGER , b INTEGER ); INSERT INTO tbl ( b , a ) VALUES ( 5 , 42 ); Adding BY POSITION...d2 )); INSERT OR REPLACE INTO t1 VALUES ( 1 , 2 , 3 ); INSERT OR REPLACE INTO t1 VALUES ( 1 , 2 , 4 ); Defining a Conflict Target A conflict target may be provided as ON CONFLICT (conflict_target) . This is a group of columns that an index or uniquenes...s/key constraint is defined on. If the conflict target is omitted, or PRIMARY KEY constraint(s) on the table are targeted. Specifying a conflict target is optional unless using... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- Typecasting – DuckDB 9547
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t_value / [...] / MAP ). Casting Operations Matrix Values of a particular data type cannot always be cast to any arbitrary target data type. The only exception is the NULL value – which can always be converted between types. The following matrix descri...d, it implies that explicit casting is also possible. Even though a casting operation is supported based on the source and target data type, it does not necessarily mean the cast operation will succeed at runtime. Deprecated Prior to version 0.10.0, Du..._CAST can be used to convert the value into NULL instead of throwing an error. Varchar The VARCHAR type acts as a univeral target: any arbitrary value of any arbitrary type can always be cast to the VARCHAR type. This type is also used for displaying v... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Node.js Client (Neo) – DuckDB 8186
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ezoneOffsetInMinutes = reader . getColumns ()[ 0 ][ 0 ]; Append To Table await connection . run ( `create or replace table target_table(i integer, v varchar)` ); const appender = await connection . createAppender ( ' target_table ' ); appender . append.... endRow (); appender . closeSync (); // also flushes Append Data Chunk await connection . run ( `create or replace table target_table(i integer, v varchar)` ); const appender = await connection . createAppender ( ' target_table ' ); const chunk = Duc...completion, wrap in a reader, and read at least // the given number of rows. (Rows are read in chunks, so more than // the target may be read.) const reader = await connection . runAndReadUntil ( sql , targetRowCount ); const reader = await connection... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
- Utility Functions – DuckDB 8186
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...es and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whether or not we can implicitly cast from the types of the source value to the target value. checkpoint(database)...column) Description Return the name of the column. Example alias(column1) Result column1 can_cast_implicitly(source_value, target_value) Description Whether or not we can implicitly cast from the types of the source value to the target value. Example c... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Text Functions – DuckDB 8086
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...end arguments are interpreted as the beginning or end of the list respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the...x and returns a row for each part. repeat(string, count) Repeats the string count number of times. replace(string, source, target) Replaces any occurrences of the source with target in string . reverse(string) Reverses the string . right(string, count)...end of the list respectively. Negative values are accepted. Example 'DuckDB'[:4] Result Duck Alias array_slice string LIKE target Description Returns true if the string matches the like specifier (see Pattern Matching ). Example 'hello' LIKE '%lo' Resu... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- ADBC Client – DuckDB 7837
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...a statement. (AdbcStatement*, const char*, const char*, AdbcError*) StatementSetOption(&adbc_statement, ADBC_INGEST_OPTION_TARGET_TABLE, "TABLE_NAME", &adbc_error) Functions related to query execution: Function name Description Arguments Example Statem...want to insert to, bind the stream and then execute the query. StatementSetOption ( & adbc_statement , ADBC_INGEST_OPTION_TARGET_TABLE , "AnswerToEverything" , & adbc_error ); StatementBindStream ( & adbc_statement , & arrow_stream , & adbc_error ); S...= nil { return fmt . Errorf ( "failed to set ingest mode: %w" , err ) } if err := stmt . SetOption ( adbc . OptionKeyIngestTargetTable , "temp_table" ); err != nil { return fmt . Errorf ( "failed to set ingest target table: %w" , err ) } if err := stmt... - https://man.mtool.work/duckdb/1.3/clients/adbc.html
- Multiple Python Threads – DuckDB 7837
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e process) # Pass in the same connection as an argument for i in range ( write_thread_count ): threads . append ( Thread ( target = write_from_thread , args = ( duckdb_con ,), name = 'write_thread_' + str ( i ))) for j in range ( read_thread_count ): t...hreads . append ( Thread ( target = read_from_thread , args = ( duckdb_con ,), name = 'read_thread_' + str ( j ))) # Shuffle the threads to simulate a mix o... - https://man.mtool.work/duckdb/1.3/guides/python/multiple_threads.html
DuckDB 1.3 Documentation / man.mtool.work