Results of 1 - 10 of about 46 for Empty (0.005 sec.)
- Excel Import – DuckDB 13089
- 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
...provided, the range is automatically inferred 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 at 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... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- Excel Extension – DuckDB 11579
- 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
...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'... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- CSV Import – DuckDB 11579
- 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
...and types, as a struct (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection. 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...none ). Options are none , gzip , zstd . VARCHAR auto dateformat Date format used when parsing and writing dates. VARCHAR (empty) date_format Alias for dateformat ; only available in the COPY statement. VARCHAR (empty) decimal_separator Decimal separa... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Result Verification – DuckDB 9901
- 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
...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... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- SQL to/from JSON – DuckDB 9809
- 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
...sulting rows. Only one statement at a time is supported for now. 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_..."","query_location":7,"value":{"type":{"id":"INTEGER","type_info":null},"is_null":false,"value":2}}],"from_table":{"type":"EMPTY","alias":"","sample":null,"query_location":18446744073709551615},"where_clause":null,"group_expressions":[],"group_sets":[... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
- COPY Statement – DuckDB 9809
- 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
...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) PRESERVE_ORDER Whether or not to preserve order during the copy operation. Defaults to the value of the preserve_insertio...ne , gzip , zstd . VARCHAR auto DATEFORMAT Specifies the date format to use when writing dates. See Date Format . VARCHAR (empty) DELIM or SEP The character that is written to separate columns within each row. VARCHAR , ESCAPE The character that shoul... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Spatial Functions – DuckDB 9199
- 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
...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...POLYGON 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 --...FromText ( '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 ( 'GEOM... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Map Functions – DuckDB 9016
- 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
...e of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of t...f struct(k, v) for each key-value pair in the map. map_extract(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the key provided in the second parameter must match the type of t...p_keys(map) Return a list of all keys in the map. map_values(map) Return a list of all values in the map. map() Returns an empty map. map[entry] Returns the value for a given key or NULL if the key is not contained in the map. The type of the key prov... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- SQL Quirks – DuckDB 8756
- 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
...yet. Acknowledging these quirks is the best we can do, which is why we have compiled below a list of examples. Aggregating Empty Groups On empty groups, the aggregate functions sum , list , and string_agg all return NULL instead of 0 , [] and '' , res...behavior is inherited by the list aggregate list_sum , but not by the DuckDB original list_dot_product which returns 0 on empty lists. 0 vs. 1-Based Indexing To comply with standard SQL, one-based indexing is used almost everywhere, e.g., array and s...e number because corresponds bytes bits DuckDB indexing integer types it's values extract clause others Standard different empty aggregate functions return instead inherited 関連するページ List Type PostgreSQL Import Overview List Tables PostgreSQL Ex... - https://man.mtool.work/duckdb/1.3/sql/dialect/sql_quirks.html
- Regular Expressions – DuckDB 8573
- 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
...g contains the regexp pattern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set....capturing groups as a struct with corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in...g contains the regexp pattern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set.... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
DuckDB 1.3 Documentation / man.mtool.work