Results of 1 - 6 of about 6 for inferred (0.003 sec.)
- Excel Extension – DuckDB 12393
- 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
...nction instead. The 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...s. ignore_errors BOOLEAN false Whether to ignore errors and silently replace cells that cant be cast to the corresponding inferred column type with NULL 's. range VARCHAR automatically inferred The range of cells to read, in spreadsheet notation. For ex...ample, A1:B2 reads the cells from A1 to B2. If not specified the resulting range will be inferred as rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning the s... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Excel Import – DuckDB 10857
- 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
...LECT * FROM read_xlsx ( 'test_excel.xlsx' , range = 'E:Z' ); If no range parameter is provided, the range is automatically inferred as the rectangular region of cells between the first row of consecutive non-empty cells and the first empty row spanning t...el.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 this behavior, set header to false . Detecting Types When not importi...e columns in the Excel sheet based on their contents and/or "number format". TIMESTAMP , TIME , DATE and BOOLEAN types are inferred when possible based on the "number format" applied to the cell. Text cells containing TRUE and FALSE are inferred as BOOLE... - https://man.mtool.work/duckdb/1.3/guides/file_formats/excel_import.html
- ATTACH and DETACH Statements – 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
...atements DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db' ; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'file.db...lite extension for more information): ATTACH 'sqlite_file.db' AS sqlite_db ( TYPE sqlite ); Attach the database file.db if inferred database alias file does not yet exist: ATTACH IF NOT EXISTS 'file.db' ; Attach the database file.db if explicit database... - https://man.mtool.work/duckdb/1.3/sql/statements/attach.html
- Loading JSON – DuckDB 8061
- 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
...types contained within the JSON file (e.g., {key1: 'INTEGER', key2: 'VARCHAR'} ). If auto_detect is enabled these will be inferred STRUCT (empty) dateformat Specifies the date format to use when parsing dates. See Date Format VARCHAR iso maximum_depth M...types contained within the JSON file (e.g., {key1: 'INTEGER', key2: 'VARCHAR'} ). If auto_detect is enabled these will be inferred STRUCT (empty) compression The compression type for the file. By default this will be detected automatically from the file... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Python Function API – DuckDB 7695
- 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
...┌─────────────┐ │ my_func(42) │ │ varchar │ ├─────────────┤ │ 42 │ └─────────────┘ If only the parameter list types can be inferred, you'll need to pass in None as parameters . NULL Handling By default when functions receive a NULL value, this instantly... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- Node.js Client (Neo) – DuckDB 7604
- 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
...Value ([ 10 , 11 , 12 ]), }, { ' a ' : VARCHAR , ' b ' : INTEGER , ' c ' : LIST ( INTEGER ), }); Unspecified types will be inferred: const result = await connection . run ( ' select $a, $b, $c ' , { ' a ' : ' duck ' , ' b ' : 42 , ' c ' : listValue ([ 10... - https://man.mtool.work/duckdb/1.3/clients/node_neo/overview.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work