Results of 1 - 10 of about 19 for thrown (0.002 sec.)
- Map Functions 15214
- Name Description cardinality(map) Return the size 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 ke
...y provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging the input maps . On key collision the value is taken from the last...in the map. The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_extract_value(map, key) Returns the value for a given key or NULL if the key is not contained in the map. The type of...the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_from_entries(STRUCT(k, v)[]) Returns a map created from the entries of the array. map_keys(map) Return a list of all... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- Bitstring Functions 9528
- This section describes functions and operators for examining and manipulating BITSTRING values. Bitstrings must be of equal length when performing the bitwise operands AND, OR and XOR. When bit shifting, the original length of the string is
...h distinct position defined in arg . All positions must be within the range [ min , max ] or an Out of Range Error will be thrown. bit_and(arg) | Description | Returns the bitwise AND operation performed on all bitstrings in a given expression. | | Exa...h distinct position defined in arg . All positions must be within the range [ min , max ] or an Out of Range Error will be thrown. | | Example | bitstring_agg(A, 1, 42) |... - https://man.mtool.work/duckdb/2.0/sql/functions/bitstring.html
- Troubleshooting 9323
- Curl Request Fails Problem When trying to attach to an Iceberg REST Catalog endpoint, DuckDB returns the following error: IO Error: Curl Request to '/v1/oauth/tokens' failed with error: 'URL using bad/illegal format or missing URL' Solution
...: SHOW ALL TABLES; Failed to query https://s3tables.us-east-2.amazonaws.com/iceberg/v1/arn:aws:s3tables:... http error 403 thrown. Message: {"message":"The security token included in the request is invalid."} Solution Use the duckdb_secrets() function... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/troubleshooting.html
- Python Function API 8742
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
...ior for NULL values by setting null_handling = 'special' . exception_handling (optional): By default, when an exception is thrown from the Python function, the query fails with an error that names it. Users can disable this behavior, and instead return...b.sql("SELECT return_str_or_none('')").fetchall() print(res) [(None,)] Exception Handling By default, when an exception is thrown from the Python function, the query fails with a duckdb.InvalidInputException that names the Python exception. If you want... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Parquet Encryption 8742
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...256', column_keys: {key256: ['col0', 'col1']} }); However, this is unsupported at the moment and will cause an error to be thrown (for now): Not implemented Error: Parquet encryption_config column_keys not yet implemented Performance Implications Note... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- IN Operator 8742
- The IN operator checks containment of the left expression inside the collection on the right hand side (RHS). Supported collections on the RHS are tuples, lists, and maps, as well as subqueries that return a single column. The single-column
...ple: SELECT 42 IN (SELECT unnest([32, 42, 52]) AS x); true If the subquery returns more than one column, a Binder Error is thrown: SELECT 42 IN (SELECT unnest([32, 42, 52]) AS x, 'a' AS y); Binder Error: Subquery returns 2 columns - expected 1 IN Strin... - https://man.mtool.work/duckdb/2.0/sql/expressions/in.html
- Casting 8537
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
...not be successfully performed. For example, trying to cast the string 'hello' to an INTEGER will result in an error being thrown. SELECT CAST('hello' AS INTEGER); Conversion Error: Could not convert string 'hello' to INT32 The exact behavior of the ca... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- Map Type 8349
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...lue function or bracket notation: SELECT MAP {'key1': 5, 'key2': 43}['key1']; 5 If the key has the wrong type, an error is thrown. If it has the correct type but is merely not contained in the map, a NULL value is returned: SELECT MAP {'key1': 5, 'key2... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- ORDER BY Clause 8349
- ORDER BY is an output modifier. Logically it is applied near the very end of the query (just prior to LIMIT or OFFSET , if present). The ORDER BY clause sorts the rows on the sorting criteria in either ascending or descending order. In addi
...he beginning or to the end. The ORDER BY clause may contain one or more expressions, separated by commas. An error will be thrown if no expressions are included, since the ORDER BY clause should be removed in that situation. The expressions may begin w... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- Utility Functions 8144
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...The file content is first validated to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. replace_type(value, source_type, target_typ...The file content is first validated to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. | | Example | read_text('hello.txt') | | Re... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
DuckDB 2.0 Documentation / man.mtool.work