Results of 1 - 10 of about 32 for maximum (0.055 sec.)
- Loading JSON – DuckDB 13000
- 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
...(auto-detected) ignore_errors Whether to ignore parse errors (only possible when format is newline_delimited ). BOOL false maximum_sample_files The maximum number of JSON files sampled for auto-detection. BIGINT 32 maximum_object_size The maximum size o...d . read_ndjson_auto(filename) Alias for read_json with parameter format set to newline_delimited . Parameters Besides the maximum_object_size , format , ignore_errors and compression , these functions have additional parameters: Name Description Type D...ill be inferred STRUCT (empty) dateformat Specifies the date format to use when parsing dates. See Date Format VARCHAR iso maximum_depth Maximum nesting depth to which the automatic schema detection detects types. Set to -1 to fully detect nested JSON t... - https://man.mtool.work/duckdb/1.3/data/json/loading_json.html
- Configuration – DuckDB 12452
- 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
...BOOLEAN ca_cert_file Path to a custom certificate file for self-signed certificates. VARCHAR catalog_error_max_schemas The maximum number of schemas the system will scan for "did you mean…" style errors in the catalog UBIGINT 100 checkpoint_threshold ,...ould be started lazily when needed, or immediately when BEGIN TRANSACTION is called BOOLEAN false index_scan_max_count The maximum index scan count sets a threshold for index scans. If fewer than MAX(index_scan_max_count, index_scan_percentage * total_r...RCHAR LEVEL_ONLY logging_storage Set the logging storage (memory/stdout/file) VARCHAR memory max_memory , memory_limit The maximum memory of the system (e.g., 1GB) VARCHAR 80% of RAM max_temp_directory_size The maximum amount of data stored inside the '... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Relational API – DuckDB 10858
- 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
...ma. auto_type_candidates : Optional[List[str]] List of columns for automatic type inference. max_line_size : Optional[int] Maximum line size in bytes. ignore_errors : Optional[bool] Ignore parsing errors. store_rejects : Optional[bool] Store rejected ro...ma. auto_type_candidates : Optional[List[str]] List of columns for automatic type inference. max_line_size : Optional[int] Maximum line size in bytes. ignore_errors : Optional[bool] Ignore parsing errors. store_rejects : Optional[bool] Store rejected ro..._buffer : object , * , columns : typing . Optional [ object ] = None , sample_size : typing . Optional [ object ] = None , maximum_depth : typing . Optional [ object ] = None , records : typing . Optional [ str ] = None , format : typing . Optional [ st... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Spatial Functions – DuckDB 9665
- 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
...of a line between two fractions of total 2D length. ST_M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of a geometry ST_MMin Returns the minimum M coordinate of a geometry ST_MakeEnvelope Create a rectangular pol...ies ST_MakePolygon Create a POLYGON from a LINESTRING shell ST_MakeValid Returns a valid representation of the geometry ST_MaximumInscribedCircle Returns the maximum inscribed circle of the input geometry, optionally with a tolerance. ST_MinimumRotatedR...metry "properly" is contained by the second geometry ST_X Returns the X coordinate of a point geometry ST_XMax Returns the maximum X coordinate of a geometry ST_XMin Returns the minimum X coordinate of a geometry ST_Y Returns the Y coordinate of a point... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Information Schema – DuckDB 9665
- 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
...lable, NO if it is known not nullable. VARCHAR 'YES' data_type Data type of the column. VARCHAR 'DECIMAL(18, 2)' character_maximum_length If data_type identifies a character or bit string type, the declared maximum length; NULL for all other data types...or if no maximum length was declared. INTEGER 255 character_octet_length If data_type identifies a character type, the maximum possible len...gth in octets (bytes) of a datum; NULL for all other data types. The maximum octet length depends on the declared character maximum length (see above) and the character encoding. INTEGER 1073741824 n... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Aggregate Functions – DuckDB 9263
- 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
...first value (null or non-null) from arg . This function is affected by ordering . arg_max(arg, val) Finds the row with the maximum val and calculates the arg expression at that row. Rows where the value of the arg or val expression is NULL are ignored....op n rows ordered by val descending. This function is affected by ordering . arg_max_null(arg, val) Finds the row with the maximum val and calculates the arg expression at that row. Rows where the val expression evaluates to NULL are ignored. This funct...st(arg) Returns a LIST containing all the values of a column. This function is affected by ordering . max(arg) Returns the maximum value present in arg . This function is unaffected by distinctness . max(arg, n) Returns a LIST containing the arg values... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- Known Issues – DuckDB 8989
- 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
...───────┼────────────┼─────────────────────────────────────────────┼────────────┼─────────┤ │ max_memory │ 1638.3 PiB │ The maximum memory of the system (e.g. 1GB) │ VARCHAR │ GLOBAL │ │ memory_limit │ 1638.3 PiB │ The maximum memory of the system (e.g....───────────────────────────────────┴────────────┴─────────┘ 関連キーワード memory varchar PiB limit duckdb settings values maximum system Documentation Client APIs Copy Markdown Known Issues Incorrect Memory Values Distributions Windows Subsystem queryi... - https://man.mtool.work/duckdb/1.3/clients/cli/known_issues.html
- Text Types – DuckDB 8860
- 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
...ariable-length character string VARCHAR(n) CHAR(n) , BPCHAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum length n has no effect and is only provided for compatibility Specifying a Length Limit Specifying the length for the VARC...ECK constraint should be used, for example: CREATE TABLE strings ( val VARCHAR CHECK ( length ( val ) <= 10 ) -- val has a maximum length of 10 ); The VARCHAR field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Specifyi...h strings type characters character Specifying Text storage text literals Types allows Unicode Internally encoded Variable maximum effect compatibility reasons example Type compression zstd Values 関連するページ Bitstring Type Information Schema Values... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Dot Commands – DuckDB 8457
- 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
...duckbox only, default: footer ) .log FILE/off Turn logging on or off . FILE can be stderr / stdout .maxrows COUNT Sets the maximum number of rows for display. Only for duckbox mode .maxwidth COUNT Sets the maximum width in characters. 0 defaults to term...Command The .help text may be filtered by passing in a text string as the first argument. .help m .maxrows COUNT Sets the maximum number of rows for display ( default : 40 ). Only for duckbox mode . .maxwidth COUNT Sets the maximum width in characters... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Unnesting – DuckDB 8457
- 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
...columns that contain lists within lists, or lists of structs. Note that lists within structs are not unnested. Setting the Maximum Depth of Unnesting The max_depth parameter allows limiting the maximum depth of recursive unnesting (which is assumed by d...Code of Conduct Trademark Use Blog In this article Examples Unnesting Lists Unnesting Structs Recursive Unnest Setting the Maximum Depth of Unnesting Keeping Track of List Entry Positions... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/unnest.html
DuckDB 1.3 Documentation / man.mtool.work