Results of 1 - 8 of about 8 for naming (0.003 sec.)
- PIVOT Statement 11983
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...T Syntax The full syntax diagram is below, but the simplified PIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: PIVOT ⟨dataset⟩ ON ⟨columns⟩ USING ⟨values⟩ GROUP BY ⟨rows⟩ ORDER BY ⟨columns_with_order_directions⟩ LIMIT...ny arbitrary non-aggregating expression may be used. In this case, concatenating with an underscore is used to imitate the naming convention the PIVOT clause uses when multiple ON columns are provided (like in the prior example). PIVOT cities ON countr...on in the USING clause. It will be appended to the generated column names after an underscore ( _ ). This makes the column naming convention much cleaner when multiple expressions are included in the USING clause. In this example, both the sum and max... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- Iceberg Options 11242
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...s which will be explicitly passed formatted into filenames in the logic described below. Working with Alternative Metadata Naming Conventions The iceberg extension can handle different metadata naming conventions by specifying them as a comma-delimited...z , the table can be read via the follow statement: SELECT * FROM iceberg_snapshots( 'data/iceberg/alternative_metadata_gz_naming', version = '2', version_name_format = 'rev-%s.metadata.json%s', metadata_compression_codec = 'gzip' ); “Guessing” Metadat... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Files Created by DuckDB 10103
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...f this file is executed when starting the DuckDB CLI client . The commands can be both dot command and SQL statements. The naming of this file follows the ~/.bashrc and ~/.zshrc “run commands” files. Yes Only used by CLI ~/.duckdb_history History file,... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- Deploy as Native Image 8983
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...one of two ways to make it available to the executable. Option 1: Embed the Library in the Executable Add a resource entry naming your platform's library, either in a configuration directory passed via -H:ConfigurationFileDirectories or under META-INF/... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- S3 API Support 7844
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...://⟨your-bucket⟩/partitioned' ( FORMAT parquet, PARTITION_BY (⟨part_col_a⟩, ⟨part_col_b⟩), OVERWRITE_OR_IGNORE true ); The naming scheme of the written files looks like this: s3://⟨your-bucket⟩/partitioned/part_col_a=⟨val⟩/part_col_b=⟨val⟩/data_⟨thread... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Unnesting 7844
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...ost value. This is particularly useful when working with complex nested data structures, as it maintains the structure and naming convention of the original data. The parameter can also be used in conjunction with the max_depth parameter, allowing more... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- UNPIVOT Statement 7844
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...Syntax The full syntax diagram is below, but the simplified UNPIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: UNPIVOT ⟨dataset⟩ ON ⟨column(s)⟩ INTO NAME ⟨name_column_name⟩ VALUE ⟨value_column_name(s)⟩ ORDER BY ⟨colum... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Python Client API 6344
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...Expression ( lhs : str | Expression | tuple [ str | Expression , ... ] , rhs : object ) → Expression lambda lhs: rhs , lhs naming one parameter or a tuple of them, for functions such as list_transform . duckdb. last_value ( subject : Expression , / , *...n. duckdb. star ( exclude : ColumnNames = () , rename : _Renames | None = None ) → Expression * , optionally dropping or renaming columns; exclude=”id” drops the one column id . duckdb. StarExpression ( * , exclude : Iterable [ str | Expression ] | Non... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work