Results of 1 - 10 of about 11 for detects (0.002 sec.)
- Friendly CLI 11931
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- CSV Auto Detection 11220
- 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
...ers as the read_csv function . Any parameter you pass is treated as fixed: the sniffer uses the value you provide and only detects the properties you did not specify. For example, passing ignore_errors = true lets the sniffer skip malformed lines while...it detects the dialect. The auto_detect parameter must be true (its default) for sniff_csv ; passing auto_detect = false results in a... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- CSV Import 10509
- 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 =
...on ( auto_detect ) is enabled by default. Setting an option explicitly does not turn auto-detection off: the sniffer still detects every option you did not specify, and your explicit value overrides the sniffer only for that option. To disable auto-dete...t schema (which matches the order of the columns in the CSV file and uses types that fit the values in the CSV file). COPY detects the CSV's configuration options automatically. CREATE TABLE ontime ( flightdate DATE, uniquecarrier VARCHAR, origincitynam... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- UI Extension 9797
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...ension polls for some information on a background thread. It watches for changes to the list of attached databases, and it detects when you connect to MotherDuck. These checks take very little time to complete, so the default polling interval is short (... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Variant Type 9797
- The VARIANT type stores typed, binary data where each row is self-contained with its own type information. This differs from the JSON type , which is physically stored as text. Because type metadata is embedded per-value, VARIANT provides b
...B's storage was introduced in DuckDB 2.0. When storing VARIANT columns in a DuckDB database file, DuckDB 2.0 automatically detects the common structure of the values and shreds them, i.e., stores the fields that share a type as separate, typed columns.... - https://man.mtool.work/duckdb/2.0/sql/data_types/variant.html
- Subqueries 8357
- Subqueries are parenthesized query expressions that appear as part of a larger, outer query. Subqueries are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery
...CT * FROM Person WHERE NOT EXISTS (FROM interest WHERE interest.PersonId = Person.id); id name 1 Jane DuckDB automatically detects when a NOT EXISTS query expresses an antijoin operation. There is no need to manually rewrite such queries to use LEFT OUT... - https://man.mtool.work/duckdb/2.0/sql/expressions/subqueries.html
- Reading Faulty CSV Files 7646
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...th 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 cannot be cast to the expected schema... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- Loading JSON 7646
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...hen parsing dates. See Date Format VARCHAR iso maximum_depth Maximum nesting depth to which the automatic schema detection detects types. Set to -1 to fully detect nested JSON types BIGINT -1 records Can be one of auto , true , false VARCHAR auto sample... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- PIVOT Statement 7646
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...mplements both the SQL Standard PIVOT syntax and a simplified PIVOT syntax that automatically detects the columns to create while pivoting. PIVOT_WIDER may also be used in place of the PIVOT keyword. For details on how the P... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- FROM and JOIN Clauses 6934
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...LATERAL (SELECT i + 1) t2(j); SELECT * FROM t1, LATERAL (SELECT i + j) t2(k) ORDER BY ALL; i j k 0 1 1 1 2 3 2 3 5 DuckDB detects when LATERAL joins should be used, making the use of the LATERAL keyword optional. Positional Joins When working with data... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
DuckDB 2.0 Documentation / man.mtool.work