Results of 1 - 10 of about 24 for constant (0.003 sec.)
- Execution Format – DuckDB 14144
- 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
...this is the standard uncompressed vector format. For flat vectors the logical and physical representations are identical. Constant Vectors Constant vectors are physically stored as a single constant value. Constant vectors are useful when data elements...are repeated – for example, when representing the result of a constant expression in a function call, the constant vector allows us to only store the value once. SELECT lst || 'duckdb' FROM ran...teral is the same for every row. In a flat vector, we would have to duplicate the literal 'duckdb' once for every row. The constant vector allows us to only store the literal once. Constant vectors are also emitted by the storage when decompressing from... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- SQL to/from JSON – DuckDB 11843
- 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
...ments in the same query context as the pragma, although with the limitation that the serialized JSON must be provided as a constant string, i.e., you cannot do PRAGMA json_execute_serialized_sql(json_serialize_sql(...)) . Note that these functions do not...); {"error":false,"statements":[{"node":{"type":"SELECT_NODE","modifiers":[],"cte_map":{"map":[]},"select_list":[{"class":"CONSTANT","type":"VALUE_CONSTANT","alias":"","query_location":7,"value":{"type":{"id":"INTEGER","type_info":null},"is_null":false,"...CT_NODE","select_list":[{"class":"FUNCTION","type":"FUNCTION","query_location":9,"function_name":"+","children":[{"class":"CONSTANT","type":"VALUE_CONSTANT","query_location":7,"value":{"type":{"id":"INTEGER"},"is_null":false,"value":1}},{"class":"CONSTAN... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
- Expression API – DuckDB 10908
- 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 │ c │ │ int64 │ int64 │ ├───────┼───────┤ │ 1 │ 42 │ │ 2 │ 21 │ │ 3 │ 13 │ │ 4 │ 14 │ └───────┴───────┘ Constant Expression This expression contains a single value. import duckdb import pandas as pd df = pd . DataFrame ({ 'a' : [ 1 , 2..., 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 14 ] }) const = duckdb . ConstantExpression ( 'hello' ) duckdb . df ( df ). select ( const ). show () ┌─────────┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hell......) blocks can be added with .when(condition = ..., value = ...) . import duckdb import pandas as pd from duckdb import ( ConstantExpression , ColumnExpression , CaseExpression ) df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , Fals... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Node.js API – DuckDB 9374
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...r property of duckdb duckdb~ERROR : number Check that errno attribute equals this to check for a duckdb error Kind : inner constant of duckdb duckdb~OPEN_READONLY : number Open database in readonly mode Kind : inner constant of duckdb duckdb~OPEN_READWRI...TE : number Currently ignored Kind : inner constant of duckdb duckdb~OPEN_CREATE : number Currently ignored Kind : inner constant of duckdb duckdb~OPEN_FULLMUTEX : number Cur...rently ignored Kind : inner constant of duckdb duckdb~OPEN_SHAREDCACHE : number Currently ignored Kind : inner constant of duckdb duckdb~OPEN_PRIVATECACHE : nu... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Syntax Highlighting – DuckDB 8690
- 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
...ight off command. Below is a list of components that can be configured. Type Command Default color Keywords .keyword green Constants ad literals .constant yellow Comments .comment brightblack Errors .error red Continuation .cont brightblack Continuation...n \033[96m brightwhite \033[97m For example, here is an alternative set of syntax highlighting colors: .keyword brightred .constant brightwhite .comment cyan .error yellow .cont blue .cont_sel brightblue If you wish to start up the CLI with a different s...led 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 See this page as... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Utility Functions – DuckDB 8607
- 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 value. Accepts 1 or more parameters. Each expression can be a column, literal value, function result, or many others. constant_or_null(arg1, arg2) If arg2 is NULL , return NULL . Otherwise, return arg1 . count_if(x) Aggregate function; rows contribu...hash of the string . stats(expression) Returns a string with statistics about the expression. Expression can be a column, constant, or SQL expression. txid_current() Returns the current transaction's identifier, a BIGINT value. It will assign a new one...lumn, literal value, function result, or many others. Example coalesce(NULL, NULL, 'default_string') Result default_string constant_or_null(arg1, arg2) Description If arg2 is NULL , return NULL . Otherwise, return arg1 . Example constant_or_null(42, NULL... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Dot Commands – DuckDB 8440
- 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
...directory to DIRECTORY .changes on/off Show number of rows changed by SQL .columns Column-wise rendering of query results .constant COLOR Sets the syntax highlighting color used for constant values .constantcode CODE Sets the syntax highlighting terminal...code used for constant values .databases List names and files of attached databases .echo on/off Turn command echo on or off .exit CODE Exit this...urn off the highlighter: .highlight off To turn on the highlighter: .highlight on To configure the color used to highlight constants: .constant [red|green|yellow|blue|magenta|cyan|white|brightblack|brightred|brightgreen|brightyellow|brightblue|brightmage... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Timestamp Functions – DuckDB 8256
- 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
...undaries between the timestamps. date_part([part, ...], timestamp) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamp) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number of comple...timestamps. datepart([part, ...], timestamp) Alias of date_part . Get the listed subfields as a struct . The list must be constant. datepart(part, timestamp) Alias of date_part . Get subfield (equivalent to extract ). datesub(part, startdate, enddate) A...01:58:00') Result 2 date_part([part, ...], timestamp) Description Get the listed subfields as a struct . The list must be constant. Example date_part(['year', 'month', 'day'], TIMESTAMP '1992-09-20 20:38:40') Result {year: 1992, month: 9, day: 20} date_... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
- Timestamp with Time Zone Functions – DuckDB 8173
- 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
...daries between the timestamps. date_part([part, ...], timestamptz) Get the listed subfields as a struct . The list must be constant. date_part(part, timestamptz) Get subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number of comp...timestamps. datepart([part, ...], timestamptz) Alias of date_part. Get the listed subfields as a struct . The list must be constant. datepart(part, timestamptz) Alias of date_part. Get subfield (equivalent to extract ). datesub(part, startdate, enddate)...1:58:00') Result 2 date_part([part, ...], timestamptz) Description Get the listed subfields as a struct . The list must be constant. Example date_part(['year', 'month', 'day'], TIMESTAMPTZ '1992-09-20 20:38:40-07') Result {year: 1992, month: 9, day: 20}... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Overview of DuckDB Internals – DuckDB 8006
- 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
...sion represents an expression within a SQL statement. This can be e.g., a reference to a column, an addition operator or a constant value. The type of the ParsedExpression indicates what it represents, e.g., a comparison is represented as a ComparisonExp...te an optimized query plan. The following query optimizers are run: Expression Rewriter : Simplifies expressions, performs constant folding Filter Pushdown : Pushes filters down into the query plan and duplicates filters over equivalency sets. Also prune... - https://man.mtool.work/duckdb/1.3/internals/overview.html
DuckDB 1.3 Documentation / man.mtool.work