Results of 1 - 10 of about 370 for Conversion (0.004 sec.)
- Conversion between DuckDB and Python – DuckDB 17101
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...ew Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / Python Copy Markdown Conversion between DuckDB and Python This page documents the rules for converting Python objects to DuckDB and DuckDB results to Pyth...on . Object Conversion: Python Object to DuckDB This is a mapping of Python object types to DuckDB Logical Types : None → NULL bool → BOOLEAN dat... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- TRY expression – DuckDB 9444
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...expression. When they are wrapped into as TRY expression, they return NULL : Casting Without TRY SELECT 'abc' :: INTEGER ; Conversion Error: Could not convert string 'abc' to INT32 With TRY SELECT TRY ( 'abc' :: INTEGER ); NULL Logarithm on Zero Without TR...ows Without TRY WITH cte AS ( FROM ( VALUES ( '123' ), ( 'test' ), ( '235' )) t ( a )) SELECT a :: INTEGER AS x FROM cte ; Conversion Error: Could not convert string 'test' to INT32 With TRY WITH cte AS ( FROM ( VALUES ( '123' ), ( 'test' ), ( '235' )) t (... - https://man.mtool.work/duckdb/1.3/sql/expressions/try.html
- Timestamp Types – DuckDB 8290
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...e created first and then be combined with a time zone specification to obtain a time zone aware TIMESTAMP WITH TIME ZONE . Conversion between Strings and Naïve / Time Zone-Aware Timestamps The conversion between strings without UTC offsets or IANA time zon...e names and WITHOUT TIME ZONE types is unambiguous and straightforward. The conversion between strings with UTC offsets or time zone names and WITH TIME ZONE types is also unambiguous, but requires the ICU ext... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Literal Types – DuckDB 8052
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEGER and VARCHAR types. N...nation only works with single-quoted string literals, and does not work with other kinds of string values. Implicit String Conversion STRING_LITERAL instances can be implicitly converted to any other type. For example, we can compare string literals with d... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Python API – DuckDB 7594
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...({ "a" : [ 42 ]}) duckdb . sql ( "SELECT * FROM arrow_table" ) ┌───────┐ │ a │ │ int64 │ ├───────┤ │ 42 │ └───────┘ Result Conversion DuckDB supports converting query results efficiently to a variety of formats. See the result conversion page for more info...L DuckDB Home Code of Conduct Trademark Use Blog In this article Installation Basic API Usage Data Input DataFrames Result Conversion Writing Data to Disk Connection Options Using an In-Memory Database Persistent Storage Configuration Connection Object and... - https://man.mtool.work/duckdb/1.3/clients/python/overview.html
- Avro Extension – DuckDB 6898
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...e ); This will result in an additional column in the result set that contains the actual filename of the Avro file. Schema Conversion This extension automatically translates the Avro Schema to the DuckDB schema. All Avro types can be translated, except for...ndation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article The read_avro Function File IO Schema Conversion Implementation Limitations and Future Plans... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- Executing SQL in Python – DuckDB 6202
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...). show () By default this will create a relation object. The result can be converted to various formats using the result conversion functions. For example, the fetchall method can be used to convert the result to Python objects. results = duckdb . sql (... - https://man.mtool.work/duckdb/1.3/guides/python/execute_sql.html
- Spatial Extension – DuckDB 5973
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...plicitly specialized for these types so far. All of these new types are implicitly castable to GEOMETRY , but with a small conversion cost, so the GEOMETRY type is still the recommended type to use for now if you are planning to work with a lot of differen... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/overview.html
- Reading Faulty CSV Files – DuckDB 5973
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...ation as possible to allow users to evaluate them directly in their CSV file. This is an example for a full error message: Conversion Error: CSV Error on Line: 5648 Original Line: Pedro,The 90s Error when converting column "birth_date". date field value ou...ion regarding where the error occurred, including the line number, the original CSV line, and which field was problematic: Conversion Error: CSV Error on Line: 5648 Original Line: Pedro,The 90s Error when converting column "birth_date". date field value ou... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Integration with Polars – DuckDB 5973
- 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
...ode.js (Neo) Overview ODBC Overview Linux Setup Windows Setup macOS Setup Configuration PHP Python Overview Data Ingestion Conversion between DuckDB and Python DB API Relational API Function API Types API Expression API Spark API API Reference Known Python...sql ( "SELECT * FROM df" ). show () DuckDB to Polars DuckDB can output results as Polars DataFrames using the .pl() result-conversion method. df = duckdb . sql ( """ SELECT 1 AS id, 'banana' AS fruit UNION ALL SELECT 2, 'apple' UNION ALL SELECT 3, 'mango'"... - https://man.mtool.work/duckdb/1.3/guides/python/polars.html
DuckDB 1.3 Documentation / man.mtool.work