Results of 1 - 10 of about 60 for input (0.012 sec.)
- Values – DuckDB 13567
- 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
...); 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/1.3/clients/c/value.html
- Spatial Functions – DuckDB 12942
- 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
...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 attemtping 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/1.3/core_extensions/spatial/functions.html
- Complete API – DuckDB 11168
- 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
...); 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/1.3/clients/c/api.html
- Full-Text Search Extension – DuckDB 10499
- 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
...nally, 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_accent...s = 1 , lower = 1 , overwrite = 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' , …, 'text... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- CLI Charting with YouPlot – DuckDB 8856
- 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
.../ Guides / Data Viewers Copy Markdown CLI Charting with YouPlot 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 term...inal. It can accept input from other programs by piping data from stdin . It takes tab-separated (or delimiter of your choice) data and can easily g...ckDB and piped to YouPlot. There are three important steps to doing this. As an example, this is how to read all data from input.json : duckdb -s "SELECT * FROM read_json_auto('input.json')" To prepare the data for YouPlot, write a simple aggregate: d... - https://man.mtool.work/duckdb/1.3/guides/data_viewers/youplot.html
- CSV Import – DuckDB 8667
- 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
...SV Import 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...sing 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....ta 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 F... - https://man.mtool.work/duckdb/1.3/guides/file_formats/csv_import.html
- Enum Functions – DuckDB 8521
- 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
...m_code(enum_value) Returns the 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...he given enum value. 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 of the input enum type as an array. Example enum_range(NULL::mood) Result [sad, ok, happy, anxious] enum_range_boundary(enum, enum) Des... - https://man.mtool.work/duckdb/1.3/sql/functions/enum.html
- Lambda Functions – DuckDB 8332
- 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
...n list_transform(list, lambda(x)) Returns a list that is the result of applying the lambda function to each element of the input list. The return type is defined by the return type of the lambda function. See list_transform examples . list_filter(list..., lambda(x)) Constructs a list from those elements of the input list for which the lambda function returns true . DuckDB must be able to cast the lambda function's return type to BOOL ....The return type of list_filter is the same as the input list's. See list_filter examples . list_reduce(list, lambda(x, y)[, initial_value]) Reduces all elements of the input list... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- C++ API – DuckDB 8187
- 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
...unction The CreateVectorizedFunction() methods register a vectorized UDF such as: /* * This vectorized function copies the input values to the result vector */ template < typename TYPE > static void udf_vectorized ( DataChunk & args , ExpressionState...ECTOR ; // get a raw array from the result auto result_data = FlatVector :: GetData < TYPE > ( result ); // get the solely input vector auto & input = args . data [ 0 ]; // now get an orrified vector VectorData vdata ; input . Orrify ( args . size (),...vdata ); // get a raw array from the orrified input auto input_data = ( TYPE * ) vdata . data ; // handling the data for ( idx_t i = 0 ; i < args . size (); i ++ ) { auto idx... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- Parquet Import – DuckDB 8187
- 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
...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: SELECT * FRO...M 'input.parquet' ; To create a new table using the result from a query, use CREATE TABLE ... AS SELECT statement : CREATE TABLE ne...w_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 SEL... - https://man.mtool.work/duckdb/1.3/guides/file_formats/parquet_import.html
DuckDB 1.3 Documentation / man.mtool.work