Results of 1 - 10 of about 70 for Empty (0.003 sec.)
- Excel Import 13336
- DuckDB supports reading Excel .xlsx files. However, .xls files are not supported. Importing Excel Sheets Use the read_xlsx function in the FROM clause of a query: SELECT * FROM read_xlsx('test_excel.xlsx'); Alternatively, you can omit the r
...rovided, DuckDB automatically infers the range as the rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. By default, if no range is provided, DuckDB will stop reading the...Excel file when encountering an empty row. But when a range is provided, the default is to read until the end of the range. This behavior can be controlled with...the stop_at_empty parameter: -- Read the first 100 rows, or until the first empty row, whichever comes first SELECT * FROM read_xlsx('test_e... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- CSV Import 11644
- 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 =
...tion and assume all columns are of type VARCHAR . This option is only supported by the read_csv function. BOOL false allow_empty If the file pattern or file list matches no files, return an empty result (with a single empty column of type BOOL ) inste...a struct (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). 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 charac...ters) are completely ignored; other lines containing a comment character are parsed only up to that point. VARCHAR (empty) compression Method used to compress CSV files. By default this is detected automatically from the file extension (e.g., t... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Excel Extension 11250
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...not specified the resulting range will be inferred as rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOOLEAN automatically inferred Whether to stop read...ing the file when an empty row is encountered. If an explicit range option is provided, this is false by default, otherwise true . empty_as_varchar B...OOLEAN false Whether to treat empty cells as VARCHAR instead of DOUBLE when trying to automatically infer column types. SELECT * FROM read_xlsx('test.xlsx', h... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- COPY Statement 9953
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...Note that the size is used as an approximation, and files can be occasionally slightly over the limit. VARCHAR or BIGINT (empty) PARTITION_BY The columns to partition by using a Hive partitioning scheme, see the partitioned writes section . VARCHAR[]...(empty) PARTITION_PATH An expression over the PARTITION_BY columns that computes the output subdirectory for each partition, repl...acing the default col=value Hive layout. The result must be a relative path (no leading / , no .. segments) and non-empty. Requires PARTITION_BY and cannot be combined with HIVE_FILE_PATTERN . See the partitioned writes section . Added in DuckD... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Geometry Data Type 9262
- 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
...Z (30 10 5))'); ---- Invalid Input Error: Failed to parse geometry: Geometry has inconsistent Z/M dimensions at offset 43 Empty Geometries Geometries can also be "empty" (e.g., POINT EMPTY , LINESTRING EMPTY , MULTIPOLYGON EMPTY , etc.) which means t...hey don't contain any vertices. Empty geometries are still valid geometries and can be used in spatial operations, but they are mostly useful for representing t...rations that don't have a valid geometrical representation (e.g., the intersection of two non-overlapping geometries is an empty geometry). Geometry Storage Internally GEOMETRY values are stored as a sequence of bytes, similarly to DuckDB's BLOB types... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- SQL to/from JSON 8867
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...to JSON. If optimize is true , the optimized plan is serialized. json_serialize_sql(varchar, skip_default := boolean, skip_empty := boolean, skip_null := boolean, format := boolean) Scalar Serialize a set of semicolon-separated ( ; ) select statements...f the json_execute_serialized_sql function. The json_serialize_sql(varchar) function takes three optional parameters, skip_empty , skip_null and format that can be used to control the output of the serialized statements. If you run the json_execute_se...T","alias":"","query_location":7,"query_location_length":1,"literal":{"kind":"INTEGER","text":"2"}}],"from_table":{"type":"EMPTY","alias":"","sample":null,"query_location":18446744073709551615,"query_location_length":0},"where_clause":null,"group_expr... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Result Verification 8867
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...kDB test runner does not use or need them internally – therefore, only I should be used to denote columns. NULL Values and Empty Strings Empty lines have special significance for the SQLLogic test runner: they signify an end of the current statement o...r query. For that reason, empty strings and NULL values have special syntax that must be used in result verification. NULL values should use the string NU...LL , and empty strings should use the string (empty) , e.g.: query II SELECT NULL, '' ---- NULL (empty) Error Verification In order to si... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Lance Extension 8642
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...3::BIGINT AS id, 'c'::VARCHAR AS s ) TO '⟨path/to/dataset.lance⟩' ( FORMAT lance, MODE 'append' ); -- Optionally create an empty dataset (schema only) COPY ( SELECT 1::BIGINT AS id, 'x'::VARCHAR AS s WITH NO DATA ) TO 'path/to/empty.lance' ( FORMAT la...nce, MODE 'overwrite', WRITE_EMPTY_FILE true ); To write to s3://... paths, configure a TYPE lance secret for that scope using the Secrets Manager : CREATE S...itten to ⟨namespace_root⟩/⟨table_name.lance⟩ . ATTACH '⟨path/to/dir⟩' AS lance_ns (TYPE lance); -- Schema-only (creates an empty dataset) CREATE TABLE lance_ns.main.my_empty (id BIGINT, s VARCHAR); -- CTAS (writes query results) CREATE TABLE lance_ns.... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
- Spatial Functions 8557
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...Intersects_Extent Returns true if the extent of two geometries intersects ST_IsClosed Check if a geometry is 'closed' ST_IsEmpty Returns true if the geometry is "empty". ST_IsRing Returns true if the geometry is a ring (both ST_IsClosed and ST_IsSimpl...LYGON is returned. * Otherwise if the input collection contains a mix of geometry types, a GEOMETRYCOLLECTION is returned. Empty and NULL geometries are ignored. If all geometries are empty or NULL , a GEOMETRYCOLLECTION EMPTY is returned. Example --..., ST_GeomFromText('LINESTRING(3 4, 5 6)')]); ---- GEOMETRYCOLLECTION (POINT (1 2), LINESTRING (3 4, 5 6)) -- Note that the empty geometry is ignored, so the result is a MULTIPOINT SELECT ST_Collect([ST_Point(1, 2), NULL, ST_GeomFromText('GEOMETRYCOLLE... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Reading Multiple Files 8331
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...found that match the pattern "test/*.parquet" Starting with DuckDB 2.0, the CSV, JSON and Parquet readers accept the allow_empty option, which returns an empty result (with a single empty column of type BOOLEAN ) instead of raising an error: SELECT *...FROM read_parquet('test/*.parquet', allow_empty = true); Alternatively, use the glob function to check whether any files match before reading. Unlike the read functions,...glob returns an empty result instead of raising an error when nothing matches: SELECT count(*) AS matches FROM glob('test/*.parquet'); matches 0... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
DuckDB 2.0 Documentation / man.mtool.work