Results of 1 - 9 of about 9 for Describing (0.005 sec.)
- Describe – DuckDB 14056
- 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
...Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Guides / Meta Queries Copy Markdown Describe Describing a Table In order to view the schema of a table, use the DESCRIBE statement (or its aliases DESC and SHOW ) followed by the...nt to DESCRIBE tbl; column_name column_type null key default extra i INTEGER NO PRI NULL NULL j VARCHAR YES NULL NULL NULL Describing a Query In order to view the schema of the result of a query, prepend DESCRIBE to a query. DESCRIBE SELECT * FROM tbl ; co...NTEGER YES NULL NULL NULL j VARCHAR YES NULL NULL NULL Note that there are subtle differences: compared to the result when describing a table , nullability ( null ) and key information ( key ) are lost. Using DESCRIBE in a Subquery DESCRIBE can be used a s... - https://man.mtool.work/duckdb/1.3/guides/meta/describe.html
- sqllogictest Introduction – DuckDB 8466
- 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
...rmation on query result verification, see the result verification section . The top of every file should contain a comment describing the name and group of the test. The name of the test is always the relative file path of the file. The group is the folder... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/intro.html
- Interval Type – DuckDB 8466
- 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
...re adding the INTERVAL . Conversely, subtracting two TIMESTAMP s or two TIMESTAMPTZ s from one another creates an INTERVAL describing the difference between the timestamps with only the days and microseconds components. For example: SELECT TIMESTAMP '2000-... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Friendly SQL – DuckDB 8466
- 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
...For those that result in a conflict, replace the columns of the existing row to the new values of the to-be-inserted row. Describing tables and computing statistics: DESCRIBE : provides a succinct summary of the schema of a table or query. SUMMARIZE : ret... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- Java JDBC Client – DuckDB 8340
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...API Usage DuckDB's JDBC API implements the main parts of the standard Java Database Connectivity (JDBC) API, version 4.1. Describing JDBC is beyond the scope of this page, see the official documentation for details. Below we focus on the DuckDB-specific p... - https://man.mtool.work/duckdb/1.3/clients/java.html
- CSV Auto Detection – DuckDB 8340
- 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
...automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works roughly as follows: Detect the dialect of the CSV file (deli... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Versioning of Extensions – DuckDB 8340
- 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
...features are tested in nightly builds before being grouped into a release and pushed to the core repository. Release notes describing what has been added each release should be available to make it easy to understand the difference between versions. Stable... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 8340
- 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 data structure or parameter, and allows the application to specify the structure of data to be bound/retrieved. Use case Describing table structures, result sets, binding columns to application buffers Additional information Used in situations where data... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- Relational API – DuckDB 7980
- 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
...Python function that takes a DataFrame and returns a transformed DataFrame. schema : object, default: None Optional schema describing the structure of the output relation. Example import duckdb from pandas import DataFrame def multiply_by_2 ( df : DataFram... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work