Results of 1 - 10 of about 10 for treat (0.005 sec.)
- Reading Multiple Files – DuckDB 13193
- 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
...true ); Parquet Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet' ; Read three Parquet files and treat them as a single table: SELECT * FROM read_parquet ([ 'file1.parquet' , 'file2.parquet' , 'file3.parquet' ]); Read all Par...* FROM read_parquet ( 'dir/**/*.parquet' ); Multi-File Reads and Globs DuckDB can also read a series of Parquet files and treat them as if they were a single table. Note that this only works if the Parquet files have the same schema. You can specify...st Parameter The read_parquet function can accept a list of filenames as the input parameter. Read three Parquet files and treat them as a single table: SELECT * FROM read_parquet ([ 'file1.parquet' , 'file2.parquet' , 'file3.parquet' ]); Glob Syntax... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
- Excel Import – DuckDB 11227
- 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
...target table will be used to coerce the types of the cells in the Excel sheet. Importing a Sheet with/without a Header To treat the first row as containing the names of the resulting columns, use the header parameter: SELECT * FROM read_xlsx ( 'test_...excel.xlsx' , header = true ); By default, the first row is treated as a header if all the cells in the first row (within the inferred or supplied range) are non-empty strings. To disable...e cells are inferred as VARCHAR or DOUBLE based on their contents. This behavior can be adjusted in the following ways. To treat all empty cells as VARCHAR instead of DOUBLE , set empty_as_varchar to true : SELECT * FROM read_xlsx ( 'test_excel.xlsx'... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- Excel Extension – DuckDB 9546
- 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
...following named parameters are supported. Option Type Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR automatically inferred The name of the sheet...an explicit range option is provided, this is false by default, otherwise true . empty_as_varchar BOOLEAN false Whether to treat empty cells as VARCHAR instead of DOUBLE when trying to automatically infer column types. SELECT * FROM read_xlsx ( 'test.... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Comparisons – DuckDB 8420
- 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
...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 IS DISTINCT FROM not equal, including NULL 2 IS DISTINCT FROM NU... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Avro Extension – DuckDB 8152
- 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
...type mapping is very straightforward except for Avro's "unique" way of handling NULL . Unlike other systems, Avro does not treat NULL as a possible value in a range of e.g. INTEGER but instead represents NULL as a union of the actual type with a speci... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- PostgreSQL Compatibility – DuckDB 8152
- 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
...E TABLE MyTaBLe ( x INTEGER ); SELECT * FROM "MyTaBLe" ; ERROR: relation "MyTaBLe" does not exist PostgreSQL does not only treat quoted identifiers as case-sensitive, PostgreSQL treats all identifiers as case-sensitive, e.g., this also does not work:... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Reading and Writing Parquet Files – DuckDB 7866
- 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
...the read_parquet function: SELECT * FROM read_parquet ( 'test.parq' ); Use list parameter to read three Parquet files and treat them as a single table: SELECT * FROM read_parquet ([ 'file1.parquet' , 'file2.parquet' , 'file3.parquet' ]); Read all fil... - https://man.mtool.work/duckdb/1.3/data/parquet/overview.html
- Appender – DuckDB 7580
- 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
.... duckdb_appender_clear_columns Removes all columns from the active column list of the appender, resetting the appender to treat all columns as active. Immediately flushes all previous data. Syntax duckdb_state duckdb_appender_clear_columns ( duckdb_a... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- Relational API – DuckDB 7580
- 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
...parse timestamps. 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...parse timestamps. 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... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Window Functions – DuckDB 7580
- 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
...tion up into independent, unrelated pieces. Partitioning is optional, and if none is specified then the entire relation is treated as a single partition. Window functions cannot access values outside of the partition containing the row they are being...S FOLLOWING EXCLUDE CURRENT ROW ) ORDER BY event , date , athlete ; There are four options for EXCLUDE that specify how to treat the current row: CURRENT ROW – exclude just the current row GROUP – exclude the current row and all its “peers” (rows that... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work