Results of 1 - 10 of about 11 for Apple (0.002 sec.)
- Integration with Polars 14029
- Polars is a DataFrames library built in Rust with bindings for Python and Node.js. It uses Apache Arrow's columnar format as its memory model. DuckDB can read Polars DataFrames and convert query results to Polars DataFrames. It does this in
...d afterwards. import duckdb import polars as pl df = pl.DataFrame( { "A": [1, 2, 3, 4, 5], "fruits": ["banana", "banana", "apple", "apple", "banana"], "B": [5, 4, 3, 2, 1], "cars": ["beetle", "audi", "beetle", "beetle", "beetle"], } ) duckdb.sql("SELE...Results of con.execute() have no .pl() method. df = duckdb.sql(""" SELECT 1 AS id, 'banana' AS fruit UNION ALL SELECT 2, 'apple' UNION ALL SELECT 3, 'mango'""" ).pl() print(df) shape: (3, 2) ┌─────┬────────┐ │ id ┆ fruit │ │ --- ┆ --- │ │ i32 ┆ str │...╞═════╪════════╡ │ 1 ┆ banana │ │ 2 ┆ apple │ │ 3 ┆ mango │ └─────┴────────┘ The optional lazy parameter allows returning Polars LazyFrames. df = duckdb.sql(""" SELEC... - https://man.mtool.work/duckdb/2.0/guides/python/polars.html
- ODBC API on macOS 10117
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
...batch brew install unixodbc DuckDB releases ODBC drivers for macOS on Apple Silicon ( arm64 ) and Intel ( x86_64 ) CPUs. To download the driver for Apple Silicon, run: batch wget https://github.com/... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Building DuckDB from Source 9299
- When Should You Build DuckDB? DuckDB binaries are available for stable and preview builds on the installation page . In most cases, it's recommended to use these binaries. When you are running on an experimental platform (e.g., Raspberry Pi
...er, while earlier versions required a C++11 compiler. DuckDB needs CMake and a C++17-compliant compiler (e.g., GCC, Clang, Apple-Clang, MSVC). Additionally, we recommend using the Ninja build system , which automatically parallelizes the build process...omment linux_amd64 Linux x86_64 (AMD64) with glibc linux_arm64 Linux AArch64 (ARM64) with glibc osx_arm64 macOS 12+ ARM64 (Apple Silicon CPUs) windows_amd64 Windows 10+ x86_64 (AMD64) windows_arm64 Windows 10+ AArch64 (ARM64) For these platforms, buil... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- DuckDB Environment 8624
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...ed when installing extensions . To retrieve the platform, use the following PRAGMA : PRAGMA platform; On macOS, running on Apple Silicon architecture, the result is: platform osx_arm64 On Windows, running on an AMD64 architecture, the platform is wind... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Requirements 8481
- DuckDB is designed to be portable and has very few runtime dependencies. Still, there are a few requirements to be aware of before installing or running DuckDB. Supported Platforms DuckDB officially supports Linux, macOS and Windows on both
...) AWS Graviton, Snapdragon, etc. Full osx_amd64 macOS 12+ x86_64 (AMD64) Intel Partial osx_arm64 macOS 12+ AArch64 (ARM64) Apple Silicon M1, M2, etc. Full windows_amd64 Windows 10+ x86_64 (AMD64) Intel, AMD, etc. Full windows_arm64 Windows 10+ AArch64... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/requiremen...
- Extension Distribution 8090
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...Linux AArch64 (ARM64) AWS Graviton, Snapdragon, etc. osx_amd64 macOS x86_64 (AMD64) Intel osx_arm64 macOS AArch64 (ARM64) Apple Silicon M1, M2, etc. windows_amd64 Windows x86_64 (AMD64) Intel, AMD, etc. windows_arm64 Windows AArch64 (ARM64) Copilot+... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Installing Extensions 7948
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...first 10 characters of the build's commit hash. So for example, the extensions for DuckDB version v0.10.3 on macOS ARM64 (Apple Silicon) are installed to ~/.duckdb/extensions/v0.10.3/osx_arm64/ . An example installation path for a nightly DuckDB buil... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Unity Catalog Extension 7806
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...nd delta extensions support the following platforms: Linux (x86_64 and ARM64): linux_amd64 and linux_arm64 macOS Intel and Apple Silicon: osx_amd64 and osx_arm64 Windows AMD64: windows_amd64 Support for the other DuckDB platforms is work-in-progress.... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- List Functions 7806
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...ription | Concatenates list/array elements with a comma delimiter. | | Example | array_to_string_comma_default(['Banana', 'Apple', 'Melon']) | | Result | Banana,Apple,Melon | concat(value, ...) | Description | Concatenates multiple strings or lists. N... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Text Functions 7806
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...on | Concatenates many strings, separated by separator . NULL inputs are skipped. | | Example | concat_ws(', ', 'Banana', 'Apple', 'Melon') | | Result | Banana, Apple, Melon | contains(string, search_string) | Description | Returns true if search_stri... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
DuckDB 2.0 Documentation / man.mtool.work