Results of 1 - 10 of about 57 for Explicit (0.002 sec.)
- Iceberg Options 11689
- 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
...he requests to the REST Catalog. DEFAULT_TABLE_LOCATION_FROM_NAMESPACE BOOLEAN false If enabled, a CREATE TABLE without an explicit WITH ('location' = …) clause derives the table location as ⟨namespace location⟩/⟨table name⟩ from the namespace's location...property. An explicit WITH ('location' = …) clause still takes precedence, and if the namespace has no location property the behavior is unchang...ode a warehouse or account/catalog identifier. It is normally discovered from the catalog's configuration response; set it explicitly to override. A prefix containing / is split into path components unless ENCODE_ENTIRE_PREFIX is set. NAMESPACE_SEPARATOR... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Casting 11469
- 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
...formation on casting can be found on the typecasting page . Explicit Casting The standard SQL syntax for explicit casting is CAST(expr AS TYPENAME) , where TYPENAME is a name (or alias) of on... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- Typecasting 11234
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...typecasting is performed by using a CAST expression. For example, CAST(col AS VARCHAR) or col::VARCHAR explicitly cast the column col to VARCHAR . See the cast page for more information. Implicit Casting In many situations, the system...n types. The following matrix describes which conversions are supported. When implicit casting is allowed, it implies that explicit casting is also possible. The matrix is generated from the documented DuckDB version by scripts/generate_typecasting_matri...rse, with the notable exception of casts from wide integer or DECIMAL types to FLOAT or DOUBLE , which can lose precision. Explicit-only casts may lose information or fail for particular values. In the matrix below, rows are the source type and columns a... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Advanced Installation Methods 10558
- Downloading Extensions Directly from S3 Downloading an extension directly can be helpful when building a Lambda service or container that uses DuckDB. DuckDB extensions are stored in public S3 buckets, but the directory structure of those b
...gz For example: http://extensions.duckdb.org/v2.0.0/windows_amd64/json.duckdb_extension.gz Installing an Extension from an Explicit Path The INSTALL command can be used with the path to a .duckdb_extension file: INSTALL 'path/to/httpfs.duckdb_extension';...ion.gz files need to be decompressed beforehand. It is also possible to specify remote paths. Loading an Extension from an Explicit Path LOAD can be used with the path to a .duckdb_extension . For example, if the file was available at the (relative) path... - https://man.mtool.work/duckdb/2.0/extensions/advanced_installation_methods.html
- Excel Extension 9662
- 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
...mns. stop_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..._varchar option is set to true , none of the above applies and all cells are read as VARCHAR . When no types are specified explicitly, (e.g., when using the read_xlsx function instead of COPY TO ... FROM '⟨file⟩.xlsx' ) the types of the resulting columns...are inferred based on the first "data" row in the sheet, that is: If no explicit range is given The first row after the header if a header is found or forced by the header option The first non-empty row... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Storage Versions and Format 9662
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...es are created with version 69 , corresponding to v2.0.0. On older versions you can opt in to a newer format by setting an explicit storage version . Warning A file created with the v2.0.0 storage format cannot be opened by DuckDB versions prior to v2.0....0. To write a file that older versions can still read, create it with an explicit storage version . What's New in the v2.0.0 Format New The v2.0.0 storage format, used by default from DuckDB 2.0, introduc...lt (see Compression ); stores row deletions more compactly; and performs stronger corruption validation when reading data. Explicit Storage Versions DuckDB 1.2.0 introduced the STORAGE_VERSION option , which allows explicitly specifying the storage versi... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Comparisons 9428
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...ession IS NOT NULL false if expression is NULL , true otherwise expression NOTNULL alias for IS NOT NULL (non-standard) An explicit collation on any input to BETWEEN applies to the entire BETWEEN expression. This can differ from writing the comparisons s...eparately, where the explicit collation applies only to the comparison that contains it: SELECT 'B' NOT BETWEEN ('A' COLLATE NOCASE) AND 'a' AS between_... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- Android 9207
- DuckDB has experimental support for Android. Please use the latest main branch of DuckDB instead of the stable versions. Building the DuckDB Library Using the Android NDK We provide build instructions for setups using macOS and Android Stud
...E_MAKEFILE=on \ -DANDROID_PLATFORM=${ANDROID_PLATFORM} \ -DLOCAL_EXTENSION_REPO="" \ -DOVERRIDE_GIT_DESCRIBE="" \ -DDUCKDB_EXPLICIT_PLATFORM=${PLATFORM_NAME} \ -DBUILD_UNITTESTS=0 \ -DBUILD_SHELL=1 \ -DANDROID_ABI=${ANDROID_ABI} \ -DCMAKE_TOOLCHAIN_FILE=...bash mkdir build cd build export LDFLAGS="-llog" cmake \ -G "Ninja" \ -DBUILD_EXTENSIONS="${DUCKDB_EXTENSIONS}" \ -DDUCKDB_EXPLICIT_PLATFORM=linux_arm64_android \ -DCMAKE_BUILD_TYPE=Release \ .. cmake --build . --config Release Note that you can also use... - https://man.mtool.work/duckdb/2.0/dev/building/android.html
- COPY Statement 8972
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...1, 2, 3] AS num_list) TO 'numbers.json'; --RETURNS: {"num_list":[1,2,3]} Sets the value of column compression_type to gzip_explicit and outputs the results to compression.json.gz with explicit compression: COPY (SELECT 'gzip_explicit' AS compression_type...) TO 'explicit_compression.json' (FORMAT json, COMPRESSION 'GZIP'); -- RETURNS: {"compression_type":"gzip_explicit"} Sets all values of s... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Command Line 8532
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...ble to 0 : echo "SELECT 42 AS x;" | duckdb -no-agent | cat ┌───────┐ │ x │ │ int32 │ ├───────┤ │ 42 │ └───────┘ Passing an explicit output mode flag, such as -csv or -json , also disables agent mode.... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
DuckDB 2.0 Documentation / man.mtool.work