Results of 1 - 8 of about 8 for transform (0.007 sec.)
- Lambda Functions – DuckDB 12887
- 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
...concat ( s , 'DB' ), 'duck' ) lambda acc , x : acc + x Scalar Functions That Accept Lambda Functions Name Description list_transform(list, lambda(x)) Returns a list that is the result of applying the lambda function to each element of the input list. The...return type is defined by the return type of the lambda function. See list_transform examples . list_filter(list, lambda(x)) Constructs a list from those elements of the input list for which the lambda funct...e next list element. The lambda function has an optional initial_value argument. See list_reduce examples or details. list_transform(list, lambda(x)) Description Returns a list that is the result of applying the lambda function to each element of the inpu... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- JSON Processing Functions – DuckDB 10627
- 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
...json_group_structure ( j ) FROM example2 ; {"family":"VARCHAR","species":["VARCHAR"],"coolness":"DOUBLE","hair":"BOOLEAN"} Transforming JSON to Nested Types In many cases, it is inefficient to extract values from JSON one-by-one. Instead, we can “extract”...all values at once, transforming JSON to the nested types LIST and STRUCT . Function Description json_transform(json, structure) Transform json accordin...g to the specified structure . from_json(json, structure) Alias for json_transform . json_transform_strict(json, structure) Same as json_transform , but throws an error when type casting fails. from_json_s... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Spatial Functions – DuckDB 9706
- 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
...a text description of the PROJ library version that is being used by this instance of DuckDB. ST_Affine Applies an affine transformation to a geometry. ST_Area Compute the area of a geometry. ST_Area_Spheroid Returns the area of a geometry in meters, usi...velope rectangular polygons from specified zoom level and tile indices. ST_Touches Returns true if the geometries touch ST_Transform Transforms a geometry between two coordinate systems ST_Union Returns the union of two geometries ST_VoronoiDiagram Return...ne ( geom GEOMETRY , a DOUBLE , b DOUBLE , d DOUBLE , e DOUBLE , xoff DOUBLE , yoff DOUBLE ) Description Applies an affine transformation to a geometry. For the 2D variant, the transformation matrix is defined as follows: | a b xoff | | d e yoff | | 0 0 1... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- List Functions – DuckDB 8368
- 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
...ments of the list. See the Sorting Lists section for more details about the sorting order and the NULL sorting order. list_transform(list, lambda) Returns a list that is the result of applying the lambda function to each element of the input list. See the...ut the sorting order and the NULL sorting order. Example list_sort([3, 6, 1, 2]) Result [1, 2, 3, 6] Alias array_sort list_transform(list, lambda) Description Returns a list that is the result of applying the lambda function to each element of the input l...ist. See the Lambda Functions page for more details. Example list_transform([4, 5, 6], x -> x + 1) Result [5, 6, 7] Aliases array_transform , apply , list_apply , array_apply list_unique(list) Descr... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- SELECT Clause – DuckDB 8061
- 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
...use, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that transform the output, as well as aggregates and window functions. Examples Select all columns from the table called table_name : SEL...ith arrays , lists , or structs . The unnest function strips one level of nesting from the type. For example, INTEGER[] is transformed into INTEGER . STRUCT(a INTEGER, b INTEGER) is transformed into a INTEGER, b INTEGER . The unnest function can be used t...o transform nested types into regular scalar types, which makes them easier to operate on. 関連キーワード table clause addresses colum... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Avro Extension – DuckDB 7591
- 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
...tion will expose the contents of the Avro file as a DuckDB table. You can then use any arbitrary SQL constructs to further transform this table. File IO The read_avro function is integrated into DuckDB's file system abstraction, meaning you can read Avro... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- SELECT Statement – DuckDB 7591
- 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
...use, logically the expressions here are executed only at the end. The SELECT clause can contain arbitrary expressions that transform the output, as well as aggregates and window functions. The DISTINCT keyword ensures that only unique tuples are returned.... - https://man.mtool.work/duckdb/1.3/sql/statements/select.html
- Python Client API – DuckDB 7356
- 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
...can be found at Relational API page . execute ( self : duckdb.duckdb.DuckDBPyRelation ) → duckdb.duckdb.DuckDBPyRelation ¶ Transform the relation into a result set Detailed examples can be found at Relational API page . explain ( self : duckdb.duckdb.Duck... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work