Results of 1 - 10 of about 33 for length (0.007 sec.)
- Integration with Ibis – DuckDB 13187
- 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
...enguins . fetch (). to_pyarrow (), overwrite = True ) # Output: DatabaseTable : penguins species string island string bill_length_mm float64 bill_depth_mm float64 flipper_length_mm int64 body_mass_g int64 sex string year int64 You can now see the examp...t with. penguins = con . table ( "penguins" ) penguins # Output: DatabaseTable: penguins species string island string bill_length_mm float64 bill_depth_mm float64 flipper_length_mm int64 body_mass_g int64 sex string year int64 Ibis is lazily evaluated,..._pandas to get the first few rows of the table as a pandas DataFrame. penguins . head (). to_pandas () species island bill_length_mm bill_depth_mm flipper_length_mm body_mass_g sex year 0 Adelie Torgersen 39.1 18.7 181.0 3750.0 male 2007 1 Adelie Torge... - https://man.mtool.work/duckdb/1.3/guides/python/ibis.html
- Text Functions – DuckDB 12577
- 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
...80. base64(blob) Converts a blob to a base64 encoded string. bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a string . char_length(string) Number of characters in string . character_length(string) Number...left_grapheme(string, count) Extracts the left-most count grapheme clusters. len(string) Number of characters in string . length(string) Number of characters in string . length_grapheme(string) Number of grapheme clusters in string . like_escape(strin...tion of first occurrence of search_string in string , counting from 1. Returns 0 if no match found. substr(string, start[, length]) Extracts substring starting from character start up to the end of the string. If optional argument length is set, extrac... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Bitstring Functions – DuckDB 11230
- 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
...his section describes functions and operators for examining and manipulating BITSTRING values. Bitstrings must be of equal length when performing the bitwise operands AND, OR and XOR. When bit shifting, the original length of the string is preserved. B...scalar functions for BIT type. Name Description bit_count(bitstring) Returns the number of set bits in the bitstring. bit_length(bitstring) Returns the number of bits in the bitstring. bit_position(substring, bitstring) Returns first starting index of...specified substring within bits, or zero if it's not present. The first (leftmost) bit is indexed 1. bitstring(bitstring, length) Returns a bitstring of determined length. get_bit(bitstring, index) Extracts the nth bit from bitstring; the first (leftm... - https://man.mtool.work/duckdb/1.3/sql/functions/bitstring.html
- Text Types – DuckDB 9930
- 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
...racters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string VARCHAR(n) CHAR(n) , BPCHAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum length...n has no effect and is only provided for compatibility Specifying a Length Limit Specifying the length for the VARCHAR , STRING , and TEXT types is not required and has no effect on the system. Spe...cifying the length will not improve performance or reduce storage space of the strings in the database. These variants variant is supported f... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Spatial Functions – DuckDB 9224
- 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
...d and ST_IsSimple). ST_IsSimple Returns true if the geometry is simple ST_IsValid Returns true if the geometry is valid ST_Length Returns the length of the input line geometry ST_Length_Spheroid Returns the length of the input geometry in meters, using...ellipsoidal model of the earth ST_LineInterpolatePoint Returns a point interpolated along a line at a fraction of total 2D length. ST_LineInterpolatePoints Returns a multi-point interpolated along a line at a fraction of total 2D length. ST_LineMerge "...e a LINESTRING_2D from a WKB encoded blob ST_LineSubstring Returns a substring of a line between two fractions of total 2D length. ST_M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of a geometry ST_MMin Returns... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Complete API – DuckDB 8711
- 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
...d * ptr ); idx_t duckdb_vector_size (); bool duckdb_string_is_inlined ( duckdb_string_t string ); uint32_t duckdb_string_t_length ( duckdb_string_t string ); const char * duckdb_string_t_data ( duckdb_string_t * string ); Date Time Timestamp Helpers du...ar ( duckdb_prepared_statement prepared_statement , idx_t param_idx , const char * val ); duckdb_state duckdb_bind_varchar_length ( duckdb_prepared_statement prepared_statement , idx_t param_idx , const char * val , idx_t length ); duckdb_state duckdb_...bind_blob ( duckdb_prepared_statement prepared_statement , idx_t param_idx , const void * data , idx_t length ); duckdb_state duckdb_bind_null ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); Execute Prepared Stat... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Values – DuckDB 8663
- 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
...lue ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const char * text , idx_t length ); duckdb_value duckdb_create_bool ( bool input ); duckdb_value duckdb_create_int8 ( in...kdb_value duckdb_create_interval ( duckdb_interval input ); duckdb_value duckdb_create_blob ( const uint8_t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); bool du...he null-terminated string Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_varchar_length Creates a value from a string Syntax duckdb_value duckdb_create_varchar_length ( const char * text , idx_t length ); Param... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Vectors – DuckDB 8567
- 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
...., <= 12 bytes ) or a pointer to the string data if it is longer than 12 bytes. typedef struct { union { struct { uint32_t length ; char prefix [ 4 ]; char * ptr ; } pointer ; struct { uint32_t length ; char inlined [ 12 ]; } inlined ; } value ; } duck...db_string_t ; The length can either be accessed directly, or the duckdb_string_is_inlined can be used to check if a string is inlined. Decimals Dec...L . Lists Lists are nested types that contain a single child type, repeated x times per row. Think of them like a variable-length array in C. The way to access list data using vectors is to access the child vector using the duckdb_list_vector_get_child... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- List Functions – DuckDB 8470
- 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
...atenate a list of lists into a single list. This only flattens one level of the list (see examples ). len(list) Return the length of the list. list_aggregate(list, name) Executes the aggregate function name on the elements of list . See the List Aggreg...nce(list1, list2) Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length. list_distinct(list) Removes all duplicates and NULL values from a list. Does not preserve the original order. list_dot_pr...ask_list applied as a mask to the value_list . list_zip(list_1, list_2, ...[, truncate]) Zips k LIST s to a new LIST whose length will be that of the longest list. Its elements are structs of k elements from each list list_1 , …, list_k , missing eleme... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Array Type – DuckDB 8198
- 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
...Data Types Copy Markdown Array Type 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,...LIST and STRUCT types. Arrays can be used to store vectors such as word embeddings or image embeddings. To store variable-length lists, use the LIST type . See the data types overview for a comparison between nested data types. The ARRAY type in Postg...reSQL allows variable-length fields. DuckDB's ARRAY type is fixed-length. Creating Arrays Arrays can be created using the array_value(expr, ...) functi... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
DuckDB 1.3 Documentation / man.mtool.work