Results of 1 - 10 of about 17 for lines (0.003 sec.)
- CSV Import 13173
- 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 =
...ple . TYPE[] default types buffer_size Size of the buffers used to read files, in bytes. Must be large enough to hold four lines and can significantly impact performance. BIGINT 16 * max_line_size columns Column names and types, as a struct (e.g., {'c...'} ). Using this option disables auto detection of the schema. STRUCT (empty) comment Character used to initiate comments. Lines starting with a comment character (optionally preceded by space characters) are completely ignored; other lines containing...y parsing errors encountered. BOOL false max_line_size or maximum_line_size . Not available in the COPY statement. Maximum line size, in bytes. BIGINT 2000000 names or column_names Column names, as a list. See example . VARCHAR[] (empty) new_line New... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Reading Faulty CSV Files 12794
- 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
...ulty lines and the possibility of storing faulty lines in a temporary table to assist users with a data cleaning step. Structural Err...ine with more than two columns would cause this error, e.g., Pedro,01-01-1992,pdet . UNQUOTED VALUE : Quoted values in CSV lines must always be unquoted at the end; if a quoted value remains quoted throughout, it will cause an error. For example, assu...ming our scanner uses quote='"' , the line "pedro"holanda, 01-01-1992 would present an unquoted value error. LINE SIZE OVER MAXIMUM : DuckDB has a parameter that sets the maximum line size a CSV file can have, which by default is set to... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- ODBC Configuration 9880
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
...e of odbc.ini with DuckDB: [DuckDB] Driver = DuckDB Driver Database = /path/to/database.duckdb access_mode = read_only The lines correspond to the following parameters: [DuckDB] : between the brackets is a DSN for the DuckDB. Driver : Describes the dr...with the DuckDB: [ODBC] Trace = yes TraceFile = /tmp/odbctrace [DuckDB Driver] Driver = /path/to/libduckdb_odbc.dylib The lines correspond to the following parameters: [ODBC] : The DM configuration section. Trace : Enables the ODBC trace file using t... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- JSON Export 8880
- To export the data from a table to a JSON file, use the COPY statement: COPY tbl TO 'output.json'; The result of queries can also be directly exported to a JSON file: COPY (SELECT * FROM range(3) tbl(n)) TO 'output.json'; {"n":0} {"n":1} {"
...n":2} The JSON export writes JSON lines by default, standardized as Newline-delimited JSON . The ARRAY option can be used to write a single JSON array object inst... - https://man.mtool.work/duckdb/2.0/guides/file_formats/json_export.html
- Gitignore for DuckDB 8759
- If you work in a Git repository, you may want to configure your Gitignore to disable tracking files created by DuckDB . These potentially include the DuckDB database, write-ahead log, and temporary files. Sample Gitignore Files In the follo
...B databases ( .duckdb , .db , .ddb , etc.). For example, if your DuckDB files use the .duckdb extension, add the following lines to your .gitignore file: *.duckdb* *.wal *.tmp/... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/gitignor...
- Geometry Data Type 8379
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...es: Geometry Type Description Point A single location in space, defined by its coordinates (e.g., longitude and latitude). LineString A sequence of points connected by straight lines, representing a path or route. Polygon A set of closed rings defined...he first ring is the "shell", and "interior" rings represent holes in the polygon. MultiPoint A collection of points. MultiLineString A collection of LineStrings. MultiPolygon A collection of Polygons. GeometryCollection A collection of different geom...etry types, allowing for complex geometries that combine points, lines, and polygons or even other nested geometry collections. The textual representation of geometries uses "Well-Known Text" (... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Relational API 8242
- 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
...[str], keyword-only, default: None Strings that are read as NULL . * skiprows : int, keyword-only, default: None Number of lines to skip at the start of each file. * quotechar : str, keyword-only, default: None Character used to quote values. * escape...r, keyword-only, default: None Format used to parse timestamps. * sample_size : int, keyword-only, default: None Number of lines sampled to detect the dialect and the types. * files_to_sniff : int, keyword-only, default: None Number of files sampled t...t detects the column types; VARCHAR is always one of them. * max_line_size : int, str, keyword-only, default: None Maximum line size, in bytes. * ignore_errors : bool, keyword-only, default: None Skip the lines that fail to parse. * store_rejects : bo... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Full-Text Search 8000
- DuckDB supports full-text search via the fts extension . A full-text index allows for a query to quickly search for all occurrences of individual words within longer text strings. Example: Shakespeare Corpus Here's an example of building a
...ue id column, and the column(s) to index. We will just index the single column text_entry , which contains the text of the lines in the play. PRAGMA create_fts_index('corpus', 'line_id', 'text_entry'); The table is now ready to query using the Okapi B... - https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html
- Benchmark Suite 7879
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...ark 5 0.124102 You can also specify an output file using the --out flag. This will write only the timings (delimited by newlines) to that file. build/release/benchmark/benchmark_runner benchmark/micro/nulls/no_nulls_addition.benchmark --out=timings.ou...y we will benchmark! This is done in the run section, and the restrictions are the same as for a unit test (e.g., no blank lines, etc.) For the FILL benchmark, we want to find all places where the interpolation fails: run SELECT m, k, fill(v) OVER (PA... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
- Building Configuration 7879
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...t it still has debug symbols that make it possible to step through the execution with line number information and D_ASSERT lines are still checked in this build. Binaries of this build mode are significantly faster than those of the debug mode. reldeb... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
DuckDB 2.0 Documentation / man.mtool.work