Results of 1 - 3 of about 3 for unpack (0.001 sec.)
- Star Expression 11886
- Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl; TABLE.* and STRUCT.* The * expression can be prepended by a table name to select only columns from tha
...LUMNS(*) = 'a'; -- equivalent to: x = 'a' AND y = 'a' x y a a To combine conditions using the logical OR operator, you can UNPACK the COLUMNS expression into the variadic greatest function. SELECT * FROM ( SELECT 'a', 'a' UNION ALL SELECT 'a', 'b' UNIO...N ALL SELECT 'b', 'b' ) _(x, y) WHERE greatest(UNPACK(COLUMNS(*) = 'a')); -- equivalent to: x = 'a' OR y = 'a' x y a a a b COLUMNS Expression in DISTINCT ON COLUMNS expressions...also supports passing in a list of column names. SELECT COLUMNS(['id', 'number']) FROM numbers; id number 1 10 2 20 3 NULL Unpacking a COLUMNS Expression By wrapping a COLUMNS expression in UNPACK , the columns expand into a parent expression, much lik... - https://man.mtool.work/duckdb/2.0/sql/expressions/star.html
- JSON Format Settings 8389
- The JSON extension can attempt to determine the format of a JSON file when setting format to auto . Here are some example JSON files and the corresponding format settings that should be used. In each of the below cases, the format setting w
...ile contains records when setting records = auto . When records = true , the JSON extension expects JSON objects, and will unpack the fields of JSON objects into individual columns. Continuing with the same example file, records.json : {"key1":"value1"...', records = true); key1 key2 value1 value1 value2 value2 value3 value3 When records = false , the JSON extension will not unpack the top-level objects, and create STRUCT s instead: SELECT * FROM read_json('records.json', records = false); json {'key1'... - https://man.mtool.work/duckdb/2.0/data/json/format_settings.html
- Troubleshooting of Extensions 7589
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...signed, so their integrity is verified on load regardless of the transport protocol. If successful, this will download and unpack the extension to the default Downloads folder, so that from SQL you can run: INSTALL '~/Downloads/spatial.duckdb_extension... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work