Results of 1 - 10 of about 125 for varchar (0.006 sec.)
- DuckDB_% Metadata Functions – DuckDB 11438
- 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
...le in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The SQL name of the s...chema that contains the table object that defines this column. VARCHAR schema_oid Internal identifier of the schema object that contains the table of the column. BIGINT table_name The SQL name...of the table that defines the column. VARCHAR table_oid Internal identifier (name) of the table object that defines the column. BIGINT column_name The SQL name of the c... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Information Schema – DuckDB 10750
- 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
...cter_sets : Character Sets Column Description Type Example character_set_catalog Currently not implemented – always NULL . VARCHAR NULL character_set_schema Currently not implemented – always NULL . VARCHAR NULL character_set_name Name of the character...set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the encoding name. VARCH...AR 'UCS' form_of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current database). VARCHA... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Configuration – DuckDB 10025
- 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
...ptions Name Description Type Default value access_mode Access mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ) VARCHAR automatic allocator_background_threads Whether to enable the allocator background thread. BOOLEAN false allocator_bulk_dea...llocation_flush_threshold If a bulk deallocation larger than this occurs, flush outstanding allocations. VARCHAR 512.0 MiB allocator_flush_threshold Peak allocation threshold at which to flush the allocator after completing a task. VAR...directories List of directories/prefixes that are ALWAYS allowed to be queried - even when enable_external_access is false VARCHAR[] [] allowed_paths List of files that are ALWAYS allowed to be queried - even when enable_external_access is false VARCHAR... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- CSV Import – DuckDB 9730
- 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
...ECT * FROM read_csv ( 'flights.csv' , delim = '|' , header = true , columns = { 'FlightDate' : 'DATE' , 'UniqueCarrier' : 'VARCHAR' , 'OriginCityName' : 'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.cs..."SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( FlightDate DATE , UniqueCarrier VARCHAR , OriginCityName VARCHAR , DestCityName VARCHAR ); COPY ontime FROM 'flights.csv' ; Alternatively, create a table without...ere meaningfully applicable, these parameters can also be passed to the COPY statement . Name Description Type Default all_varchar Skip type detection and assume all columns are of type VARCHAR . This option is only supported by the read_csv function. B... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Querying Parquet Metadata – DuckDB 9325
- 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 parquet_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_metadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_rows BIGINT row_group_num_columns BIGINT row_group_bytes BIGINT column_id BIGINT file_of...fset BIGINT num_values BIGINT path_in_schema VARCHAR type VARCHAR stats_min VARCHAR stats_max VARCHAR stats_null_count BIGINT stats_distinct_count BIGINT stats_min_value VARCH...AR stats_max_value VARCHAR compression VARCHAR encodings VARCHAR index_page_offset BIGINT dictionary_page_offset BIGINT data_page_offset BIGINT total... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Relational API – DuckDB 9067
- 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
...connect () rel = duckdb_conn . from_arrow ( example_table ) rel . show () Result ┌──────┬─────────┐ │ id │ text │ │ int8 │ varchar │ ├──────┼─────────┤ │ 1 │ a │ └──────┴─────────┘ from_csv_auto Signature from_csv_auto ( self : duckdb . duckdb . DuckDBP...: Optional[str] Format to parse timestamps. sample_size : Optional[int] Number of rows to sample for schema inference. all_varchar : Optional[bool] Treat all columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_...rel = duckdb_conn . from_csv_auto ( "code_example.csv" ) rel . show () Result ┌───────┬─────────┐ │ id │ text │ │ int64 │ varchar │ ├───────┼─────────┤ │ 1 │ a │ └───────┴─────────┘ from_df Signature from_df ( self : duckdb . duckdb . DuckDBPyConnectio... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Typecasting – DuckDB 8833
- 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
...licit typecasting. Explicit Casting Explicit typecasting is performed by using a CAST expression. For example, CAST(col AS VARCHAR) or col::VARCHAR explicitly cast the column col to VARCHAR . See the cast page for more information. Implicit Casting In m...st operation will succeed at runtime. Deprecated Prior to version 0.10.0, DuckDB allowed any type to be implicitly cast to VARCHAR during function binding. Version 0.10.0 introduced a breaking change which no longer allows implicit casts to VARCHAR . Th...not possible for this particular value. TRY_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 ty... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- DuckLake – DuckDB 8796
- 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
...─────────────┐ │ snapshot_id │ snapshot_time │ schema_version │ changes │ │ int64 │ timestamp with time zone │ int64 │ map(varchar, varchar[]) │ ├─────────────┼────────────────────────────┼────────────────┼──────────────────────────┤ │ 0 │ 2025-05-26 11...snapshots stored in the DuckLake catalog name catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_...time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) ducklake_table_info The ducklake_table_info function returns information on the tables stored in the DuckLake... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
- Reading Faulty CSV Files – DuckDB 8735
- 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
...on, we will go over each error with an example. For the examples, consider the following table: CREATE TABLE people ( name VARCHAR , birth_date DATE ); DuckDB detects the following error types: CAST : Casting errors occur when a column in the CSV file c...ssible solutions: * Override the type for this column manually by setting the type explicitly, e.g., types={'birth_date': 'VARCHAR'} * Set the sample size to a larger value to enable the auto-detection to scan more values, e.g., sample_size=-1 * Use a C...= (DD-MM-YYYY) (Auto-Detected) timestamp_format = (Auto-Detected) null_padding=0 sample_size=20480 ignore_errors=false all_varchar=0 The first block provides us with information regarding where the error occurred, including the line number, the original... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- JSON Processing Functions – DuckDB 8661
- 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
...f path is a LIST , the result will be a LIST of JSON . json_extract_string(json, path) json_extract_path_text ->> Extracts VARCHAR from json at the given path . If path is a LIST , the result will be a LIST of VARCHAR . json_value(json, path) Extracts J...string, however the string must be wrapped in double quotes. json_keys(json[, path]) Returns the keys of json as a LIST of VARCHAR , if json is a JSON object. If path is specified, return the keys of the JSON object at the given path . If path is a LIST..., the result will be LIST of LIST of VARCHAR . json_structure(json) Return the structure of json . Defaults to JSON if the structure is inconsistent (e.g., incompatibl... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
DuckDB 1.3 Documentation / man.mtool.work