Results of 1 - 10 of about 31 for Explicit (0.003 sec.)
- Advanced Installation Methods – DuckDB 13119
- 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
...gz For example: http://extensions.duckdb.org/v1.5.6/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...path Extensions extensions directly used httpfs files Downloading building DuckDB buckets ⟩/⟨ example Installing Extension Explicit Path Note compressed remote paths load currently 関連するページ Extension Distribution httpfs Extension for HTTP and S3 Su... - https://man.mtool.work/duckdb/1.3/extensions/advanced_installation_methods.html
- Casting – DuckDB 12505
- 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 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 information 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...ource type to make the binding work. 関連キーワード cast type hello Casting example types casting also throw return syntax explicit expr DuckDB generate series convert behavior instead allows column macros input world addition 関連するページ Typecasting... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Typecasting – DuckDB 11486
- 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
...ta 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 VARCH...AR) 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. Even though a casting operation is supported based on the source and target data type, it does n... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- ATTACH and DETACH Statements – DuckDB 10046
- 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
...he database file.db with the alias inferred from the name ( file ): ATTACH 'file.db' ; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'file.db' AS file_db ; Attach the database file.db in read only mode: ATTACH 'file.db' ( READ_ON...ile.db if inferred database alias file does not yet exist: ATTACH IF NOT EXISTS 'file.db' ; Attach the database file.db if explicit database alias file_db does not yet exist: ATTACH IF NOT EXISTS 'file.db' AS file_db ; Attach the database file2.db as ali...db ( READ_ONLY ); Prior to DuckDB version 1.1.0, it was necessary to specify the READ_ONLY flag for HTTP and S3 endpoints. Explicit Storage Versions DuckDB v1.2.0 introduced the STORAGE_VERSION option , which allows explicilty specifying the storage vers... - https://man.mtool.work/duckdb/1.3/sql/statements/attach.html
- Extensions – DuckDB 9415
- 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
...ons . There are two main methods of making DuckDB perform the installation and loading steps for an installable extension: explicitly and through autoloading . Explicit INSTALL and LOAD In DuckDB extensions can also be explicitly installed and loaded. Bo...th non-autoloadable and autoloadable extensions can be installed this way. To explicitly install and load an extension, DuckDB has the dedicated SQL statements LOAD and INSTALL . For example, to install and lo...ckdb_extensions function can be used to get more information. Autoloading Extensions For many of DuckDB's core extensions, explicitly loading and installing extensions is not necessary. DuckDB contains an autoloading mechanism which can install and load... - https://man.mtool.work/duckdb/1.3/extensions/overview.html
- Excel Extension – DuckDB 9221
- 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
...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/1.3/core_extensions/excel.html
- Android – DuckDB 8606
- 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
...= 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_TOO...ir 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... - https://man.mtool.work/duckdb/1.3/dev/building/android.html
- Data Types – DuckDB 8396
- 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
...d one-byte integer UUID UUID data type VARCHAR CHAR , BPCHAR , TEXT , STRING Variable-length character string Implicit and explicit typecasting is possible between numerous types, see the Typecasting page for details. Nested / Composite Types DuckDB supp...pes, DuckDB performs a delete operation followed by an insert operation. When used in a table with ART indexes (either via explicit indexes or primary keys/unique constraints), this can lead to unexpected constraint violations . Nesting ARRAY , LIST , MA... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Storage Versions and Format – DuckDB 8185
- 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
...ll hold the same data in a universal format as different files. Check EXPORT documentation for more details on the syntax. Explicit Storage Versions DuckDB v1.2.0 introduced the STORAGE_VERSION option , which allows explicitly specifying the storage vers...rk Use Blog In this article Compatibility Backward Compatibility Forward Compatibility How to Move between Storage Formats Explicit Storage Versions Converting between Storage Versions Storage Header Storage Version Table Compression Compression Algorith... - https://man.mtool.work/duckdb/1.3/internals/storage.html
- Timestamp Types – DuckDB 7975
- 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
...guous TIMESTAMP WITH TIME ZONE instants. One possible solution to this is to append UTC offsets to strings, followed by an explicit cast to TIMESTAMP WITH TIME ZONE . Alternatively, a TIMESTAMP WITHOUT TIME ZONE may be created first and then be combined...pecified by the string is stored. Finally, when WITH TIME ZONE and WITHOUT TIME ZONE types are converted to each other via explicit or implicit casts, the translation uses the configured time zone. To use an alternative time zone, the timezone function p... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
DuckDB 1.3 Documentation / man.mtool.work