Results of 1 - 10 of about 113 for columns (0.007 sec.)
- Relational API – DuckDB 12032
- 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
...limiter : Optional[str] Alternative delimiter to use. dtype : Optional[Dict[str, str]], Optional[List[str]] Data types for columns. na_values : Optional[str], Optional[List[str]] Additional strings to recognize as NA/NaN. skiprows : Optional[int] Number...estamps. sample_size : Optional[int] Number of rows to sample for schema inference. all_varchar : Optional[bool] Treat all columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_padding : Optional[bool] Enable nul...l padding for rows with missing columns. names : Optional[List[str]] List of column names to use. lineterminator : Optional[str] Character to break lines on. colu... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Star Expression – DuckDB 11994
- 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
.../ SQL / Expressions Copy Markdown Star Expression Syntax The * expression can be used in a SELECT statement to select all columns that are projected in the FROM clause. SELECT * FROM tbl ; TABLE.* and STRUCT.* The * expression can be prepended by a tab...le name to select only columns from that table. SELECT table_name . * FROM table_name JOIN other_table_name USING ( id ); Similarly, the * expression can...also be used to retrieve all keys from a struct as separate columns. This is particularly useful when a prior operation creates a struct of unknown shape, or if a query must handle any poten... - https://man.mtool.work/duckdb/1.3/sql/expressions/star.html
- UNPIVOT Statement – DuckDB 10544
- 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
...t Sitemap Live Demo Documentation / SQL / Statements Copy Markdown UNPIVOT Statement The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which c...source column). DuckDB implements both the SQL Standard UNPIVOT syntax and a simplified UNPIVOT syntax. Both can utilize a COLUMNS expression to automatically detect the columns to unpivot. PIVOT_LONGER may also be used in place of the UNPIVOT keyword....Jun 60 3 cars Jan 100 3 cars Feb 200 3 cars Mar 300 3 cars Apr 400 3 cars May 500 3 cars Jun 600 UNPIVOT Dynamically Using Columns Expression In many cases, the number of columns to unpivot is not easy to predetermine ahead of time. In the case of this... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- Python Client API – DuckDB 10090
- 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
...ion object from the CSV file in ‘name' read_json ( self : duckdb.duckdb.DuckDBPyConnection , path_or_buffer : object , * , columns : Optional [ object ] = None , sample_size : Optional [ object ] = None , maximum_depth : Optional [ object ] = None , rec...any_value ( self : duckdb.duckdb.DuckDBPyRelation , column : str , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → duckdb.duckdb.DuckDBPyRelation ¶ Returns the first non-null value from a given column Detailed examples can...PyRelation , function_name : str , function_aggr : str , group_expr : str = '' , function_parameter : str = '' , projected_columns : str = '' ) → duckdb.duckdb.DuckDBPyRelation ¶ Compute the function of a single column or a list of columns by the option... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- PIVOT Statement – DuckDB 9636
- 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
...ts Copy Markdown PIVOT Statement The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each dist...t value. DuckDB implements both the SQL Standard PIVOT syntax and a simplified PIVOT syntax that automatically detects the columns to create while pivoting. PIVOT_WIDER may also be used in place of the PIVOT keyword. For details on how the PIVOT stateme...w, but the simplified PIVOT syntax can be summarized using spreadsheet pivot table naming conventions as: PIVOT dataset ON columns USING values GROUP BY rows ORDER BY columns_with_order_directions LIMIT number_of_rows ; The ON , USING , and GROUP BY cla... - https://man.mtool.work/duckdb/1.3/sql/statements/pivot.html
- SELECT Clause – DuckDB 8942
- 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
...t Sitemap Live Demo Documentation / SQL / Query Syntax Copy Markdown SELECT Clause The SELECT clause specifies the list of columns that will be returned by the query. While it appears first in the clause, logically the expressions here are executed only...n contain arbitrary expressions that transform the output, as well as aggregates and window functions. Examples Select all columns from the table called table_name : SELECT * FROM table_name ; Perform arithmetic on the columns in a table, and provide an...ty FROM addresses ; Return the total number of rows in the addresses table: SELECT count ( * ) FROM addresses ; Select all columns except the city column from the addresses table: SELECT * EXCLUDE ( city ) FROM addresses ; Select all columns from the ad... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- INSERT Statement – DuckDB 8337
- 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 table: INSERT INTO tbl SELECT * FROM other_tbl ; Insert values into the i column, inserting the default value into other columns: INSERT INTO tbl ( i ) VALUES ( 1 ), ( 2 ), ( 3 ); Explicitly insert the default value into a column: INSERT INTO tbl ( i...pe, automatic type conversion will be attempted. INSERT INTO ... [BY POSITION] The order that values are inserted into the columns of the table is determined by the order that the columns were declared in. That is, the values supplied by the VALUES clau...termine the order that values should be inserted into the table. This allows inserting even in cases when the order of the columns in the table differs from the order of the values in the SELECT statement or certain columns are missing. For example: CRE... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- CSV Auto Detection – DuckDB 8110
- 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 roughly as follows: Detect the dialect of the CSV file (delimiter, quoting rule, escape) Detect the types of each of the columns Detect whether or not the file has a header row By default the system will try to auto-detect all options. However, option...e delimiter \r\n Comment Comment character # SkipRows Number of rows skipped 1 HasHeader Whether the CSV has a header true Columns Column types encoded as a LIST of STRUCT s ({'name': 'VARCHAR', 'age': 'BIGINT'}) DateFormat Date format %d/%m/%Y Timestam...pt = FROM read_csv('my_file.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, header=true, columns={...}); Detection Steps Dialect Detection Dialect detection works by attempting to parse the samples using the set of cons... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- CREATE TABLE Statement – DuckDB 7731
- 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
...CREATE TABLE Statement The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 ( i INTEGER , j INTEGER ); Create a table with a primary key: CREATE TABLE t1 ( id INTEGER PR...ew table. This is shorthand for dropping the existing table and then creating the new one. Create a table with two integer columns (i and j) even if t1 already exists: CREATE OR REPLACE TABLE t1 ( i INTEGER , j INTEGER ); IF NOT EXISTS The IF NOT EXISTS...lready exists, no action will be taken and the existing table will remain in the database. Create a table with two integer columns ( i and j ) only if t1 does not exist yet: CREATE TABLE IF NOT EXISTS t1 ( i INTEGER , j INTEGER ); CREATE TABLE ... AS SE... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- COPY Statement – DuckDB 7618
- 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
...from an external file into an existing table. The data is appended to whatever data is in the table already. The amount of columns inside the file must match the amount of columns in the table table_name , and the contents of the columns must be convert...ible to the column types of the table. In case this is not possible, an error will be thrown. If a list of columns is specified, COPY will only copy the data in the specified columns from the file. If there are any columns in the table t...hat are not in the column list, COPY ... FROM will insert the default values for those columns Copy the contents of a comma-separated file test.csv without a header into the table test : COPY test FROM 'test.csv' ; Co... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
DuckDB 1.3 Documentation / man.mtool.work