Results of 1 - 10 of about 85 for range (0.002 sec.)
- Excel Import 12363
- 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
...'test_excel.xlsx', sheet = 'Sheet1'); By default, the first sheet is loaded if no sheet is specified. Importing a Specific Range To select a specific range of cells, use the range parameter with a string in the format A1:B2 , where A1 is the top-left...cell and B2 is the bottom-right cell: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'A1:B2'); For example, to skip the first 5 rows: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'A5:Z'); To skip the...first 5 columns: SELECT * FROM read_xlsx('test_excel.xlsx', range = 'E:Z'); If no range parameter is provided, DuckDB automatically infers the range as the rectangular region of cells betw... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_import.html
- Create Synthetic Data 12228
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...s page shows each building block with a runnable example. Generating Rows range functions hash functions, e.g., hash , md5 , sha256 the Faker Python package via the Python function API using cross produ...cts (Cartesian products) range and generate_series The range functions turn a start, stop, and step into a table of rows, which is the usual starting poi...nt for a synthetic dataset: SELECT i FROM range(1, 4) t(i); ┌───────┐ │ i │ │ int64 │ ├───────┤ │ 1 │ │ 2 │ │ 3 │ └───────┘ range excludes the stop value, while generate_... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Enum Functions 11890
- This section describes functions and operators for examining and manipulating ENUM values . The examples assume an enum type created as: CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy', 'anxious'); These functions can take NULL or a specific
...ons return a value that depends only on the type of the argument, and not on its value. The functions enum_code() and enum_range_boundary() are exceptions; they return a value that depends on the argument value, as well as its type. Name Description e...(enum) Returns the first value of the input enum type. enum_last(enum) Returns the last value of the input enum type. enum_range(enum) Returns all values of the input enum type as an array. enum_range_boundary(enum, enum) Returns the range between the...scription | Returns the last value of the input enum type. | | Example | enum_last(NULL::mood) | | Result | anxious | enum_range(enum) | Description | Returns all values of the input enum type as an array. | | Example | enum_range(NULL::mood) | | Resu... - https://man.mtool.work/duckdb/2.0/sql/functions/enum.html
- Set Operations 10107
- Set operations allow queries to be combined according to set operation semantics . Set operations refer to the UNION [ALL] , INTERSECT [ALL] and EXCEPT [ALL] clauses. The vanilla variants use set semantics, i.e., they eliminate duplicates,
...mantics, therefore it performs duplicate elimination, i.e., only unique rows will be included in the result. SELECT * FROM range(2) t1(x) UNION SELECT * FROM range(3) t2(x); x 2 1 0 UNION ALL (Bag Semantics) UNION ALL returns all rows of both queries...following bag semantics, i.e., without duplicate elimination. SELECT * FROM range(2) t1(x) UNION ALL SELECT * FROM range(3) t2(x); x 0 1 0 1 2 UNION [ALL] BY NAME The UNION [ALL] BY NAME clause can be use...NTERSECT (Set Semantics) Vanilla INTERSECT performs duplicate elimination, so only unique rows are returned. SELECT * FROM range(2) t1(x) INTERSECT SELECT * FROM range(6) t2(x); x 0 1 INTERSECT ALL (Bag Semantics) INTERSECT ALL follows bag semantics,... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/setops.html
- Excel Extension 9620
- 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
...her to ignore errors and silently replace cells that can't be cast to the corresponding inferred column type with NULL 's. range VARCHAR automatically inferred The range of cells to read, in spreadsheet notation. For example, A1:B2 reads the cells fro...m A1 to B2. If 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 r..._at_empty BOOLEAN automatically inferred Whether to stop reading 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 BOOLEAN false Whether to treat empty cells... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- List Functions 8999
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...ist_n , missing elements are replaced with NULL . If truncate is set, all lists are truncated to the smallest list length. range(start[, stop][, step]) Creates a list of values between start and stop - the stop parameter is exclusive. reduce(list, lam...7)] | | Example 3 | list_zip([1, 2], [3, 4], [5, 6, 7], true) | | Result | [(1, 3, 5), (2, 4, 6)] | | Alias | array_zip | range(start[, stop][, step]) | Description | Creates a list of values between start and stop - the stop parameter is exclusive....| | Example | range(2, 5, 3) | | Result | [2] | repeat(list, count) | Description | Repeats the list count number of times. | | Example | repe... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Window Functions 8999
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...ns, but we have extended all of these functions (except dense_rank ) to accept this syntax and use framing to restrict the range that the secondary ordering applies to. -- Compare each athlete's time in an event with the best time to date SELECT event...ws on either side ( preceding or following ) of the current row . The distance can be specified as a number of rows , as a range of values using the partition's ordering value and a distance, or as a number of groups (sets of rows with the same sort v...clause in the OVER specification. This distance can either be specified as an integral number of ROWS or GROUPS , or as a RANGE delta expression. It is invalid for a frame to start after it ends. For a RANGE specification, there must be only one orde... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- Indexes 8174
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...t chunk. Thus, we throw a constraint violation. CREATE TABLE my_table (i INTEGER PRIMARY KEY); INSERT INTO my_table SELECT range FROM range(3_000); UPDATE my_table SET i = i + 1; Constraint Error: Duplicate key "i: 2048" violates primary key constrain...hat could look like in the command line client. CREATE TABLE my_table (i INTEGER PRIMARY KEY); INSERT INTO my_table SELECT range FROM range(3_000); BEGIN; CREATE TEMP TABLE tmp AS SELECT i FROM my_table; DELETE FROM my_table; INSERT INTO my_table SELE... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Numeric Types 7972
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...R , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHORT - 2...size in bits following the C/C++ convention. The type integer is the common choice, as it offers the best balance between range, storage size, and performance. The SMALLINT type is generally only used if disk space is at a premium. The BIGINT and HUG...EINT types are designed to be used when the range of the integer type is insufficient. Variable-Length Integers The previously mentioned integer types all have in common th... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Prepared Statements 7837
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
...used to identify the parameter The returned string should be freed using duckdb_free . Returns NULL if the index is out of range for the provided prepared statement. Syntax const char * duckdb_parameter_name ( duckdb_prepared_statement prepared_statem...urns the parameter type for the parameter at the given index. Returns DUCKDB_TYPE_INVALID if the parameter index is out of range or the statement was not successfully prepared. Syntax duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_...gical_type Returns the logical type for the parameter at the given index. Returns nullptr if the parameter index is out of range or the statement was not successfully prepared. The return type of this call should be destroyed with duckdb_destroy_logic... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
DuckDB 2.0 Documentation / man.mtool.work