Results of 1 - 10 of about 80 for Standard (0.002 sec.)
- Comparisons 13355
- Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of the comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than
...r than or equal to 4 >= NULL NULL = or == equal 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 no...creating a macro with the typeof function or implementing a user-defined function . BETWEEN and IS [NOT] NULL Besides the standard comparison operators there are also the BETWEEN and IS (NOT) NULL operators. These behave much like operators, but have sp...ecial syntax mandated by the SQL standard. They are shown in the table below. Note that BETWEEN and NOT BETWEEN are only equivalent to the examples below in the cas... - https://man.mtool.work/duckdb/2.0/sql/expressions/comparison_operators.html
- UNPIVOT Statement 13355
- 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 contains the name of the source column) and a VALUE column (which contain
...s the value from the 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...An UNPIVOT may be used in a subquery and must be wrapped in parentheses. Note that this behavior is different than the SQL Standard Unpivot, as illustrated in subsequent examples. SELECT * FROM ( UNPIVOT monthly_sales ON COLUMNS(* EXCLUDE (empid, dept))...ue col1 84 col2 woot Simplified UNPIVOT Full Syntax Diagram Below is the full syntax diagram of the UNPIVOT statement. SQL Standard UNPIVOT Syntax The full syntax diagram is below, but the SQL Standard UNPIVOT syntax can be summarized as: FROM [dataset]... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- PIVOT Statement 9629
- 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 distinct value. DuckDB i
...mplements both the SQL Standard PIVOT syntax and a simplified PIVOT syntax that automatically detects the columns to create while pivoting. PIVOT_WIDER ma...s; A PIVOT may be used in a subquery and must be wrapped in parentheses. Note that this behavior is different than the SQL Standard Pivot, as illustrated in subsequent examples. SELECT * FROM ( PIVOT cities ON year USING sum(population) GROUP BY country...783 9510 NULL 24962 1910 Simplified PIVOT Full Syntax Diagram Below is the full syntax diagram of the PIVOT statement. SQL Standard PIVOT Syntax The full syntax diagram is below, but the SQL Standard PIVOT syntax can be summarized as: SELECT * FROM ⟨data... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- SQL to/from JSON 9341
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...44073709551615,"query_location_length":0},"where_clause":null,"group_expressions":[],"group_sets":[],"aggregate_handling":"STANDARD_HANDLING","having":null,"sample":null,"qualify":null},"named_param_map":[]}]} Example with multiple statements and skip op...+"]}}],"from_table":{"type":"EMPTY","query_location":18446744073709551615,"query_location_length":0},"aggregate_handling":"STANDARD_HANDLING"}},{"node":{"type":"SELECT_NODE","cte_map":{},"select_list":[{"class":"FUNCTION","type":"FUNCTION","query_locatio...query_location":32,"query_location_length":4,"table_name":"tbl1","qualified_name":{"path":["tbl1"]}},"aggregate_handling":"STANDARD_HANDLING"}}]} Skip the default values in the AST (e.g., "distinct":false ): SELECT json_serialize_sql('SELECT 1 + 2; SELEC... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Java (JDBC) Client 8931
- Installation To use the DuckDB Java (JDBC) client, visit the Java installation page . The latest stable version of the DuckDB Java (JDBC) client is 2.0.0. The DuckDB Java (JDBC) client lets Java applications query DuckDB through the standard
.... See the preview builds page for a full Maven example. Basic API Usage DuckDB's JDBC API implements the main parts of the standard Java Database Connectivity (JDBC) API, version 4.1. Describing JDBC is beyond the scope of this page, see the official doc...the JDBC specification, or the Arrow Methods . Opening a Connection In JDBC, database connections are created through the standard java.sql.DriverManager class, using the jdbc:duckdb: JDBC URL prefix: import java.sql.Connection; import java.sql.DriverMa... - https://man.mtool.work/duckdb/2.0/clients/java/overview.html
- Run Queries 8657
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...nnection these run on, see Define Connections . Sending Queries DuckDB supports the standard JDBC methods to send queries and retrieve result sets. First a Statement object has to be created from the Connection , th...h factory method attaches the SQL type name the driver needs to marshal the value. createArrayOf(typeName, elements) — the standard JDBC method — returns an org.duckdb.user.DuckDBUserArray (a java.sql.Array ) for a LIST or ARRAY , where typeName is the e...lement type. createStruct(typeName, attributes) — the standard JDBC method — returns an org.duckdb.user.DuckDBUserStruct (a java.sql.Struct ), where typeName is the STRUCT type and attr... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- LIMIT and OFFSET Clauses 8520
- LIMIT is an output modifier. Logically it is applied at the very end of the query. The LIMIT clause restricts the amount of rows fetched. The OFFSET clause indicates at which position to start reading the values, i.e., the first OFFSET valu
...DESC LIMIT 5; Select 10% of the rows from the addresses table: SELECT * FROM addresses LIMIT 10%; FETCH FIRST New The SQL-standard FETCH FIRST syntax was introduced in DuckDB 2.0. As an alternative to LIMIT , DuckDB supports the SQL-standard FETCH FIRST... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/limit.html
- SQL Quirks 8246
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...functions sum , list , and string_agg all return NULL instead of 0 , [] and '' , respectively. This is dictated by the SQL Standard and obeyed by all SQL implementations we know. This behavior is inherited by the list aggregate list_sum , but not by the...DuckDB original list_dot_product which returns 0 on empty lists. 0 vs. 1-Based Indexing To comply with standard SQL, one-based indexing is used almost everywhere, e.g., array and string indexing and slicing, and window functions ( row... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Execution Format 8095
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...erators in DuckDB are optimized to work on Vectors of a fixed size. This fixed size is commonly referred to in the code as STANDARD_VECTOR_SIZE . The default STANDARD_VECTOR_SIZE is 2048 tuples. Vector Format Vectors logically represent arrays that conta...t of supported vector formats is shown. Flat Vectors Flat vectors are physically stored as a contiguous array, this is the standard uncompressed vector format. For flat vectors the logical and physical representations are identical. Constant Vectors Cons... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Dot Commands 7958
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...nt literal STRING .progress_bar ⟨COMPONENT⟩ Set the progress bar component styles .prompt ⟨OPTIONS⟩ ⟨CONTINUE⟩ Replace the standard prompts .quit Exit this program .read ⟨FILE⟩ Read input from FILE .read_line_version ⟨linenoise/fallback⟩ Set the library...e render mode to multi-line .output : Writing Results to a File By default, the DuckDB CLI sends results to the terminal's standard output. However, this can be modified using either the .output or .once commands. Pass in the desired output file location...as a parameter. The .once command will only output the next set of results and then revert to standard out, but .output will redirect all subsequent output to that file location. Note that each result will overwrite the entir... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work