Results of 1 - 10 of about 102 for Below (0.003 sec.)
- UNPIVOT Statement – DuckDB 12410
- 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
...s site . The PIVOT statement is the inverse of the UNPIVOT statement. Simplified UNPIVOT Syntax The full syntax diagram is below, but the simplified UNPIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: UNPIVOT dataset...column(s)_with_order_direction(s) LIMIT number_of_rows ; Example Data All examples use the dataset produced by the queries below: CREATE OR REPLACE TABLE monthly_sales ( empid INTEGER , dept TEXT , Jan INTEGER , Feb INTEGER , Mar INTEGER , Apr INTEGER...are not empid or dept . This enables dynamic unpivoting that will work regardless of how many months are added. The query below returns identical results to the one above. UNPIVOT monthly_sales ON COLUMNS ( * EXCLUDE ( empid , dept )) INTO NAME month... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- PIVOT Statement – DuckDB 11892
- 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
...als site . The UNPIVOT statement is the inverse of the PIVOT statement. Simplified PIVOT Syntax The full syntax diagram is below, but the simplified PIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: PIVOT dataset ON c...uses are each optional, but they may not all be omitted. Example Data All examples use the dataset produced by the queries below: CREATE TABLE cities ( country VARCHAR , name VARCHAR , year INTEGER , population INTEGER ); INSERT INTO cities VALUES ( '...S New York City 2000 8015 US New York City 2010 8175 US New York City 2020 8772 PIVOT ON and USING Use the PIVOT statement below to create a separate column for each year and calculate the total population in each. The ON clause specifies which column... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- Comparisons – DuckDB 10494
- 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
...Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Comparisons Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is...3 true >= greater than or equal to 4 >= NULL NULL = or == equal NULL = NULL NULL <> or != not equal 2 <> 2 false The table below shows the standard distinction operators. These operators treat NULL values as equal. Operator Description Example Result...ators. These behave much like operators, but have special syntax mandated by the SQL standard. They are shown in the table below. Note that BETWEEN and NOT BETWEEN are only equivalent to the examples below in the cases where both a , x and y are of th... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Querying Parquet Metadata – DuckDB 10145
- 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
...even to obtain a quick overview of what the different columns contain: SELECT * FROM parquet_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_metadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_ro...LECT * FROM 'test.parquet' ; Fetch the internal schema of a Parquet file: SELECT * FROM parquet_schema ( 'test.parquet' ); Below is a table of the columns returned by parquet_schema . Field Type file_name VARCHAR name VARCHAR type VARCHAR type_length...data such as the format version and the encryption algorithm used: SELECT * FROM parquet_file_metadata ( 'test.parquet' ); Below is a table of the columns returned by parquet_file_metadata . Field Type file_name VARCHAR created_by VARCHAR num_rows BIG... - https://man.mtool.work/duckdb/1.3/data/parquet/metadata.html
- Types API – DuckDB 9278
- 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
...ance. This means that wherever a DuckDBPyType object is expected, it is also possible to provide any of the options listed below. Python Built-Ins The table below shows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bo...ol BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR Numpy DTypes The table below shows the mapping of Numpy DType to DuckDB type. Type DuckDB type bool BOOLEAN float32 FLOAT float64 DOUBLE int16 SMALLINT...str] 関連キーワード type DuckDBPyType duckdb typing Union dict types objects list import Parameters DuckDB uint Types also below float child print instance table shows mapping Built-in bytearray 関連するページ Python Client API Conversion between Duck... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- Iceberg REST Catalogs – DuckDB 9110
- 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
...g to Amazon S3 tables or Amazon Sagemaker Lakehouse . For all other Iceberg REST Catalogs, you can follow the instructions below. Please see the Examples section for questions about specific catalogs. Most Iceberg REST Catalogs authenticate via OAuth2...thorization can also be attached with just an ATTACH statement. See the complete list of ATTACH options for a REST catalog below. Parameter Type Default Description ENDPOINT_TYPE VARCHAR NULL Used for attaching S3Tables or Glue catalogs. Allowed value...th Access Token Specific Catalog Examples R2 Catalog To attach to an R2 cloudflare managed catalog follow the attach steps below. CREATE SECRET r2_secret ( TYPE ICEBERG , TOKEN ' r2_token ' ); You can create a token by following the create an API toke... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
- Timestamp with Time Zone Functions – DuckDB 8579
- 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
.... See also the related TIMESTAMP functions . Time zone support is provided by the built-in ICU extension . In the examples below, the current time zone is presumed to be America/Los_Angeles using the Gregorian calendar. Built-In Timestamp with Time Zo...ne Functions The table below shows the available scalar functions for TIMESTAMPTZ values. Since these functions do not involve binning or display, they...10-08 04:13:34-07 -- the offset will differ based on your local time zone ICU Timestamp with Time Zone Operators The table below shows the available mathematical operators for TIMESTAMP WITH TIME ZONE values provided by the ICU extension. Operator Des... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Syntax Highlighting – DuckDB 8411
- 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
...can be configured using dot commands . Syntax highlighting can also be disabled entirely using the .highlight off command. Below is a list of components that can be configured. Type Command Default color Keywords .keyword green Constants ad literals ....name (e.g., .keyword red ), or by directly providing a terminal code to use for rendering (e.g., .keywordcode \033[31m ). Below is a list of supported color names and their corresponding terminal codes. Color Terminal code red \033[31m green \033[32m...gured disabled keyword green yellow brightblack Highlighting queries shell automatically syntax different commands command Below list constant 関連するページ Dot Commands CLI Client Embedding DuckDB CREATE SECRET Statement List Type Securing DuckDB Se... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Boolean Type – DuckDB 8411
- 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
...> 10 is false and NULL > 10 is NULL ): i 15 Conjunctions The AND / OR conjunctions can be used to combine Boolean values. Below is the truth table for the AND conjunction (i.e., x AND y ). X X AND true X AND false X AND NULL true true false NULL fals...e false false false NULL NULL false NULL Below is the truth table for the OR conjunction (i.e., x OR y ). X X OR true X OR false X OR NULL true true true true false true...s truth tuples table integers Logical statement created conjunctions example used filter case predicate evaluates filtered Below conjunction Operators Documentation Types Copy Markdown Type 関連するページ NULL Values Logical Operators Loops CASE Expre... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
- MySQL Extension – DuckDB 8230
- 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
...nect to MySQL as a set of key=value pairs. Any options not provided are replaced by their default values, as per the table below. Connection information can also be specified with environment variables . If no option is provided explicitly, the MySQL...TYPE mysql , SECRET mysql_secret_one ); SSL Connections The ssl connection parameters can be used to make SSL connections. Below is a description of the supported parameters. Setting Description ssl_mode The security state to use for the connection to...B to, for example, export data that is stored in a MySQL database to Parquet, or read data from a Parquet file into MySQL. Below is a brief example of how to create a new table in MySQL and load data into it. ATTACH 'host=localhost user=root port=0 da... - https://man.mtool.work/duckdb/1.3/core_extensions/mysql.html
DuckDB 1.3 Documentation / man.mtool.work