Results of 1 - 7 of about 7 for candidates (0.003 sec.)
- CSV Import 12486
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...llow the conversion of quoted values to NULL values BOOL true auto_detect Auto detect CSV parameters . BOOL true auto_type_candidates Types that the sniffer uses when detecting column types. The VARCHAR type is always included as a fallback option. See exa...ert them e.g. using the iconv command-line tool : batch iconv -f ISO-8859-2 -t UTF-8 input.csv > input-utf-8.csv auto_type_candidates Details The auto_type_candidates option lets you specify the data types that should be considered by the CSV reader for co...lumn data type detection . Usage example: SELECT * FROM read_csv('csv_file.csv', auto_type_candidates = ['BIGINT', 'DATE']); The default value for the auto_type_candidates option is ['NULL', 'BOOLEAN', 'BIGINT', 'HUGEINT', '... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- CSV Auto Detection 10233
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...R . The set of candidate types that should be considered by the CSV reader can be specified explicitly using the auto_type_candidates option. VARCHAR as the fallback type will always be considered as a candidate type whether you specify it or not. Here are...all additional candidate types that may be specified using the auto_type_candidates option, in order of priority: Types TINYINT SMALLINT INTEGER DECIMAL FLOAT Even though the set of data types that can be a...et of column types that may be specified using the types option is not as limited as the types available for the auto_type_candidates option: any valid type definition is acceptable to the types -option. (To get a valid type definition, use the typeof() fu... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Union Type 9978
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...always be implicitly cast to a UNION if it can be implicitly cast to one 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...will always cast the FLOAT to the INTEGER member before VARCHAR . If the cast still is ambiguous, i.e., there are multiple candidates with the same implicit casting priority, an error is raised. This usually happens when the UNION contains multiple members... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Iceberg Functions 8469
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...ize of the rewritten files. min_file_size_bytes VARCHAR or integer 75% of the target file size Files smaller than this are candidates for rewriting. max_file_size_bytes VARCHAR or integer 180% of the target file size Files larger than this are candidates f... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- WITH Clause 8215
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...in USING KEY CTEs Both UNION and UNION ALL update the union table in the same way: all rows produced by an iteration (the candidates) are applied to the union table, i.e., they insert new keys, overwrite payloads or are combined by the payload aggregates....h UNION , the recursion terminates once no shorter distances are found. With UNION ALL , the query would not terminate, as candidates would continue to be forwarded around the cycle. CREATE TABLE weighted_edges (src INTEGER, dst INTEGER, weight INTEGER); I... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
- Pragmas 7470
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...e with name nonexistent_tbl does not exist!\nDid you mean \"temp.information_schema.tables\"?", "name":"nonexistent_tbl", "candidates":"temp.information_schema.tables", "position":"14", "type":"Table", "error_subtype":"MISSING_ENTRY" } IEEE Floating-Point... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Relational API 6706
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...default: None Column names and types, as a dict of column name to type name; the types are then not detected. * auto_type_candidates : list[str], keyword-only, default: None Types the reader may choose from when it detects the column types; VARCHAR is alw... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work